JSON to CSV Converter
Convert JSON arrays of objects to CSV spreadsheet format, or transform CSV data back to JSON. Download the converted output as a file. Perfect for data transformation and spreadsheet import/export.
How to use
- Paste a JSON array of objects (for example, a REST API response) into the input.
- Make sure each object has a consistent set of keys so the CSV columns are predictable.
- Convert to CSV and check the header row and field ordering.
- If you’re exporting JSON to CSV for Excel, download the file and import it as UTF-8.
- To convert CSV back to JSON, paste the CSV text and run the reverse conversion for use in APIs or scripts.
FAQ
What JSON format works best for converting JSON to CSV for Excel?
A flat array of objects is ideal. Deeply nested objects usually need flattening (e.g., turning address.city into a single column) before conversion.
Can this handle commas, quotes, and newlines inside fields?
Yes—CSV uses quoting rules for fields that contain commas or line breaks. Always spot-check a few rows if your data includes long text.
Is my data uploaded during conversion?
No. Conversion runs entirely in your browser; your JSON/CSV data is not sent to a server.
Why do accented characters look wrong after opening the CSV?
It’s typically an encoding issue. Import the CSV as UTF-8 (especially in Excel) to preserve non-English characters.
Does converting CSV to JSON preserve number types?
CSV is plain text, so type inference can vary. If you need strict typing, validate the output and cast fields in your code.