JSON to CSV Converter
Paste a JSON array of objects and get clean CSV instantly. Nested objects are flattened with dot notation, values are escaped correctly, and you can copy or download the result. No upload, no server, runs entirely in your browser.
How to Use
How JSON to CSV Conversion Works
A CSV file is a flat table: the first line holds column names and every line after that is one record, with values separated by commas. JSON is hierarchical and can nest objects inside objects. To bridge the two, the converter reads every object in your array, collects the union of all keys to form the header, and flattens nested objects into dot notation columns so each value lands in its own cell.
Values that contain a comma, a double quote, or a line break are wrapped in double quotes, and any double quotes inside a value are doubled. This is the standard CSV escaping that spreadsheets expect, so the file opens cleanly in Excel and Google Sheets.
Worked Example
Frequently Asked Questions
What JSON shape does this converter support?
The converter works best with a JSON array of objects, where each object represents one row. The tool reads the keys of every object to build the CSV header, then writes one row per object. A single object on its own is also accepted and is treated as a one row table.
How are nested objects handled?
Nested objects are flattened using dot notation. For example, a field like address with a nested city value becomes a column named address.city in the CSV. This keeps every value in its own column so the data stays flat and readable in a spreadsheet.
Can I convert a single JSON object?
Yes. If you paste a single JSON object instead of an array, the tool automatically wraps it in an array and produces a CSV with one header row and one data row. You do not need to add the surrounding square brackets yourself.
Is my JSON data uploaded to a server?
No. The entire conversion runs in your browser using JavaScript. Your JSON never leaves your device and nothing is sent to any server, so it is safe to use with private or sensitive data.
Can I open the CSV in Excel or Google Sheets?
Yes. The output is standard comma separated CSV with values quoted when they contain commas, quotes, or line breaks. You can copy the result or download it as data.csv and open it directly in Excel, Google Sheets, or any spreadsheet program.