Convert JSON to CSV Online

Convert JSON array or object to CSV.

Loading tool...

How to use

Paste or type your input in the left editor
Adjust options in the toolbar if available
Copy or download the output from the right pane

This free online tool runs entirely in your browser. No sign‑up, no server uploads.

About JSON to CSV Converter

Convert JSON array or object to CSV.

The JSON to CSV converter parses your JSON array input and analyzes all objects to build a union of unique keys as column headers. Nested objects are flattened using dot notation to create a flat column structure. Each JSON object is then mapped to a CSV row, with values properly escaped according to RFC 4180 — quoting fields that contain commas, newlines, or double quotes. The result is a standards-compliant CSV file.

Use the left editor to enter your data. The output updates in real time. You can copy, clear, download, or expand either pane.

Tip: Use the search bar to quickly switch between tools.

Sample CSV

name,age
Jane,29
John,31

Example input shown above. Output appears in the right pane instantly.

Why this tool?

Feature	JSON to CSV Converter	Typical alternatives
Free online tool	Yes	Often yes
Client‑side only (privacy)	Yes	Varies
No sign‑up required	Yes	Varies

Explore related tools

Looking for more? Browse All tools or check categories like Beautifier, Minifier, and Validators.

Related tools

FAQs

How does the converter handle nested JSON objects in CSV?

Nested objects are flattened using dot notation for column headers. For example, a nested path like user.address.city becomes a single CSV column header 'user.address.city', keeping all data accessible in a flat table format.

Can I convert a JSON array of objects to CSV?

Yes. The converter expects a JSON array of objects, where each object becomes a row and each unique key becomes a column header. Objects with different keys are handled gracefully — missing fields produce empty cells in the CSV output.

How are JSON arrays within objects handled in CSV output?

Array values within objects are serialized as comma-separated strings within a single CSV cell, or as indexed columns (e.g., tags.0, tags.1) depending on the flattening mode. This ensures no data is lost during conversion.

Does the converter handle special characters like commas in values?

Yes. Values containing commas, quotes, or newlines are automatically wrapped in double quotes following RFC 4180 CSV standards. Double quotes within values are escaped by doubling them, ensuring correct parsing by Excel and other spreadsheet software.

Can I open the CSV output directly in Excel or Google Sheets?

Absolutely. The generated CSV follows the RFC 4180 standard, making it fully compatible with Microsoft Excel, Google Sheets, LibreOffice Calc, and any other spreadsheet application. Download the file and open it directly.