FileGizmo — Data & CSV tools
Convert CSV to SQL INSERT statements
Turn CSV rows into escaped SQL INSERT statements locally with configurable table and batch size.
Working locally…
Preparing the browser worker.
Complete
Your file is ready
Simple by design
CSV to SQL in three steps
FileGizmo turns CSV rows into SQL INSERT statements without uploading the source data. Choose a CSV file, enter the destination table name, select a batch size, and decide whether simple numbers, booleans, and nulls should be inferred. The generated script quotes identifiers, escapes embedded single quotes, and groups multiple rows into each statement for more practical imports.
SQL dialects differ, so the output intentionally uses conservative INSERT INTO syntax rather than database-specific bulk loaders or schema creation. Column names come from the CSV header and are quoted safely. Empty values can remain empty strings or become NULL when inference is enabled. Numeric inference accepts only finite decimal values and avoids evaluating formulas or executable content. The browser worker parses large CSV files in chunks and reports progress while building the script. Review the preview and run imports inside a transaction or staging database first. FileGizmo cannot know destination column types, constraints, reserved-word rules, or conflict policies, so production database validation remains the user’s responsibility.
- 1
Choose a CSV file
- 2
Enter a safe table name and batch size
- 3
Generate preview and download the SQL script
Good to know
Frequently asked questions
Which SQL databases are supported?
The output uses broadly compatible quoted strings and INSERT syntax; review it for your database dialect.
How are quotes escaped?
Single quotes inside values are doubled according to standard SQL string syntax.
Are numbers automatically typed?
Optional type inference emits finite numbers and booleans without quotes while keeping other values as strings.
Is CSV data uploaded?
No. Parsing and SQL generation run locally in a browser worker.