JSON to CSV
Turn a JSON list into a CSV table you can open in Excel, and turn a CSV table back into JSON — with a choice of separator to suit your computer.
How to convert JSON to CSV
- Pick a direction: "JSON → CSV" or "CSV → JSON".
- Paste your content on the left and the result appears on the right.
- If Excel splits the columns wrongly, change the separator (comma, semicolon or Tab).
Frequently asked questions
The JSON needs to be a list of objects, where each object becomes one row of the table. If the objects have different fields, the table gets every column and leaves cells empty where there is no data.
They're kept as JSON inside the cell rather than being split into several columns.
It depends on your computer's settings. If Excel puts everything into one column, try the semicolon — many computers set to Vietnamese need it.
When converting CSV to JSON, only cells that are plain numbers become numbers. Cells starting with 0, like phone numbers and postal codes, or very long digit strings like account numbers, stay as text so they don't lose the leading 0 or get rounded. You can also turn number detection off completely.
Usually the wrong separator is selected, or a cell contains a comma but isn't wrapped in double quotes. Check the separator and the row it points to.
No. The content is processed right on your device.
It's completely free, no account needed.
Related tools
JSON to XMLConvert JSON to indented XMLJSON to TypeScriptGenerate TypeScript interfaces from sample JSONJSON to JSON SchemaGenerate a JSON Schema from a JSON sampleJSON Schema validatorCheck whether JSON data matches a JSON SchemaJSON to ZodGenerate a Zod schema from a JSON sampleJSON to Go structGenerate Go structs from a JSON sampleJSON to Python dataclassGenerate dataclasses or Pydantic models from JSONJSON to Java classGenerate Java classes or records from JSONJSON to Kotlin data classGenerate Kotlin data classes from a JSON sample