SQL INSERT to CSV
Convert SQL INSERT statements to CSV — extract data from SQL dumps for spreadsheets and data tools.
About SQL INSERT to CSV
SQL database dumps often contain INSERT statements for data export and backup. This tool parses those INSERT statements and extracts the data into CSV format, making it easy to open in Excel, Google Sheets, or import into another system. It handles both single-row and multi-row INSERT VALUE syntax, intelligently extracts column names from the INSERT INTO (col1, col2) syntax, and correctly handles NULL values, quoted strings, and numeric data.
FAQ
What INSERT formats are supported?
Both INSERT INTO table (col1, col2) VALUES (v1, v2) and INSERT INTO table VALUES (v1, v2) are supported. Multi-row inserts INSERT INTO table VALUES (r1), (r2), (r3) are also handled correctly.
How are NULL values handled?
SQL NULL values are converted to empty CSV cells, matching the behavior of most database export tools.