PixoateTable 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.
Paste CSV, TSV, semicolon, pipe or | markdown | table | here…
or drop a .csv / .tsv file
Done with Table to JSON? Try these next
Hand-picked tools that pair well with Table to JSON. Keep going without losing your file.
JSON Prettify
Format, validate and minify JSON in your browser. Pretty 2 / 4 / 8 space indent or one-line minify with copy + download.
Try it nowImage to CSV
Extract tables from any image and download a ready-to-use CSV file.
Try it nowImage to Excel
Turn table photos and screenshots into styled .xlsx spreadsheets with OCR.
Try it nowPDF to CSV
Pull every table from a PDF into a zip of clean, ready-to-import CSV files.
Try it nowDiff Checker
Compare two text snippets line by line. Split or unified view, optional ignore whitespace and ignore case.
Try it nowMarkdown Editor
Write Markdown with live HTML preview. Headings, lists, tables, code fences, blockquotes. Export to HTML or Markdown.
Try it nowFrequently 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.
usageYes. 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.
technicalThe 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.
technicalSwitch 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.
featuresJSONL (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.
featuresYes. 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.
technicalYes. 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.
usageNo — 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.
privacyHow Table to JSON helps you get it done
Real problems it solves every day — for businesses, creators, and everyday tasks. Find the use case that fits you and start in seconds.
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.
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.
BigQuery / Snowflake Ingestion
Cloud warehouses ingest JSONL faster than CSV. Convert your spreadsheet to JSONL and upload directly to BigQuery, Snowflake or Redshift staging.
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.
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.
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.