JSON ↔ CSV Converter
Convert both ways with a table preview
Input
Options
Delimiter
Most spreadsheets expect a comma; European locales often expect a semicolon.
Result
Nothing entered yet
Paste JSON or CSV and the converted result appears here.
If characters look wrong in Excel, import with Data → From Text/CSV and choose UTF-8.
Developers work in JSON and everyone else works in spreadsheets. Converting between the two is the usual bridge — an API response that needs to reach a colleague, or a spreadsheet that needs to reach an API.
How to use
- 1 Choose the direction.
- 2 Paste your JSON array or CSV text.
- 3 Pick the delimiter your spreadsheet expects.
- 4 Check the preview, then copy or download.
Frequently asked questions
Which delimiter should I choose?
Comma for most cases. Semicolon if the file is destined for a spreadsheet in a locale that uses commas as decimal separators — much of Europe — where comma-separated files open as a single column.
What happens to nested JSON?
CSV is flat and cannot represent nesting. Nested objects and arrays are serialised into their column as JSON text, which is lossless but not something a spreadsheet can work with directly.
Why do accented characters look wrong in Excel?
Excel guesses the encoding and often guesses wrong on double-click. Use Data → Get Data → From Text/CSV and choose UTF-8 explicitly, and the characters come through correctly.