Convert CSV to JSON

How it works

1. Paste CSV text into the input box, or export a sheet from Excel or Google Sheets as CSV and paste its contents.
2. Leave the delimiter on Detect automatically; the tool counts commas, semicolons and tabs on the first lines and picks the most likely one. Override it if the guess is wrong.
3. Keep First row is a header ticked so column names become object keys. Untick it to get an array of arrays instead.
4. Press Convert to JSON, then copy the result or download it as a .json file.

Frequently asked questions

Is my data sent to a server?

No. Parsing runs as JavaScript in the page. The text never leaves your browser, and the tool works offline once loaded.

What does the output look like?

With a header row, each subsequent line becomes an object whose keys are the header names, and the whole file is a JSON array of those objects. Without a header, each line becomes an array of strings.

Why are numbers in quotes?

All values are kept as strings on purpose. CSV has no type information, and converting automatically would break postcodes with leading zeros, phone numbers and long IDs. Cast the fields you need in your own code.

Are quoted fields and line breaks handled?

Yes. Fields wrapped in double quotes can contain the delimiter, doubled quotes and line breaks, following RFC 4180. Empty fields become empty strings.

Is there a size limit?

The free plan allows 10 runs per day; there is no practical limit on the text length, but very large inputs of several hundred thousand lines may take a few seconds. Pro removes the daily limit.