How to Convert JSON to CSV
Need to open your API data in Excel or Google Sheets? Converting JSON arrays to CSV is the fastest way to get structured data into a spreadsheet. This guide shows you how to handle flat and nested JSON structures alike.
Try JSON to CSV Now
Free, no signup. Works in your browser.
Paste your JSON array
Open the JSON to CSV converter and paste a JSON array of objects into the input panel. Each object in the array becomes a row, and each key becomes a column header.
Handle nested objects
If your JSON contains nested objects, the tool flattens them using dot notation. For example, `address.city` becomes a separate column. Arrays are joined with semicolons by default.
Configure delimiter and options
Choose your preferred delimiter — comma, semicolon, tab, or pipe. You can also toggle header row inclusion, quote wrapping, and null value handling.
Preview the table
The preview shows your data in a formatted table so you can verify columns and values before exporting. Check for any unexpected merges or missing fields at this stage.
Download or copy the CSV
Click download to save a .csv file or copy the output to your clipboard. The file can be opened directly in Excel, Google Sheets, Numbers, or any spreadsheet application.
Pro Tips
- *Make sure your JSON is an array of objects — single objects or primitive arrays won't produce useful CSV.
- *Use semicolons as delimiters if your data contains commas in string values to avoid conflicts.
- *For very large datasets (100K+ rows), consider using command-line tools like jq for better performance.
- *If some objects have different keys, all unique keys are included as columns with empty cells for missing values.
Related Guides
How to Format JSON Online
Learn how to format, beautify, and validate JSON data in seconds. Paste raw JSON and get perfectly indented, human-readable output with error highlighting.
How to Format SQL Queries Online
Format and beautify SQL queries with proper indentation, keyword capitalization, and consistent style. Supports MySQL, PostgreSQL, SQLite, and more.
How to Convert HTML to Markdown
Convert HTML pages, blog posts, and documentation to clean Markdown format. Handles headings, links, images, tables, and code blocks.