How to use the JSON to CSV Converter
- 1. Paste your JSONUse an array of objects, such as an API response or database export.
- 2. Pick the optionsChoose a separator and how lists inside a row should be handled.
- 3. Download the CSVPreview the columns, then copy the text or download the file.
How nested JSON becomes columns
A CSV file is flat, while JSON can hold objects inside objects. This tool joins the keys with a dot to make one column for each nested value. Take this record:
{"id":1,"address":{"city":"Noida"},"skills":["SQL","Python"]}It becomes the columns id, address.city and skills, with the row 1, Noida, SQL; Python. If you prefer one column per list item, choose the second list option and you get skills.0 and skills.1 instead.
Records do not need identical keys. Every key found in any row becomes a column, and rows without that key get an empty cell. If your JSON wraps the list in one key, like {"data":[...]}, the tool finds that list on its own.
CSV escaping, handled for you
A comma inside a name can break a badly made CSV. This tool follows the standard CSV rules: any cell with the separator, a quote or a line break is wrapped in double quotes, and inner quotes are doubled. So Asha, K stays in one cell.
The download also carries a small UTF-8 marker, so Excel shows ₹ and Hindi text correctly. If your region's Excel expects semicolons, pick the semicolon separator.
Your data stays in your browser the whole time. Got an invalid file? Fix it first with the JSON formatter, which shows the exact error line. Working with databases too? The SQL formatter makes long queries readable.
Frequently asked questions
What JSON shape works best?
An array of objects, where each object is one row. A single object also works and becomes one row, and a plain list of values becomes one column.
Can it handle nested JSON?
Yes. Nested objects become dotted column names like address.city, and lists can stay in one cell or spread across columns.
Is my data uploaded?
No. The conversion happens in your browser, so private data never leaves your device.
Is this tool free?
Yes, it is free. We ask for your name and WhatsApp number once when you see your result, and other Uncodemy tools then open without the form.