CSV to JSON and JSON to CSV, both ways
Paste CSV and get a JSON array, or paste a JSON array and get CSV you can open in Excel or Google Sheets. Parsing uses Papa Parse, so quoted commas, quotes inside fields and line breaks in cells come through correctly. It is useful for moving a spreadsheet export into code, or turning an API response into a sheet. Your data stays in this tab.
What you get
| Direction | Input | Output |
|---|---|---|
| CSV → JSON | Rows of comma-separated values | An array of rows, each an array of cells. The header row is kept as the first row |
| JSON → CSV | Array of objects | Header row from the keys, then one row per object |
| JSON → CSV | Array of arrays | One CSV row per inner array |
Tips
- Starting from Excel? Use Excel to CSV first.
- Check the JSON structure with the JSON formatter before you convert back to CSV.
- Remove repeated rows with Remove duplicate lines before you convert.
Limits
Very large pastes use memory in the browser tab. CSV → JSON does not turn the header row into object keys yet.
Related tasks
Compare two versions of a CSV with Text diff.
