How to convert JSON to CSV
- Add your .JSON file - drop it in the box above or click to browse.
- Convert it to .CSV in a few seconds.
- Download your new .CSV file.
What to expect
- Only flat arrays of same-structure objects convert cleanly - CSV has no way to represent hierarchical or nested data.
- Nested values are handled differently by each tool: some serialize them as a text string, others expand them into dot-notation columns such as
address.city. - JSON objects are unordered per spec, so column order in the output CSV may differ from the original key order.
Frequently asked questions
Can JSON always be converted to CSV?
Only when the JSON is a flat array of objects with consistent keys. Nested or mixed-structure JSON requires flattening, which may lose or alter data.
What happens to nested objects during conversion?
Tools handle them differently - some write the nested value as a text string, others expand it into extra columns like
address.city. Check the output carefully before using it.Why does Excel reject my JSON file?
Power Query requires a valid JSON array or object at the top level. It rejects JSON Lines format (one object per line) and non-standard syntax such as comments or trailing commas.
Can I convert the CSV back to JSON?
Yes, but the round-trip is not lossless - CSV stores everything as plain text, so type information such as numbers, booleans, and null values is lost.
