CSV to JSON

CSV in, JSON out, with the delimiter in your hands.

FREE - NO SIGN-UP - RUNS ON YOUR DEVICE

Runs in your browser tab

  • 3delimiters
  • JSONout
  • 0uploads
  • 1 tapto save
In practice

What you can count on

  • 3delimiters
    • Comma, semicolon or tab
    • Chosen by you, never guessed
  • 1header switch
    • First row as field names, or not
    • Changes the shape of the JSON
  • 0uploads
    • Your data stays in this tab
    • Nothing is sent anywhere
Specification

CSV to JSON at a glance

Opens on
CSV into JSON
Delimiter
Comma, semicolon or tab
Header row
Switchable header row
Types
Numbers and booleans typed
Errors
Sentence with the line number
Two buttons worth knowing
Reverse, and same-format tidy
Formats
JSON, YAML, CSV, TOML, JSONL
Price
Free
Account needed
None
Where processing happens
On your device
How to

How to use CSV to JSON

  1. 1

    Set the delimiter

    Choose comma, semicolon or tab, and say whether the first row holds the field names.

  2. 2

    Paste your CSV

    A sample is already loaded, so replace it with your own rows.

  3. 3

    Copy or download

    Copy the JSON in one tap, or download it as a .json file.

Questions

Frequently asked questions

My file uses semicolons. Will it work?

Yes. Set the delimiter to semicolon. Spreadsheet exports from much of Europe use semicolons because the comma is the decimal separator there.

What if there is no header row?

Turn the header switch off. Each row then becomes a plain list of values instead of an object, and nothing is lost from the first line.

Are quoted fields handled?

Yes. A field wrapped in quotes may contain the delimiter, line breaks and doubled quotes, and all of that is read correctly.

Everything came out as one column. What now?

The delimiter is wrong, and the message names the ones your text actually contains so you can pick the right one. Blank lines are dropped on the way in and never become empty rows.

Background

Where CSV conversions go wrong

The panel opens already set to CSV in and JSON out. Choose the delimiter your file really uses and say whether the first row holds the field names, and the JSON appears as you type.

  • The delimiter is the usual culprit: semicolon files read as one long column.
  • A header switch left on eats your first row of data when there is no header.
  • Fields wrapped in quotes may hold commas and line breaks, and are read that way.

Full specification

Specification of the CSV to JSON tool
Opens onCSV in, JSON out. Both selectors change without leaving the page.
DelimiterComma, semicolon or tab, chosen by you so a European export is read correctly.
Header rowOn, the first row becomes the field names. Off, every row is read as a plain list.
TypesNumbers become numbers and true or false become booleans, rather than staying text.
ErrorsA sentence naming the line that does not line up, and which delimiter is in use.
Two buttons worth knowingReverse swaps the formats and feeds the result back in, so you can check a conversion. Setting both selectors the same tidies instead of converting.
FormatsFive first-class formats — JSON, YAML, CSV, TOML and JSONL — and any direction between them. JSONL is in both selectors, not a side option.
PriceFree. Supported by clearly labeled ads outside the working area.
Account neededNo.
Where processing happensIn your browser tab. Nothing is uploaded.
Next step

Keep going with the same files

All developer tools: Developer tools on SPOTTOOLS