Data converter

CSV to JSON converter

To convert CSV to JSON, drop your CSV file in the box below. It converts straight away; press Download to save the JSON. It all happens in your browser, so your file stays on your device.

Converted on this device, never uploaded

What changes

CSV to JSONWhat happens
ShapeAn array of objects, keys from the first row (or arrays of values without a header)
DelimiterComma, semicolon, tab or pipe, found automatically
QuotesQuoted cells with commas, quotes and line breaks are read correctly
Numbers12 and 4.50 become numbers; 007, +46 and 15+ digit IDs stay text
EncodingUTF-8 (with or without BOM), UTF-16, or Windows-1252 from older Excel

How to convert CSV to JSON

  1. Add your CSV. Drop the file in the box, or click to choose it. It becomes JSON straight away.
  2. Check the result. Look at the preview. The delimiter and value types are set for you; change them if needed.
  3. Download. Press Download to save the JSON.
Why JSON

Turn a spreadsheet export into JSON for an API, a script or a web app: one object per row, keyed by the header.

Questions

Yes. The delimiter is detected (comma, semicolon, tab or pipe), and you can set it by hand under “Columns are split by”.

Values with a leading zero (007), a plus sign, or more than 15 digits stay text so nothing changes: ZIP codes, phone numbers and long IDs keep every digit.

The second becomes name_2, and an empty header becomes column_3, so no value is lost.

You get an error naming the row, instead of a JSON file with half the data in one cell.

No. The conversion happens right in your browser, so your file stays on your device. There is no account to make, either.

Related conversions