How to convert CSV to JSON
Turn spreadsheet data into JSON for an API, or JSON back into CSV for a spreadsheet. Here's how, without a script.
Steps
- Open the CSV to JSON tool and paste your CSV (with a header row).
- It parses into a JSON array of objects, keyed by the headers.
- Switch direction to convert JSON back to CSV.
- Copy the result.
Quoted fields and commas
The parser follows RFC 4180, so quoted fields containing commas, quotes or newlines are handled correctly — no broken columns when your data has commas inside values.
Tools used in this guide
Related guides
How to convert CSV to JSON — FAQ
Paste the CSV (with a header row) into the tool and it returns a JSON array of objects keyed by the headers.