Skip to content
Changelog
new tooltext-data

JSON ↔ CSV Converter

v1.0

JSON ↔ CSV Converter converts in both directions with one swap button. Paste, upload or load sample data on either side.

JSON to CSV takes an array of objects, or a single object, and keeps columns in the order keys first appear. Nested objects become dot-notation columns, or are written as JSON text in the cell when you turn that option off. Arrays are always written as JSON text in the cell.

CSV to JSON detects the delimiter (comma, semicolon, tab or pipe) and says which it found. It handles quoted fields and escaped quotes, and can turn cell text into numbers, booleans and null. Values where a leading zero matters, like a 00501 zip code, stay as text.

The swap button carries the current output across as the new input, so JSON to CSV and back stays in one flow. If nothing has been converted yet, it just flips the mode and keeps what you typed. CSV panes color each column so wide rows are easy to read. You can toggle the header row, and options are remembered per direction on this device. The output shows a row count, and you can copy it or download output.csv or output.json. Press Cmd/Ctrl+Enter to convert, and Share puts the input and options in a link. Errors list the row or position, with a Jump to the spot in the editor where available. Conversions stop at 100,000 rows with a warning.

All changes