JSON to CSV
Turn JSON arrays into CSV for spreadsheets.
LocalYour data is processed locally in your browser and is not uploaded to Alphzen.
Paste a JSON array of objects.
How to use
- Paste a JSON array of objects (or a single object).
- Choose comma, semicolon, or tab as the delimiter.
- Keep Flatten nested objects enabled if you want address.city-style columns.
- Convert, then copy or download the CSV.
Features
- Built for arrays of objects — the usual API list payload.
- Optional flattening of nested objects using dot notation.
- RFC-style quoting for commas, quotes, and newlines inside fields.
- Delimiter options for Excel locales that expect semicolons.
- Warnings when a value cannot be represented as a simple cell.
Examples
[
{ "id": 1, "name": "Ada", "role": "Engineer" },
{ "id": 2, "name": "Grace", "role": "Admiral" },
{ "id": 3, "name": "Alan", "role": "Cryptanalyst" }
]id,name,role 1,Ada,Engineer 2,Grace,Admiral 3,Alan,Cryptanalyst
FAQ
What JSON shapes convert cleanly?
An array of objects with scalar fields converts directly. Nested objects can be flattened. Arrays of arrays, arbitrary trees, or mixed-type lists need flattening or JSON.stringify for those cells.
Why does Excel put everything in one column?
Some locales expect semicolons instead of commas. Switch the delimiter to semicolon, or use tab and open the file as Unicode text.
Are leading zeros preserved?
CSV is text. Spreadsheet apps may coerce numeric-looking cells. If you need a postal code to stay text, prefix the value in the sheet or use a specialized importer.
Related guides
Related tools
About this tool
JSON to CSV is for tabular data hiding in JSON: user lists, export endpoints, and analytics dumps. It is not a general JSON database. Deeply nested or heterogeneous documents will need flattening choices.
Alphzen collects column names from every row so missing keys become empty cells instead of shifting columns. Nested objects can become dot-separated headers such as profile.email.
Conversion runs locally. If you need to inspect the JSON first, format or validate it, then return here.