CSV TO SQL

Which Options Does CSV to SQL Have?

• Dialect: PostgreSQL, MySQL, SQLite, or SQL Server, which sets identifier quoting as "x", `x`, or [x], and N'' strings for SQL Server.
• Table name: the name used in every statement.
• CREATE TABLE: optional, written before the inserts.
• Rows per INSERT: 1, 100, 500, or 1000. SQL Server allows at most 1000.
• Empty cells as NULL: write NULL instead of an empty string.

Single quotes inside values are escaped by doubling them, so a name such as O'Brien is written safely and cannot break out of the string. The live preview in the export bar shows the real first statements with your settings, so you can check quoting and types before downloading.

How Are Column Types Detected?

With type detection on, each column gets a type from its values. Whole numbers become BIGINT or INTEGER, decimals become NUMERIC, DOUBLE, REAL, or FLOAT depending on the dialect, true/false columns become BOOLEAN or BIT, and dates become DATE written as ISO values. Anything else is text. With detection off, every column is text.

1. Clean money and dates first with the column type converter.
2. Turn on type detection and check the CREATE TABLE in the preview.
3. Adjust the table name and rows per INSERT, then download.

How Big Can the SQL Output Be?

As big as the table. Grouping 500 or 1000 rows per INSERT keeps the file smaller and loads faster than one statement per row. Use one row per INSERT when you want a failing row to be easy to find. If a filter is on, only the matching rows are written, which is a quick way to load a subset.

For very large tables, cutting the CSV into parts first with the CSV splitter and converting each part gives several smaller .sql files that are easier to load one at a time.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.