Home / Developer tools / JSON to CSV Converter
JSON to CSV Converter
An API gives you JSON but the person who asked wants a spreadsheet. Paste the array, pick a separator, and download a CSV whose columns come from every key found across the records.
How to use it
- Paste a JSON array of objects.
- Choose the separator your spreadsheet expects.
- Convert, then copy the text or download the .csv file.
Examples
- Two records with three keys each produce a header row and two data rows.
- Values containing a comma or a quote are quoted and escaped automatically.
- Records with different keys are merged: every key becomes a column, missing values stay blank.
Questions people ask
What happens to nested objects?
They are written as compact JSON inside a single cell, so nothing is lost. If you need nested fields as their own columns, flatten the structure before converting.
Which separator should I choose for Excel?
Semicolon in most of Europe and Latin America, comma in English-language locales. If a downloaded file opens with everything crammed into column A, you picked the other one — convert again and try the alternative.
Related tools
Updated: 2026-08-07