JSON to CSV Converter
Spreadsheets speak CSV, not JSON. This converter turns a JSON array of objects into clean CSV that opens directly in Excel, Google Sheets or any data tool, flattening nested objects into dotted column headers along the way.
Pick the delimiter your target program expects and decide whether to include a header row — the conversion runs instantly and privately in your browser.
How to use the json to csv
- 1Paste a JSON arrayProvide an array of objects, for example a list of records exported from an API or database.
- 2Choose a delimiterSelect comma, semicolon or tab depending on your spreadsheet’s locale and preferences.
- 3Toggle headers and flatteningInclude a header row from the object keys, and flatten nested objects into dotted columns.
- 4Copy the CSVCopy the result and paste it into your spreadsheet or save it as a .csv file.
Features
- Comma, semicolon or tab delimiters
- Optional header row from object keys
- Flattens nested objects into dotted columns
- Handles arrays of objects of any size
When to use it
- Importing API data into Excel or Google Sheets
- Preparing JSON records for a data analyst
- Converting export files for a legacy system
- Turning a list of objects into a quick table
Frequently asked questions
How do I convert JSON to CSV?
Paste a JSON array of objects, choose your delimiter and whether to include headers, and MyJson produces CSV you can copy straight into a spreadsheet.
What if my JSON has nested objects?
Enable flattening and nested objects become dotted column headers such as address.city, so all the data fits into a flat CSV table.
Which delimiter should I use?
Comma is standard, but some European locales of Excel expect a semicolon. Tab-separated values are useful when your data already contains commas.
Related tools
Looking to learn more? Browse our JSON guides and tutorials.