JSON to CSV

Nested JSON objects are flattened using dot notation. For example, {"user": {"name": "Alice", "age": 30}} becomes columns "user.name" and "user.age" with values "Alice" and "30". This creates a flat table structure suitable for CSV and spreadsheet formats.

This tool supports three delimiter options: comma (,) which is the standard CSV separator, semicolon (;) which is common in European locales where commas are used as decimal separators, and tab which creates TSV (Tab-Separated Values) format compatible with most spreadsheet applications.

Arrays of primitive values (strings, numbers) are joined with semicolons into a single cell value. Arrays of objects are flattened with indexed keys using dot notation (e.g., "items.0.name", "items.1.name"), creating additional columns for each nested element.

This tool processes data entirely in your browser, so performance depends on your device. It handles thousands of records efficiently. For very large files (100,000+ rows), consider using command-line tools like jq combined with csvkit for better memory management.

Yes. The CSV output uses standard formatting with proper quoting of fields that contain delimiters, quotes, or newlines. You can paste the output directly into Excel or save it as a .csv file. For European Excel versions, use the semicolon delimiter option.