SQL to CSV and JSON Converter

Turn CREATE TABLE and INSERT statements from MySQL, PostgreSQL or SQLite dumps into CSV, JSON or a Markdown table.

About SQL to CSV and JSON Converter

Convert SQL dumps into data you can open in a spreadsheet or use in code. Paste CREATE TABLE and INSERT statements and get the rows as CSV, JSON or a Markdown table. The statements run in an in-memory SQLite database inside your browser, and common MySQL dump syntax (backticks, ENGINE options, AUTO_INCREMENT, KEY lines, backslash-escaped quotes) is adjusted automatically.

When the dump has several tables, type the table name to choose one.

How to use it

  1. Paste the CREATE TABLE and INSERT statements.
  2. Pick CSV, JSON or Markdown, and a table name if there are several.
  3. Copy the result.

Questions

Is my data uploaded?

No. Everything runs in your browser; nothing you paste or open is sent to a server.

Do I need the CREATE TABLE statement?

Yes. INSERT statements need a table to go into. Most dump tools include it.

Why does my PostgreSQL dump fail?

COPY ... FROM stdin blocks are not SQL statements. Export with INSERT statements instead (pg_dump --inserts).

More Data & Converters tools

Home · All Tools · Blog