About sql to csv converter
Extract the rows of SQL INSERT statements into CSV you can open in Excel or Google Sheets.
Good for
Inspecting a dump file or sharing data with someone who does not use a database.
A worked example
The statements INSERT INTO items (sku, qty) VALUES ('A1', 5), ('B2', 8); produce a CSV with the header sku,qty and two rows. Open it in Excel to filter, chart or share the numbers with colleagues who do not use SQL.
Check the result
- Quoted text containing commas is wrapped in quotes in the CSV.
- Dates and long numbers may need formatting in Excel after import.
- Multi-line statements and functions inside values may not convert.
Opening in Excel
If special characters look wrong in Excel, import the file as UTF-8 using the Data tab, instead of double-clicking it.
Large dumps
For very large dumps, use your database's own export command, which is faster and handles data types more reliably.
