How to Convert a JSON File to CSV — Free Online (No Software)

Converting a JSON file to CSV lets you open the data in Excel, Google Sheets, or any database tool. It is also the easiest way to convert JSON to Excel. Here is the fastest free method.

Step-by-Step: Convert JSON to CSV Online Free

1. Open your JSON file in Notepad (Windows) or TextEdit (Mac), or use VS Code.
2. Press Ctrl+A to select all, then Ctrl+C to copy.
3. Go to TextWonder's JSON to CSV Converter.
4. Paste your JSON into the input box.
5. Click Convert. The tool auto-detects the keys and builds the CSV header row.
6. Click Download CSV to save the file.
7. Open the CSV in Excel or Google Sheets — your data is now in clean columns.

What JSON Format Works for CSV Conversion?

The JSON must be a flat array of objects at the top level:

[
  { "name": "Alice", "age": 30, "city": "London" },
  { "name": "Bob",   "age": 25, "city": "Paris"  }
]

This converts to:

name,age,city
Alice,30,London
Bob,25,Paris

What If My JSON Is Nested?

Nested JSON (objects inside objects) does not map directly to flat CSV rows. For example:

{ "user": { "name": "Alice", "address": { "city": "London" } } }

You need to flatten it first. Options:

• Manually restructure the JSON so all fields are at the top level.
• Use jq (command line): jq '[.[] | {name: .user.name, city: .user.address.city}]'
• Use the JSON Formatter to inspect the structure and identify which fields to extract.

Opening the CSV in Excel

After downloading the .csv file:

• Windows: Double-click the .csv file — Excel opens it automatically.
• Mac: Double-click → Numbers opens it by default. To use Excel, right-click → Open with → Excel.
• If data appears in one column: Go to Data → Text to Columns and set the delimiter to Comma.