How to Convert JSON to CSV for Excel
You have JSON data from an API or database and need it in Excel. CSV is the fastest bridge between JSON and spreadsheets. Here's how to convert it in seconds.
Quick Answer
Paste your JSON array into the JSON to CSV converter at dotsapps.com. It flattens the data, creates column headers, and outputs a CSV file you can open directly in Excel.
Why Convert JSON to CSV Format?
JSON is great for APIs and databases. But when you need to analyze data, share it with non-technical people, or import it into Excel, CSV is the standard format.
Excel can't open JSON files natively (older versions don't support it at all). But every version of Excel opens CSV files perfectly. Google Sheets, LibreOffice, and Numbers all read CSV too.
Common scenarios where you need this conversion:
- Exporting API response data for a report
- Analyzing database query results in a spreadsheet
- Sharing data with team members who don't use developer tools
- Importing data into business intelligence tools
How JSON Arrays Map to CSV Columns
A JSON array of objects converts naturally to CSV. Each object becomes a row. Each key becomes a column header. Here's a simple example:
JSON input:
[{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]
CSV output:
name,age
Alice,30
Bob,25
The converter reads all the keys from your objects and creates headers. If some objects have keys that others don't, those cells stay empty in the CSV. This handles inconsistent data gracefully.
Handle Nested JSON Objects in CSV
Real-world JSON often has nested objects and arrays. For example, a user object might have an "address" object with "city" and "state" fields inside it.
The JSON to CSV converter at dotsapps.com flattens nested structures. A field like address.city becomes a column header. Nested arrays get joined or expanded based on the data structure.
For deeply nested JSON, you might need to preprocess the data. But for most API responses (1-2 levels deep), the converter handles it automatically. This saves you from writing custom scripts.
Tips for Clean CSV Output
Get better results with these practical tips:
- Start with a JSON array. The converter expects an array of objects ([{...}, {...}]). A single object won't create a useful CSV.
- Check for commas in your data. The converter wraps fields containing commas in quotes automatically.
- Watch for null values. Null and undefined values become empty cells in the CSV.
- Remove unnecessary fields first. If your JSON has 50 fields but you only need 5, trim it before converting. You'll get a cleaner spreadsheet.
After converting, open the CSV in Excel and use "Text to Columns" if any fields didn't separate correctly. But with proper JSON input, this rarely happens.
How to Do It: Step-by-Step
- 1
Open the JSON to CSV converter at dotsapps.com.
- 2
Paste your JSON array into the input field.
- 3
The tool auto-detects the structure and creates CSV columns.
- 4
Review the CSV output or preview it as a table.
- 5
Download the CSV file or copy the output to your clipboard.
Frequently Asked Questions
Can I convert JSON to CSV without coding?
Yes. Online converters like the one at dotsapps.com do it instantly. Paste your JSON, get CSV output. No programming, no software to install.
How do I open a JSON file in Excel?
Convert the JSON to CSV first using an online converter. Then open the CSV file in Excel. Excel 2016+ has a built-in JSON import, but CSV works with all versions and is faster.
What happens to nested JSON when converting to CSV?
Nested objects get flattened. A field like user.address.city becomes a column called 'address.city'. Arrays may be joined into a single cell or expanded into separate columns.
Is there a file size limit for JSON to CSV conversion?
Online tools handle files up to a few megabytes easily. The dotsapps.com converter runs in your browser, so it depends on your device's memory. For very large files (100MB+), use a command-line tool like jq.
Can I convert CSV back to JSON?
Yes. Many tools offer two-way conversion. Each CSV row becomes a JSON object, with column headers as keys. The CSV Viewer tool at dotsapps.com can help with this.
Ready to Try It?
JSON to CSV Converter is free, private, and works right in your browser. No sign-up needed.
Open JSON to CSV Converter