# JSON to CSV Converter

> A JSON to CSV converter flattens an array of objects into spreadsheet rows, using the union of every key as the header row. Values containing commas, quotes or newlines are escaped so the file opens cleanly in Excel and Google Sheets.

Source: https://rankcert.com/tools/json-to-csv
Free, no signup. Updated: 2026-09-02

## How to use it

1. Paste a JSON array of objects.
2. Pick the delimiter your spreadsheet expects.
3. Copy the CSV, or paste it straight into a sheet.

## Questions

### What JSON shape does this expect?

An array of flat objects, which is what almost every API returns for a list. A single object is treated as a one-row table.

### What happens to nested objects and arrays?

They are stringified into one cell. CSV has no way to express nesting, so flatten the data before converting if you need the inner values in their own columns.

### Why do some rows have empty cells?

The header row is the union of every key across all objects. Any object missing a key gets an empty cell there, which is the correct flat representation.

### How do I open the CSV in Excel without mangling it?

Use Data then From Text/CSV rather than double-clicking, and set the encoding to UTF-8. Double-clicking often guesses the delimiter and encoding wrongly.

### Are quotes and commas escaped properly?

Yes. Any value containing a comma, quote or newline is wrapped in double quotes with internal quotes doubled, per RFC 4180.

### Should I use a comma or a semicolon?

Comma for anything programmatic. Semicolon if the file will be opened in a spreadsheet set to a locale that uses a comma as the decimal separator.

### Is my JSON sent to a server?

No. Parsing and conversion happen in your browser with no network request.

### How do I do this in a script?

In Python, pandas.read_json then to_csv is one line each. In Node, the json2csv package or a short reduce over Object.keys does the same.

## Related tools

- [Regex Tester](https://rankcert.com/tools/regex-tester): Test a JavaScript regular expression against sample text, see every match with its position and capture groups, and get real errors for invalid patterns.
- [Base64 Encode / Decode](https://rankcert.com/tools/base64-encode-decode): Encode text to base64 or decode it back, with full UTF-8 support and automatic handling of base64url input. Runs entirely in your browser.
- [Wildcard Mask Calculator](https://rankcert.com/tools/wildcard-mask-calculator): Convert a CIDR prefix or subnet into the wildcard mask Cisco ACLs and OSPF network statements expect, with the subnet mask and address range alongside it.
- [Diff Checker](https://rankcert.com/tools/diff-checker): Paste two versions of a text and see every added and removed line highlighted, computed in your browser with no upload.
- [CSV to JSON](https://rankcert.com/tools/csv-to-json): Turn a CSV into an array of JSON objects in your browser, with proper handling of quoted fields, embedded commas and custom delimiters.
- [Password Generator](https://rankcert.com/tools/password-generator): Generate strong random passwords in your browser using the Web Crypto API, with an entropy figure so you can see how strong they actually are.