CSV to JSON
Paste the CSV. Separator, header row and a decimal comma are asked once, beside your text — then the rows are a JSON array, NDJSON or a Markdown table.
What you get
- Detects the separator — comma, semicolon, tab, pipe — and whether the first row is a header, and shows the guess as chips with a preview; the semicolon export opens with “semicolon” already chosen
- Finds a split decimal — “12,50” read as two cells — and asks: read as 12.50 · keep text
- Reads the Kibana export as 6 rows, with 3 message cells holding JSON that open in the panel as nested rows
- Converts the rows to a JSON array, NDJSON, YAML, XML or a Markdown table
- Reads quoted fields, embedded commas and doubled quotes the way RFC 4180 writes them
What it will not do
- Open .xlsx. Save as CSV first — the tool reads text.
- Coerce a value silently. A decimal written with a comma is a question with a preview, not a guess.
- Send your text anywhere. The page is static and the engine runs in this tab — open the network panel and watch it stay empty.
What it decides, and asks
- The separator
Comma, semicolon, tab or pipe — detected, shown as chips with a preview, asked once.
- The first row
Header or data. A header row names the keys; without one the columns are numbered.
- A decimal comma
1,5 in a comma-separated file is a question with a preview, never a silent guess.
- JSON in a cell
A cell that parses as JSON opens as nested rows; the cell in the table stays the text the file wrote.
- The output
id,name 1,Rin 2,Kai[ { "id": 1, "name": "Rin" }, { "id": 2, "name": "Kai" } ]- NDJSON
Convert → NDJSON writes one object per line instead of one array — the form a stream takes.
The sample
What the first sample opens — a real file, not an illustration written for this page.
in VS Code
Read as records asks separator and first row; Convert writes the JSON into a new editor.
Questions
My CSV uses semicolons. Does it work?
Yes. The separator is scored from the text itself — a European export with semicolons and decimal commas is the case the question exists for.
What does it do with JSON inside a cell?
A cell that parses as JSON shows Unpack. It opens in the panel as nested rows, and the cell in the table stays the string the file wrote.
Can it convert CSV to a JSON array of objects?
Yes — with the header row as the keys. NDJSON writes one object per line instead.
Does it read TSV?
Yes, with the same engine; a tab is one of the separators it scores.