JSON to CSV Converter
Convert JSON arrays, objects, and API responses into spreadsheet-ready CSV. Flatten nested fields, choose how arrays are handled, preview the columns, and download the result — all in your browser.
Last updated September 6, 2026
2
Rows
5
Columns
2
Nested fields flattened
Preview — 2 rows
| id | customer.name | customer.city | tags | active |
|---|---|---|---|---|
| 1 | Alice | London | ["red","blue"] | true |
| 2 | Smith, "John" | Karachi | false |
How to Convert JSON to CSV
Convert JSON into a spreadsheet-ready CSV in a few steps:
- Paste your JSON or upload a .json file.
- Choose how nested objects and arrays should be handled.
- Select the delimiter and whether to include a header row.
- Review the detected rows, columns, and table preview.
- Copy the CSV or download it as a .csv file for Excel, Google Sheets, Numbers, or another data tool.
The conversion runs directly in your browser, so your JSON does not need to be uploaded to Utillery.
How Nested JSON Becomes CSV
Nested JSON does not naturally fit into rows and columns, so the converter can flatten nested object paths into column names.
For example, a record with id, a nested customer object (name and city), and active becomes this CSV when flattening is enabled:
id,customer.name,customer.city,active 1,Alice,London,true
If you prefer, nested objects can instead be kept as JSON text inside a single CSV cell.
What Happens When JSON Objects Have Different Fields?
The converter builds the CSV header from the union of keys found across the records. If a field is missing from one object, that row receives an empty cell rather than shifting the remaining values into the wrong columns.
For example, if one record contains email and another does not, the email column still exists for every row, with the missing value left blank.
Numbers, booleans, and text are written as CSV values. Null values should be exported as empty cells by default.
When Is JSON to CSV Useful?
JSON is commonly used by APIs and applications, while CSV is easier to open in spreadsheets and many reporting or import tools. Converting JSON to CSV is useful when you need to:
- Open an API response in Excel or Google Sheets
- Review or share structured data with non-developers
- Prepare records for a CSV-based import
- Analyze JSON exports in spreadsheet or BI tools
- Turn logs or event data into a tabular format
For highly nested datasets, review the preview carefully because flattening can create many columns.
Frequently asked questions
How do I convert JSON to CSV?
Paste or upload the JSON, choose your flattening and delimiter options, review the preview, and download or copy the generated CSV.
Can this converter handle nested JSON?
Yes. Nested objects can be flattened into dot-notation columns such as customer.address.city, or kept as JSON inside one cell.
What happens if JSON objects have different keys?
The CSV uses the union of keys across all records. Missing values are left as empty cells so every row stays aligned.
How are arrays handled?
You can keep arrays as JSON text in a single cell or expand primitive arrays into indexed columns such as tags[0] and tags[1].
Can I open the result in Excel or Google Sheets?
Yes. Download the generated .csv file and open or import it into Excel, Google Sheets, Numbers, LibreOffice Calc, or another CSV-compatible tool.
Is my JSON uploaded or stored?
No. Conversion runs locally in your browser.
Can I turn this CSV into a Markdown table for a README?
Yes — after converting here, use the CSV to Markdown Table Converter to generate a GitHub-ready table.