JSON to CSV
Convert JSON data to CSV format. Supports nested objects and arrays, automatic header detection, and configurable delimiters and quoting — ready for Excel, Google Sheets, or any spreadsheet application.
Input JSON
Output CSV
Tool options
Delimiter
Character used to separate values in each row (e.g. comma, semicolon, tab)
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.
Always quote
Wrap every cell in double-quotes, regardless of its content.
Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
What is JSON to CSV conversion?
Most reporting workflows end in a spreadsheet, and most APIs hand you JSON. This converter bridges the gap: give it an array of JSON objects and it produces CSV you can open directly in Excel, Google Sheets or LibreOffice. Each object becomes a row, keys become column headers, and missing keys are filled with empty cells so columns stay aligned even when records are inconsistent.
Nested structures are flattened with dot notation — an object like {"address": {"city": "Oslo"}} produces an address.city column — so you do not lose depth just because CSV is flat. Options cover the delimiter (comma, semicolon, tab or a custom character, useful for European Excel versions that expect semicolons), whether the first row is treated as a header, and quoting behavior for values that contain the delimiter itself.
Limits worth knowing: CSV is a flat, text-based format, so deeply nested arrays have no natural representation — reshape the data you need before converting, or flatten it first. Very large arrays are bounded by browser memory rather than any server quota, though tens of thousands of rows are usually comfortable.
The conversion runs entirely in your browser and your data never touches a server, which makes the tool usable for customer exports, internal reports and other data you would rather not upload anywhere.
JSON to CSV Examples
Click to try!
Convert multiple JSON objects into CSV rows, one row per object.
Delimiter
Character used to separate values in each row (e.g. comma, semicolon, tab)
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.
Always quote
Wrap every cell in double-quotes, regardless of its content.
Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
Nested keys are flattened using dot notation (e.g. address.city).
Delimiter
Character used to separate values in each row (e.g. comma, semicolon, tab)
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.
Always quote
Wrap every cell in double-quotes, regardless of its content.
Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
Missing keys are filled with empty values to keep columns aligned.
Delimiter
Character used to separate values in each row (e.g. comma, semicolon, tab)
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.
Always quote
Wrap every cell in double-quotes, regardless of its content.
Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
All JSON Tools
You May Also Like
We use cookies for analytics and advertising. You choose what's enabled. Essential cookies are always on. Privacy Policy