Flattens Nested Objects
Nested objects and arrays become dot-notation columns like address.city, so deep JSON still fits a flat CSV.
Turn a JSON array of objects into clean CSV in your browser. Flattens nested objects, lets you pick the delimiter, and previews the table as you go. Free, no signup, nothing uploaded.
Drop in a JSON array of objects, or upload a .json file. The CSV and a table preview appear right away.
Pick the delimiter, keep nested objects flattened with dot notation, and choose whether to include a header row.
Copy the CSV or download it as a .csv file, ready to open in a spreadsheet.
JSON is how most APIs and apps hand you data, but a spreadsheet wants rows and columns. Converting between the two by hand is tedious and easy to get wrong, especially once the JSON has nested objects or values with commas in them.
This converter does the mapping for you. It reads a JSON array of objects, works out the full set of columns across every record, and writes a clean CSV. Nested objects are flattened into dot-notation columns, and any value that contains a comma, a quote, or a line break is quoted so the row stays intact.
You stay in control of the output. Switch the delimiter to a semicolon or tab when your spreadsheet expects it, turn the header row on or off, and watch the table preview update as you change things. Because it all runs in the browser, you can convert private exports without sending them anywhere.
Nested objects and arrays become dot-notation columns like address.city, so deep JSON still fits a flat CSV.
See the result as a real table while you type, so you catch problems before you export.
Comma, semicolon, tab, or pipe, to match what your spreadsheet or import tool expects.
Values with commas, quotes, or line breaks are quoted and escaped correctly, so rows never split apart.
Type JSON in, paste it, or load a .json file straight from your computer.
Your data is converted on your device. Nothing is uploaded, logged, or stored.
More Developer tools you might find useful.
Common questions about converting JSON to CSV.