JSON to CSV Converter

Quick answer: Convert a JSON array of objects into a CSV table for spreadsheets and reporting. Open JSON 转 CSV — everything runs locally in your browser, and files never leave your device.

1. Paste a JSON array into the JSON to CSV tool.
2. Confirm the column set — keys of the first object, union of all others.
3. Toggle how nested objects flatten (dotted column names) and arrays (JSON strings).
4. Download the .csv.

Important notes

• Input must be an array of objects; a single object wraps into one row.
• Missing keys become empty cells, so ragged objects convert safely.
• Long numbers (order IDs, phones) may show as scientific notation when opened in Excel — format the column as Text.

Common questions

Column order? Follows the first object's keys; reorder in Excel or reorder the object keys.

Nested arrays? They serialize as JSON strings inside the cell.

Workflow tips

A practical review pass before using the CSV: scan the header row for surprise columns (keys that only exist on some objects), check a few rows for empty cells where you expected values, and confirm numeric columns did not lose their leading zeros. Ten seconds here prevents the classic "the report is wrong" meeting.