JSON to CSV

Flatten a JSON array of objects into CSV, complete with dot-path columns for nested keys. Pick your separator, toggle quote-all, and download the result.

Bridges JSON APIs and MongoDB exports to Excel and BigQuery ingestion.

1. Paste or upload your JSON

Drop a .json file or paste a JSON array / object-of-arrays directly into the input pane.

2. Pick separator + quote rules

Choose comma, semicolon, tab, or pipe. Turn Quote-All on for safe export when fields contain separators.

3. Copy or download the CSV

Output updates live. Copy to clipboard for a quick paste, or download a .csv file for ingestion.

What JSON shapes does the converter accept?

Array-of-objects is cleanest. Object-of-arrays also works. Nested keys flatten to dot-paths (user.email); primitive arrays become pipe-separated cells.

How are missing keys handled across objects?

Plotiq takes the union of all keys. Objects missing a given key get an empty cell for that column — no row is ever dropped.

Can I convert JSONL / NDJSON?

Wrap the file in square brackets and comma-separate the lines to make a valid JSON array first, then paste. Native JSONL is on the roadmap.

Does the converter preserve JSON data types?

Numbers stay numbers, booleans stay true/false, null becomes an empty cell. Strings are quoted only when they contain the separator, a quote, or a newline.