CSV to JSON Converter
Convert CSV with a header row into a JSON array of objects. Handles quoted cells and other delimiters.
JSON
In short
What is the CSV to JSON Converter?
The CSV to JSON converter reads text whose first row is a header and returns a JSON array with one object per row. It understands quoted cells, embedded commas and doubled quotes. It is useful for loading spreadsheet exports into code, mock APIs and test data.
How to use it
- Paste CSV with column names in the first row.
- Choose the delimiter used in your file.
- Tick the option to turn numeric text into numbers if you need it.
- Copy or download the JSON.
Questions
CSV to JSON Converter — FAQ
Must the first row be a header?
Yes. The first row supplies the key names. If your data has no header, add one before converting.
Why are my numbers in quotes?
By default every cell stays text. Tick the numbers option to convert cells that look like numbers.
Does it handle commas inside cells?
Yes, as long as the cell is wrapped in double quotes, which is how spreadsheet exports normally write them.
More Developer & Web tools
JSON Formatter & ValidatorJSON MinifierJSON to CSV ConverterBase64 Encoder & DecoderURL Encoder & DecoderHTML Entity Encoder & DecoderUUID GeneratorPassword Generator
Go further