Paste MySQL INSERT statements (with optional CREATE TABLE) and download as a CSV file that opens in Excel, Google Sheets, or any spreadsheet app. Everything runs in your browser.
📢 Advertisement
Paste MySQL SQL
Paste your CREATE TABLE statement (optional) followed by one or more INSERT INTO statements. Multi-row inserts and various quoting styles are supported.
Preview
📢 Advertisement
Why Convert MySQL to CSV?
CSV is the universal format for moving data between systems. Database administrators, analysts, and developers regularly need to extract data from MySQL and load it into Excel, Google Sheets, or another tool. While you can run mysqldump on a server, this browser tool is faster for one-off conversions, handles dumps that include CREATE TABLE statements, and never touches a server — useful for sensitive data or when you don't have database access.
Typical Use Cases
The most common reason to convert MySQL to CSV is to share data with non-technical colleagues who live in Excel. It's also the standard format for importing data into analytics tools, mailing list managers, accounting software, and any tool that accepts spreadsheet files. Multi-row INSERT statements from mysqldump --extended-insert are supported — paste the whole dump and convert in one go.
Handling Special Values
The converter handles MySQL's NULL values (becomes empty cell), escaped quotes (\\' and ''), and both single and double quoted strings. The output is properly RFC 4180 compliant CSV: fields containing commas, quotes, or newlines are wrapped in double quotes, and internal double quotes are escaped by doubling. UTF-8 encoding is used by default, with an option to add a BOM for Excel compatibility on Windows.
From CREATE TABLE to Headers
If your INSERT statement doesn't include an explicit column list (e.g. INSERT INTO users VALUES (...)), the tool looks for a CREATE TABLE statement earlier in the input to determine the columns. This matches the output of mysqldump by default, so you can paste a complete dump and get the right headers automatically.
Frequently Asked Questions
What MySQL dump formats are supported?
The tool parses standard MySQL INSERT statements: single inserts, multi-row inserts, INSERT ... ON DUPLICATE KEY UPDATE, and INSERT IGNORE. It also reads CREATE TABLE statements to extract column names when the INSERT doesn't include an explicit column list.
Is my data safe?
Yes. All parsing and conversion happens entirely in your browser using JavaScript. The SQL is never sent to any server, never logged, and never stored. Open your browser's network tab to verify — no requests leave your device.
Why CSV and not XLSX?
CSV is universal — opens in Excel, Google Sheets, Numbers, and any spreadsheet app. When opened in Excel, data is automatically placed in cells. UTF-8 encoded CSV with proper quoting for commas, quotes, and newlines. Excel users can save as XLSX from inside Excel if needed.
What if my INSERT doesn't have a column list?
The tool looks for a CREATE TABLE statement earlier in the input to determine columns. Paste the CREATE TABLE and all its INSERTs together, or include the column list explicitly. If no columns can be determined, the output CSV will have generic headers like col_1, col_2, col_3.
How are NULL values handled?
SQL NULL values are converted to empty cells in the CSV. This is the standard convention — Excel interprets empty cells as null/missing. The tool does not write 'NULL' as a string.