CSV to JSON Converter
Paste CSV (from Excel or Google Sheets) to get clean JSON — or turn a JSON array into CSV. Handles quoted fields, commas inside values and custom headers, all locally in your browser.
About this tool
The CSV to JSON Converter turns tabular data into a clean JSON array and can convert a JSON array back into CSV. Paste rows exported from Excel or Google Sheets and get structured objects keyed by the header row, ready for an API or a config file.
It correctly handles the tricky parts of CSV — quoted fields, commas inside values and custom headers — so you do not have to write a one-off parser. Both directions run in your browser, which keeps potentially sensitive spreadsheet data on your machine.
How to use
- Paste your CSV data, including the header row, into the input.
- The tool parses it and shows the equivalent JSON array of objects.
- Each row becomes an object whose keys come from the header line.
- To go the other way, paste a JSON array and switch to JSON-to-CSV.
- Review the output for correct field mapping, then copy it.
Features
- Two-way conversion: CSV to JSON and JSON back to CSV.
- Uses the header row as object keys automatically.
- Correctly parses quoted fields and commas inside values.
- Produces readable, properly formatted JSON output.
- Works with data pasted straight from Excel or Google Sheets.
- Runs entirely client-side, so spreadsheet data stays private.
Frequently asked questions
Is my spreadsheet data uploaded?
No. Parsing and conversion happen in your browser, so the CSV or JSON you paste — which may contain private data — is never sent to a server.
How are commas inside a value handled?
Fields wrapped in double quotes are treated as a single value, so commas inside quoted text do not split the field incorrectly.
Where do the JSON keys come from?
The first line of the CSV is treated as the header row, and each column name becomes the key for that field in every resulting object.
Can I convert JSON back to CSV?
Yes. Paste a JSON array of objects and the tool flattens it into CSV, using the object keys as the header row.
Does it work with data copied from Excel or Google Sheets?
Yes. Data exported or copied as comma-separated values from common spreadsheet apps parses correctly, including quoted text fields.