CSV, JSON and SQL converter

Free

Online CSV to JSON, JSON to CSV and CSV to SQL converter. Free.

Input

Result

Rows0
Columns0
Delimiter—

How the CSV converter works

You paste a CSV table, some JSON or an SQL INSERT, pick a direction and get the other format immediately. The delimiter can be detected or forced: comma, semicolon, tab or pipe. Quoted fields, including commas inside names, stay intact.

The SQL is an INSERT prepared for copying, not a database connection. You can also reverse it: from INSERT back to CSV or JSON. Everything stays in the browser.

CSV Table ↔ JSON

Each row becomes an object, or an array of objects is laid out as columns again.

JSON Objects ↔ SQL

Turn JSON into an INSERT, or read an INSERT back as an array of objects.

SQL INSERT ↔ CSV

You get an escaped INSERT, or rebuild the CSV table from the written values.

Important: Review the SQL before you run it on a real database. Table and column names are cleaned down to letters, digits and underscores. This is not a schema-guided importer.

Useful notes

  •   Files exported from Excel in Romania often use a semicolon. Leave the delimiter on Auto if you are unsure, or pick it yourself.
  •   A field that contains a comma, semicolon, tab or pipe must be wrapped in quotes.
  •   The JSON must be an array. A single object is not enough — wrap it in [ ].
  •   The recognized SQL is INSERT INTO ... VALUES. SELECT, UPDATE or mixed dumps are not converted.
  •   The INSERT is for preview and copying. No query is executed here. Nothing is saved on the server.