JSON to CSV converter
APIs return JSON arrays of objects; analysts want CSV for Excel pivot tables. Map JSON keys to columns and download comma-separated values — nested fields may flatten with dot notation depending on tool behavior. Conversion is local.
Input
Output
name,age
Ada,36
Alan,41
How to convert JSON to CSV
1. Paste JSON array of objects (or single object wrapped as array).
2. Preview column headers from keys.
3. Adjust delimiter or flatten options if available.
4. Download .csv file.
Conversion examples
User export
[{"id":1,"name":"Ada","role":"admin"}] becomes id,name,role header with one data row.
Analytics API sample
Pull /events JSON from docs example, convert to CSV for PM spreadsheet review.
Nested address flatten
{"user":{"city":"Berlin"}} may become user.city column for mail merge.
When JSON to CSV helps
• When non-developers need spreadsheet access to API data.
• When importing into legacy systems accepting CSV only.
• When quick ad-hoc analysis beats writing scripts.
When to script instead
• When JSON is deeply nested graphs — relational export needs custom code.
• When CSV RFC 4180 escaping of commas in fields is complex at huge scale.
• When live streaming ETL is required — use proper pipeline tools.
Column ordering
First object keys often define column order — inconsistent keys across rows produce sparse columns. Normalize API responses first.
Excel date pitfalls
ISO date strings import as text until converted — set column format after open.
Privacy
PII in JSON exports should be converted locally — avoid cloud converters for GDPR-regulated dumps.
Frequently asked questions
Array of arrays?
Tools expect array of objects for headers — convert shape first.
Nested objects?
May flatten with dot paths or stringify sub-objects — check output.
Null and booleans?
Exported as empty or true/false strings — Excel may coerce types.
UTF-8 BOM for Excel?
Some Excel locales need BOM — open via Import Data if accents break.
Uploaded?
No — local conversion.
Reverse CSV to JSON?
Use csvToJson tool.