CSV to JSON Converter
Convert tabular CSV data into an array of JSON objects. Runs locally in your browser.
JSON output will appear here.What is CSV to JSON conversion?
CSV to JSON conversion turns a flat table into an array of structured objects.
How to convert CSV to JSON
- Paste CSV in the input panel.
- Click Convert to JSON.
- Copy or download as
csv-to-json.json.
How CSV rows become JSON objects
The first row is treated as the header row, and each header becomes a key. Every row after that becomes one JSON object, with each cell assigned to the key from the same column position - so a header row of name,age,city and a data row of Ana,29,Lahore becomes {"name":"Ana","age":"29","city":"Lahore"}. The whole file becomes a single JSON array holding one object per data row, in the same order they appeared in the CSV.
Headers and column mapping
Column position is what actually links a value to a key - the header row just supplies the label. That means the number and order of columns has to stay consistent down the file; a header row with 5 columns but a data row with only 4 values leaves one key without a matching value for that row. It's worth glancing at the header row before converting to confirm the names are the ones you actually want as JSON keys, since whatever text sits in that first row is used exactly as written.
Common problems to watch for
- Inconsistent column counts - a row with fewer or more values than the header, often from a stray delimiter or a missing trailing comma somewhere upstream.
- Wrong delimiter - some exports use a semicolon or tab instead of a comma; pasting the wrong kind produces one column per row instead of several.
- Quoted values with embedded commas or newlines - a properly quoted field like
"123 Main St, Apt 4"should stay as one value; if it isn't quoted in the source, it will split into extra columns. - Empty cells - a genuinely blank cell becomes an empty string in the resulting JSON, which is different from the key being missing entirely.
Practical examples
- Turning a spreadsheet export of customer records into JSON so a script can loop through it and call an API for each row.
- Converting a CSV report from an analytics tool into JSON to feed into a JavaScript charting library that expects an array of objects.
- Preparing seed data for a test database from a CSV a teammate shared, without hand-writing the JSON objects.
What to check before converting
- Confirm the header row has the exact key names you want - they carry straight through as JSON keys, including any typos or inconsistent capitalization.
- Skim a few rows for values that contain commas or line breaks and make sure they're properly quoted in the source file.
- Decide whether downstream code needs real numbers or booleans - if so, plan to convert those specific fields after conversion, since every value arrives as a string.
Frequently asked questions
- What happens if a row has fewer or more values than the header row?
- A short row is filled in with empty strings for the missing trailing columns. A long row keeps its extra values under generated names like extra_1, extra_2, so no data is silently dropped - but it's worth checking rows flagged this way, since it usually means a delimiter inside an unquoted field or a genuinely malformed export.
- Do numbers and true/false values stay as text?
- Yes. Every CSV field becomes a JSON string, including things that look numeric or boolean, since CSV itself has no type system to tell '042' apart from 042 or 'true' from an actual boolean. Convert specific fields afterward if your downstream code needs real numbers or booleans.
- How does a comma inside a value get handled without breaking the columns?
- As long as the field is quoted in the CSV - "Smith, John" - the comma inside the quotes is treated as part of the value, not a column separator. An unquoted comma inside a field is what actually causes misaligned columns, so quoting is what protects the structure.
- What happens with duplicate or blank column headers?
- Duplicate headers are renamed so both columns survive instead of one silently overwriting the other in the resulting objects. Blank headers are given a generated name so that column's data isn't lost, even though it has no meaningful key from the source file.
- Why would I convert CSV to JSON instead of just opening it in a spreadsheet?
- JSON is what most APIs, scripts, and JavaScript code expect to consume - converting once means every row becomes an object you can loop over, filter, or feed directly into code, rather than re-parsing a spreadsheet export every time you need the data programmatically.
Related tools
Convert an array of JSON objects into CSV.
Format JSON with indentation.
Check JSON syntax.
Explore JSON as a tree.
Compact JSON.
Compare JSON documents.
Convert JSON to YAML.
Convert YAML to JSON.
Escape text into a JSON string literal.