MOV to MP4 Converter
Convert iPhone and QuickTime video to MP4 for Windows, Android and the web.
SQL to CSV Converter
Pull the rows out of a .sql dump — INSERT statements or pg_dump COPY — straight to CSV.
Drop a .sql dump here, or click to choose one
Converted on your device — the file is never uploaded
CSV
Quick Tool Overview
The SQL to CSV Converter reads the rows out of a .sql dump — INSERT statements, multi-row VALUES lists and PostgreSQL COPY blocks — and exports any table in it as CSV, without a database.
- What it does
- Extracts rows from SQL INSERTs into CSV
- You give it
- A .sql dump or INSERT statements
- You get back
- CSV per table, with real column names
- Best for
- Reading a backup without restoring it
About the SQL to CSV Converter
A .sql dump is the most common way a database leaves a server and the most awkward thing to open. Without a running database you cannot query it, and the rows you actually want are buried in INSERT statements with escaped quotes, NULLs and multi-row VALUES lists.
Paste the dump — or drop the .sql file — and take the data as CSV. Every table in the dump is listed with its row count, MySQL and PostgreSQL escaping are both handled, and pg_dump’s COPY … FROM stdin blocks are read as well as INSERT statements. When an INSERT has no column list, the column names are taken from the CREATE TABLE statement in the same file, so you get real headers rather than column_1. NULL can be written as an empty cell, the word NULL or \N, and a UTF-8 BOM makes the result open cleanly in Excel.
Key features of the SQL to CSV Converter
Column names from CREATE TABLE
A mysqldump INSERT with no column list still gets proper headers.
MySQL and PostgreSQL
Backslash and doubled-quote escaping are both handled, detected from the dump.
COPY blocks too
pg_dump’s COPY … FROM stdin data is read as well as INSERT statements.
Every table listed
Pick the table you want; each downloads under its own name.
NULL your way
An empty cell, the word NULL, or \N for re-importing into MySQL.
How to use the SQL to CSV Converter
-
1
Paste or drop the .sql file
Include the CREATE TABLE statements to get real column names.
-
2
Pick the table
Every table found is listed with how many rows it holds.
-
3
Choose the delimiter and NULL style
Empty cell, the word NULL, or \N for a MySQL re-import.
-
4
Copy or download the CSV
Each table downloads under its own name.
Frequently asked questions
Because the INSERT statements have no column list — mysqldump writes them that way by default — and the CREATE TABLE statement was not in what you pasted. Include it and the real names appear.
Yes. PostgreSQL dumps normally use COPY … FROM stdin with tab-separated data and \N for null; those blocks are read, and standard SQL quoting is detected automatically.
They are kept as text, because there is no database here to run them. A row with NOW() shows NOW() in the cell rather than a made-up timestamp.
Only your device’s memory — the whole dump is parsed in the page. Multi-megabyte dumps work; a gigabyte export is better split first.
Reviews of the SQL to CSV Converter
What people who use the SQL to CSV Converter think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
- 5 0 reviews rated 5 stars
- 4 0 reviews rated 4 stars
- 3 0 reviews rated 3 stars
- 2 0 reviews rated 2 stars
- 1 0 reviews rated 1 star
0 reviews
Newest first
No reviews yet
Be the first to rate the SQL to CSV Converter. It takes half a minute and no account.
Write the first reviewMore converters
Color Name to HEX Converter
All 148 CSS colour names as HEX — and the nearest name for any colour.
Markdown to Word Converter
A real .docx from Markdown — Word heading styles, lists and quotes.
Flow Rate Converter
Convert GPM, L/min, m³/h, CFM and cfs — and time how long a fill takes.
Tailwind to CSS Converter
See the real CSS behind any Tailwind class, generated by Tailwind itself.
Word to HTML Converter
Clean, semantic HTML from a .docx — no Word class soup, images embedded.
vCard to CSV Converter
Turn a .vcf contact file into a spreadsheet — names, numbers, emails and addresses.
YAML to TOML Converter
YAML config into TOML tables — the format Cargo, Hugo and pyproject.toml want.