About JSON ↔ CSV
JSON-CSV converter converts between JSON arrays and CSV tables online, supports custom delimiters, field mapping, nested object handling. Essential for data import/export, API integration, Excel processing.
How to Use
- Paste JSON or CSV data
- Choose conversion direction
- Optional: custom delimiter and fields
- Copy or download result
Frequently Asked Questions
- How to handle nested objects in JSON→CSV?
- Nested objects flattened to dot-separated keys (e.g., user.name) or converted to JSON string. For complex nesting, suggest flattening in JSON first or selecting only needed fields.
- Must CSV first row be header?
- Yes. CSV→JSON needs first row as field names. If CSV has no header, manually add one or specify default field names in conversion options.
- Excel CSV import garbled text?
- Excel defaults to system encoding (Chinese Windows uses GBK) to open CSV. Tool outputs UTF-8 CSV — need to select UTF-8 encoding when importing to Excel, or convert to GBK-encoded CSV.