AV-D05
JSON ⇄ CSV / Excel
Flatten JSON arrays into CSV or .xlsx, or turn CSV and Excel sheets back into nested JSON.
● Runs on your device; nothing is uploadedHow to use it
- Choose JSON → CSV / Excel or CSV / Excel → JSON.
- For JSON → CSV, paste an array of objects and set Delimiter, Arrays and Path separator.
- Click Download CSV or Download Excel (.xlsx).
- For CSV → JSON, drop a CSV or .xlsx file (or paste CSV) and pick a Worksheet if asked.
- Set Delimiter and the typing, nesting and empty-cell options, then click Download JSON.
Limits
- CSV file size
- 20 MB
- .xlsx file size
- 10 MB
- Rows read from a worksheet
- 200,000
- Excel export
- 1,048,575 data rows × 16,384 columns
- Output preview
- 200,000 characters (copy or download for all)
Features
- Nested fields flattened into dot-path columns and rebuilt on the way back
- Arrays as one column per item or a single JSON column
- Optional guard against spreadsheet formula injection
- Delimiter detection and number/boolean typing for CSV input
- UTF-8 BOM on CSV downloads so Excel reads the encoding correctly
- Excel export with a bold, frozen header row
For AI agents: avtools_json_csv
Loading the tool…