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

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.

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.

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.

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.

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.

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.

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.

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.

When checked, the tool treats your table's first row as column names and uses them as the JSON object keys (or generates col_1, col_2... for SQL if you leave it blank). Uncheck it if your data has no header row — a plain list of rows — and the tool will instead output raw JSON arrays or auto-name columns col_1, col_2, etc. for SQL INSERT statements.

Switch Output to SQL INSERT and a Table name field appears where you can type your target table's name, such as customers or order_items. The tool automatically sanitizes whatever you enter — replacing spaces and symbols with underscores and prefixing a leading digit — so the generated SQL always has a valid identifier even if your input is messy.

Uncheck 'First row is header' if your export has no column names, set Output to SQL INSERT, and type your real table name in the Table name field. The tool will auto-generate col_1, col_2... column names, coerce numbers and booleans automatically, and produce one properly-escaped INSERT statement per row that you can paste straight into your database client.

JSON (arrays) drops the field names and outputs each row as a plain list of values in column order — for example ["Alice", 34, "Berlin"] instead of {"name":"Alice","age":34,"city":"Berlin"}. It still respects the 'First row is header' checkbox, using that row only to know how many columns to expect rather than as keys. Choose it when the receiving code (a charting library, a positional database driver, or a spreadsheet import) reads values by position rather than by field name; otherwise stick with JSON (objects).

Try sample fills the input panel with a short three-row name/age/city table (tab-separated) so you can immediately see how the delimiter detection, header row and each output format behave before you paste real data. Once there's content in the box, a Clear button appears — next to the Input label in the editor view, and again as a full-width button in the Settings panel — that wipes the textarea back to empty in one click instead of selecting and deleting the text manually.