What JSON structure works best for CSV?

An array of objects works best: [{"name":"Ada","score":98},{"name":"Bob","score":87}]. Each object becomes one row. Keys become column headers.

Can CSV handle nested JSON?

CSV is flat. Nested objects are usually flattened into dotted columns (user.name) or stringified. Deep nesting may need custom scripts; shallow API payloads convert cleanly.

Is it safe to paste production API JSON online?

Only with tools that process locally. Convert Freely's JSON to CSV runs in your browser. Avoid pasting secrets into unknown cloud converters.

Will Excel open the CSV correctly?

Yes for UTF-8 CSV. If accents break, open Excel via Data > From Text/CSV and pick UTF-8. Google Sheets usually imports UTF-8 CSV without issues.

Can I convert JSON Lines (NDJSON)?

Wrap lines into an array or paste one JSON array. One object per line formats need a quick wrap: [ line1, line2 ] with commas between objects.

How to Convert JSON to CSV for Excel (Free, No Upload)

Turn JSON arrays into CSV spreadsheets for Excel and Google Sheets. Flatten nested data in your browser. Free, private, no signup.

May 31, 2026 · 3 min read · Developer Tools

How to convert JSON to CSV for Excel - Convert Freely guide

APIs return JSON. Finance and ops teams live in Excel. JSON to CSV bridges that gap so you can sort, filter, and pivot without writing a script. Our JSON to CSV converter flattens array data in your browser - ideal for one-off exports when a full ETL pipeline is overkill.

JSON shape that converts cleanly

Best input: a JSON array of objects.

[
  {"id": 1, "product": "Notebook", "qty": 3, "price": 4.99},
  {"id": 2, "product": "Pen", "qty": 10, "price": 1.25}
]

Output columns: id, product, qty, price. Two rows.

Single objects can sometimes be wrapped as a one-row table. Primitive arrays (lists of strings) become one column.

Step-by-step

Copy JSON from your API client, log file, or database export.
Open JSON Formatter first if the payload is minified - pretty print helps spot errors.
Open JSON to CSV.
Paste JSON and run conversion.
Download the .csv file.
Open in Excel, LibreOffice, or Google Sheets.

Fix syntax errors (trailing commas, single quotes) before converting. CSV tools expect valid JSON.

Opening CSV in Excel without broken characters

Excel: Data > Get Data > From File > From Text/CSV.
Select UTF-8 encoding.
Confirm delimiter is comma.

Double-clicking CSV on Windows with non-English characters sometimes mangles encoding. Import wizard is safer.

Nested fields

Example API row:

{"user": {"email": "a@example.com"}, "total": 42}

Flattened CSV might look like:

user.email	total
a@example.com	42

If nesting is deep, consider exporting only the fields you need from the API or using jq in a script. For typical REST list endpoints, browser conversion is enough.

JSON to CSV vs writing a script

Situation	Use browser tool	Use Python/script
One export for a meeting	Yes	Overkill
Daily automated job	No	Yes
5 MB API response once	Yes (if device handles it)	Often easier
PII / regulated data	Yes, if local-only	Yes, on secure machine

Privacy for real customer data

Support tickets, invoices, and user lists belong in JSON exports. Do not paste them into random websites. Convert Freely processes JSON locally for JSON to CSV and JSON Formatter. Still follow your company policy on sensitive exports.

Common errors

"Not an array" - Wrap objects in [ ] or extract the array key (data.items).
Empty columns - Inconsistent keys across rows; missing keys become blank cells (normal).
Dates as numbers - Excel may show serial dates; format column as date after import.
Commas inside values - Proper CSV quoting handles commas in text fields.

Pair with other developer tools

Validate structure: JSON Formatter.
Encode IDs for URLs: URL Encoder.
Debug tokens: Base64 Encode/Decode.

Conclusion

Paste array JSON, download CSV, open in Excel. For quick, private exports, use JSON to CSV. More tutorials live under Developer Tools, including JSON formatting and Base64 explained.

Frequently asked questions

What JSON structure works best for CSV?: An array of objects works best: [{"name":"Ada","score":98},{"name":"Bob","score":87}]. Each object becomes one row. Keys become column headers.
Can CSV handle nested JSON?: CSV is flat. Nested objects are usually flattened into dotted columns (user.name) or stringified. Deep nesting may need custom scripts; shallow API payloads convert cleanly.
Is it safe to paste production API JSON online?: Only with tools that process locally. Convert Freely's JSON to CSV runs in your browser. Avoid pasting secrets into unknown cloud converters.
Will Excel open the CSV correctly?: Yes for UTF-8 CSV. If accents break, open Excel via Data > From Text/CSV and pick UTF-8. Google Sheets usually imports UTF-8 CSV without issues.
Can I convert JSON Lines (NDJSON)?: Wrap lines into an array or paste one JSON array. One object per line formats need a quick wrap: [ line1, line2 ] with commas between objects.

JSON to CSV