CSV ↔ JSON ↔ SQL Converter

Convert between CSV, JSON, and SQL INSERT statements.

How it works

Convert tabular data between CSV, JSON, and SQL INSERT statements in either direction — paste CSV and get JSON or SQL out, or go the other way from JSON.

  1. Select your input format (CSV or JSON) and paste your data in, replacing the sample.
  2. Choose an output format: JSON, CSV, or SQL INSERT statements.
  3. If exporting SQL, set a table name for the generated INSERT statements.
  4. Click Convert and copy the result.

Common use cases

  • Turning a spreadsheet export (CSV) into JSON for use in an API mock or config file.
  • Generating SQL INSERT statements from a CSV to seed a database table quickly.
  • Converting a JSON API response into CSV for opening in Excel or Google Sheets.
  • Reshaping sample data between formats while prototyping a data pipeline.

FAQ

How are data types inferred for SQL output?
Values are inserted based on their JSON/CSV representation — numbers and booleans are typically written unquoted and strings are quoted, so the resulting INSERT statements work against a table whose columns are compatible types.
Does it validate the JSON schema before converting?
The parser expects an array of flat objects (or a CSV with a header row); it reports a parse error if the input isn't valid CSV or JSON.
Is there a row limit?
No hard limit is enforced, but very large datasets may take a moment to parse and convert.

Continue with another tool

PDF Organizer

Merge, split, delete, and rotate PDF pages.

Financial Calculator

Visualize loan amortization and compound interest growth with interactive charts.

Mock Data

Generate realistic fake data — names, emails, addresses, and more — as JSON, CSV, or SQL.