Data / Spreadsheet export
JSON to CSV Converter
Turn a JSON array of objects into a spreadsheet-ready file. Fields line up across records, and nested objects or arrays stay together as JSON in one cell.
Runs entirely on your deviceNo uploads, accounts, cookies, or personal tracking.
Source JSON
Up to 10,000 records · 200 columns · 1,000,000 cells
All top-level fields become columns. Missing values and null become empty cells. Quote large identifiers to keep their exact digits.
Paste a JSON array or choose a JSON file to begin.
CSV preview
Your CSV preview will appear here.
Did this save you time? Support these free tools. Always optional.
1. Add your data
Paste an array of objects or choose a JSON file up to 5 MiB.
2. Choose the result
Choose a separator and review the first 10 rows.
3. Save it locally
Copy all rows or download the complete UTF-8 file.
Practical guide
Turn a JSON export into aligned spreadsheet columns
Use this converter for an API export or a saved JSON array of objects. It collects top-level fields across every record, so a field that first appears in a later row still gets its own column.
Common uses
- Open an array of API records in Excel or another spreadsheet.
- Export comma, semicolon, or tab-separated data for an import workflow.
- Keep nested objects together without expanding arrays into duplicate rows.
What to expect
- Worked example
- Load the example to convert two records into name,hours,tags,team columns. Alex has 3 hours and a JSON tags cell; Sam has 5 hours and Operations in the team column. Missing fields are empty.
- Nested data
- Objects and arrays become compact JSON strings in a single CSV cell. This tool does not flatten paths or multiply rows. Null and missing values both become empty cells.
- Text and numbers
- Quoted strings keep leading zeros in the CSV file, but spreadsheets may still auto-detect them as numbers: import identifier columns as Text. JSON numbers use browser floating-point precision. Unsafe integers and non-finite numbers are rejected; quote exact decimals and large identifiers in the original JSON. Duplicate JSON keys use the last value.
- Export settings
- Downloads use UTF-8 with a BOM and CRLF record endings. Embedded delimiters, quotes, and line breaks are quoted. Formula protection prefixes formula-like strings and headers with an apostrophe; the preview shows the actual exported text.
- Limits
- Up to 5 MiB of UTF-8 input, 10,000 object records, 200 columns, and 1,000,000 output cells. The preview shows 10 rows; copy and download contain all rows. Empty arrays, unnamed fields, JSON Lines, and primitive rows need preparation first.