JSON to CSV Converter
Transform JSON data into CSV tables with customizable options.
- Home
- > Web Dev >
- JSON to CSV
What is JSON to CSV Conversion?
JSON to CSV conversion transforms JavaScript Object Notation (JSON) data into a Comma-Separated Values (CSV) format that can be opened in spreadsheet applications like Excel, Google Sheets, or LibreOffice Calc.
This tool supports three conversion modes:
- Standard — Converts an array of objects into CSV rows. The keys of the first object become column headers.
- Flatten — Flattens nested objects using dot notation (e.g.,
address.city) so deeply nested JSON becomes flat CSV columns. - Simple — Converts a single object into two columns (key, value), one row per property.
How to Use
- Paste your JSON — Copy and paste any JSON data into the input textarea. You can also click Load Example to load sample data.
- Choose settings — Select the delimiter (comma, semicolon, tab, or pipe), conversion mode (Standard, Flatten, or Simple), and whether to quote all fields.
- Convert — Click Convert to CSV to generate the CSV output. The tool handles proper escaping of commas, quotes, and newlines within values.
- Copy or download — Use the copy button on the output area or click Download .csv to save the result as a file.
Frequently Asked Questions
What types of JSON can be converted?
This tool works best with arrays of objects ([{"id": 1, "name": "Alice"}, ...]). Single objects and nested objects are also supported using the appropriate mode. Arrays of primitives (e.g., [1, 2, 3]) are converted to a single-column CSV.
How are special characters handled?
Values containing the delimiter, double-quotes, or newlines are automatically wrapped in double-quotes. Any double-quotes within a value are escaped by doubling them (""), following standard CSV rules (RFC 4180).
Is this tool safe for sensitive data?
Yes. All processing happens entirely in your browser using JavaScript. Your JSON data is never uploaded to any server, stored in any database, or logged. This makes it safe for converting sensitive data like API responses or configuration files.
