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
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
Price
Free
Account needed
None
Where processing happens
On your device
How to

How to use CSV to JSON

  1. 1

    Set the delimiter

    Set the delimiter.

  2. 2

    Paste your CSV

    Paste your CSV.

  3. 3

    Copy or download

    Copy or download.

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.

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.
PriceFree. Supported by clearly labelled 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