Convert SQL to CSV
Create a CSV file from SQL query results. Runs entirely in your browser, so your data never leaves your device.
0 chars · 0 lines
Output
The result appears here as you type.
How to use Convert SQL to CSV
- 1. Paste your SQL. Paste one or more INSERT INTO statements into the input pane. The parser reads the column list and the parenthesized value tuples, including multiple tuples in a single statement.
- 2. Review the extracted rows. Each value tuple becomes one CSV row, with the columns from the INSERT statement used as the header. There are no settings, since the SQL statement itself defines the structure.
- 3. Copy the CSV result. Copy the plain comma-separated rows and paste them into a spreadsheet to inspect, filter or chart data that otherwise only exists as SQL insert statements.
When to use Convert SQL to CSV
Convert SQL to CSV extracts the rows out of INSERT statements and lays them out as plain comma-separated values. It's useful whenever the data you need is trapped inside a database dump or seed file rather than a proper export.
- Reading a database backup's seed data. A .sql backup file contains INSERT statements for a table you need to inspect without running a full database restore. Extracting them to CSV lets you open the data in a spreadsheet.
- Reviewing a migration's fixture data. A schema migration ships with hardcoded INSERT statements for sample rows. Converting them to CSV makes it easy to eyeball the values without reading through SQL syntax.
- Comparing seed data across environments. You want to diff the sample records inserted in a staging database against production. Turning both sets of INSERT statements into CSV makes a row-by-row comparison possible.
Examples
Extract rows from INSERT statements
Input
INSERT INTO people (name, age) VALUES ('Ada', 36), ('Grace', 45);Output
name,age Ada,36 Grace,45
About the Convert SQL to CSV tool
Convert SQL to CSV does its work locally, right in the browser. Create a CSV file from SQL query results. There is no upload step, no queue and no account, and your data never travels over the network.
It belongs to the CSV Tools collection on EditSafely, a set of 133 small, focused CSV utilities that share the same instant, private workspace.
There is nothing to configure. Provide the input and the result appears on its own. A worked example further down the page shows exactly what the tool produces for a real input.
Running locally also makes the tool fast and dependable: results appear as you type or drop a file, there is no server outage that can take it down mid-task, and confidential data can be processed without a second thought.
Frequently asked questions
Does Convert SQL to CSV cost anything?
Yes, it is completely free. All 2,658 tools on EditSafely work without an account, a subscription or usage limits.
Is it safe to paste sensitive or confidential data?
No data leaves your device. The whole tool is JavaScript that runs inside your browser tab, so there is no upload, no server-side processing and no log of what you did. If you disconnect from the internet after the page loads, it keeps working.
How much text can I process at once?
There is no fixed limit. Because the work happens on your own device rather than on a shared server, the practical ceiling is your machine's memory, which comfortably handles inputs far larger than typical online tools allow.
Do I need to sign up or install anything?
Nothing to install and no account needed. Open the page in any up-to-date browser, including on a phone or tablet, and the tool is ready.
How do I use the result?
The output panel has a one-click copy button, and you can keep refining the input while you work; the result updates in place as you type.