Table to JSON / SQL Converter - CSV, TSV, Markdown Online

Paste a CSV, TSV, semicolon, pipe or Markdown table and convert it to JSON, JSONL or SQL INSERT statements instantly in your browser.

Input Table

or drop a .csv / .tsv file

Output

About Table to JSON / SQL
Auto-detects delimiter, supports RFC-4180 quoted fields, coerces numbers/booleans/nulls, and outputs JSON objects, JSON arrays, JSONL, or parameter-safe SQL INSERT statements. Pure browser — your data never leaves your device.
Continue Enhancing Your Images
Take your photo editing to the next level with these popular tools
📝
Add Text to Image
Add captions and titles to your enhanced photo
🖼️
Add Photo Border
Frame your effect with beautiful borders
🗜️
Compress Image
Optimize your enhanced image for sharing
📐
Resize Image
Change image dimensions
Explore All Photo Tools
Frequently Asked Questions
Paste a CSV (or drop a .csv file) into the input panel and the tool detects the delimiter automatically, parses each row into a JSON object using the header line as keys, and shows the output instantly. Switch the output format to JSON array, JSONL, or SQL INSERT to get exactly the shape you need.
usage
Yes. The parser follows RFC 4180 — fields wrapped in double quotes can contain commas, newlines and even literal quotes (escaped as "") without breaking parsing. So a value like "Smith, John" remains a single cell, not two.
technical
The tool counts tabs, commas, semicolons and pipes on the first non-empty line and picks the most-frequent one. If you have an unusual or ambiguous file, you can override auto-detect and select tab (TSV), comma, semicolon, pipe or Markdown table manually.
technical
Switch the output format to SQL INSERT and enter a table name. The tool sanitises column names to valid identifiers (replacing spaces, dashes, etc. with underscores) and produces one INSERT per row with properly-escaped string literals, numeric values, and NULL for empty cells. Perfect for seeding databases or migrating data.
features
JSONL (JSON Lines) puts one JSON object per line, with no surrounding array. It is the standard format for streaming data into BigQuery, Snowflake, Logstash, Elasticsearch and most machine-learning pipelines. Pick JSONL when each row will be ingested independently.
features
Yes. Values matching integer or decimal patterns are emitted as JSON numbers, the literals "true"/"false" become booleans, and empty cells become null. If you need everything as strings, prepare the values accordingly before converting.
technical
Yes. Select "Markdown table" as the delimiter and paste a standard pipe-delimited Markdown table (header row, separator row, body rows). The separator line is automatically skipped and cell whitespace is trimmed.
usage
No — parsing and conversion run entirely in your browser. This makes the tool safe for sensitive spreadsheets like payroll exports, customer lists or financial records that should never touch a third-party server.
privacy
Use Cases
CSV to API Migration
You have a legacy CSV export from a partner and need to POST it into a modern REST API expecting JSON. Convert in seconds, copy to your fetch body, and verify the shape — no glue script needed.
development
Database Seeding
Generate ready-to-run SQL INSERT statements from a CSV of test data. Drop straight into your migration file or psql shell. The output handles strings, numbers, nulls and booleans correctly.
database
BigQuery / Snowflake Ingestion
Cloud warehouses ingest JSONL faster than CSV. Convert your spreadsheet to JSONL and upload directly to BigQuery, Snowflake or Redshift staging.
data
Markdown Documentation Tables
Convert a paste from your Markdown docs into JSON for programmatic processing — generate FAQ items, navigation entries, or pricing tier data from human-readable Markdown tables.
documentation
Form Submission Analysis
Export your Google Forms or Typeform responses as CSV, convert to JSON, and run analytics or feed into your CRM via API. The header row becomes your field names.
productivity
Static Site Data Generation
Feed table data into Next.js getStaticProps, Astro content collections or Hugo data files. JSONL is especially useful for content collections that map one row to one page.
development