Convert JSON and CSV
Convert locally between JSON arrays and CSV/TSV, handling header unions, quotes, line breaks, and formula injection warnings.
Local browser processing
This page has passed the public directory check; full functionality is available after enabling JavaScript.
User Guide
How do I use JSON and CSV to convert?
JSON and CSV conversion processes input only in the current browser; nothing is uploaded, sent over the network, or written to persistent storage.
Input data
Edit the default three-row example demonstrating names, cities, line breaks, and formula risks.
Select direction
Convert JSON to CSV/TSV, or parse CSV/TSV as JSON.
Check and export
View missing values, formula hints, and quoted results, then copy or download them.
Limitations and Notes
- Object fields are exported using the union of all headers; complex nested values require confirming the serialization method first.
- Fields beginning with =, +, -, or @ may be interpreted as formulas by spreadsheet software; a safety prefix may change how they are displayed.
- The number of rows, length of each row, and total text size are limited; this cannot replace the target spreadsheet software’s final validation.
FAQ
Will formulas be executed automatically?
No; the tool treats it only as data and reports potential formula injection risks.
Can fields containing line breaks be converted?
Yes, CSV quotes preserve line breaks within fields.
Will exporting alter the original values?
Unchanged by default; the safe export option applies only to the exported copy.