Skip to content
AnyFileStudio

Convert CSV and JSON

Drop a CSV to get JSON, or a JSON to get a CSV: the file decides the direction, not you. The data stays on your device.

Your file stays on your device: nothing is uploaded

How it works

The separator is detected for you, comma or semicolon alike, and quoting follows the standard: a field can contain the separator and even line breaks. The CSV that comes out uses commas, ready for a double click in Excel set up for English, accents included; choose semicolon under Advanced options for Excel set up for Italian and much of Europe. Nested JSON becomes columns with a dotted path — address.city — and the other way round the first row becomes the key names.

Frequently asked questions

I have an Excel file. How do I get JSON out of it?
In two steps. First turn it into a CSV with “CSV ⇄ Excel”, one sheet at a time; then drop the resulting CSV here. Its separator is detected for you, comma or semicolon alike, and the first row becomes the key names.
The CSV uses commas. Can I get semicolons?
Yes. By default the CSV uses commas and a decimal point, which is what Excel set up for English opens in columns. If the file goes to Excel set up for Italian or much of Europe, which expects semicolons, open “Advanced options” and choose “Semicolon”: numbers then come out with a decimal comma.
Can I get nested JSON back from a CSV?
No: going from CSV to JSON, each column becomes a key exactly as written. A column called address.city stays a single key with a dot in its name, and tags.0 and tags.1 stay two keys, not a list. The JSON you get is one level deep.
What kind of JSON can become a CSV?
A list in square brackets. If it holds objects, the columns are every key that appears, and any object missing one leaves that cell empty; if it holds lists, each one is already a row; if it holds plain values, they come out as a single column. Wrap a lone object in [ and ] first.

Your files are never uploaded. Anywhere.

Your file stays in your browser’s memory: it is read, processed and written back here. There is no server to send it to.

  • Processed locallyEverything happens on your device.
  • Nothing to upload, nothing to wait forNothing to upload, no waiting.
  • No files to deleteWe keep nothing: nothing reaches us.
YOUR DEVICEyour fileprocessingthe resultservernever gets here

Other tools in this category

Compare textsLine by line, with the differences highlighted.Test regexWith capture groups and the line of every match.Read cronWhat it means, and the next times it fires.Convert YAML and JSONFrom YAML to JSON and back. What JSON cannot express, it tells you.