JSON ↔ CSV Converter

Paste a JSON array of objects to get RFC 4180 CSV, or CSV to get JSON objects. The header row becomes the keys; comma, semicolon and tab delimiters auto-detect. Nested values are stored as JSON strings in a cell. Optional type coercion keeps leading-zero values as strings. Nothing is uploaded.

JSON
CSV
ReadyThe delimiter is auto-detected when reading CSV

Runs in this tab · nothing is uploaded · Verify in 10 seconds →

What the JSON ↔ CSV converter does

This converter turns a JSON array of objects into CSV rows you can open in Excel or Google Sheets, and turns CSV back into JSON for APIs and scripts. The header row becomes the object keys, and each following row becomes one object.

How the JSON ↔ CSV converter works

JSON → CSV collects the keys of every object as columns, quotes fields that contain the delimiter, quotes or line breaks, and joins rows with the delimiter you pick. CSV → JSON auto-detects comma, semicolon or tab, honors quoted fields per RFC 4180, and can detect numbers, booleans and null. Everything runs in this tab.

Limits

Nested objects or arrays inside a cell are stored as a JSON string in that cell.

~/faq

Frequently asked questions

What JSON shape can become CSV?

An array of objects, where each object is one row. A single object becomes a one-row CSV. Nested objects or arrays inside a cell are stored as a JSON string in that cell.

My CSV uses semicolons, does that work?

Yes. When reading CSV the delimiter is detected from the header row, so semicolon-separated files from Dutch or German Excel installs convert without changes. For JSON → CSV you pick the delimiter yourself.

What does Detect types do?

With it on, cells that look like numbers, true, false or null become those JSON types. With it off, every cell stays a string, safer for postal codes, phone numbers and IDs with leading zeros.

How are commas and quotes inside a value handled?

Per RFC 4180: the field is wrapped in double quotes and any quote inside it is doubled. Reading does the reverse, so values round-trip unchanged.

Can I just look at the CSV without converting it?

Yes. Open it in the CSV Viewer to sort and search the rows in a table, then convert to JSON from there if you need objects.