Convert CSV to SQL INSERT statements

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 uses conservative INSERT INTO syntax rather than database-specific bulk loaders. A CREATE TABLE can be included with it, and its column types are read from the rows in the file you gave it: whole numbers become INTEGER, anything carrying a decimal becomes NUMERIC, true and false become BOOLEAN, and everything else stays TEXT. A leading zero or plus sign on a whole number keeps the column TEXT, because 02134 as a number is 2134. That is a guess made from one file, and the statement says so in a comment above itself, because a column whose first thousand rows are whole numbers is not a promise about the thousand after them. Identifiers are double quoted, which PostgreSQL and SQLite accept and MySQL does not unless ANSI_QUOTES is set. 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 your constraints, indexes, reserved-word rules, or conflict policies, so production database validation remains the user’s responsibility.