How to Use
- 1 Paste your JSON array of objects into the Input JSON panel.
- 2 Click Convert to CSV to generate the CSV output.
- 3 Review the CSV in the CSV Output panel. The first row will be the column headers derived from your JSON keys.
- 4 Click Download .csv to save the file directly to your device.
- 5 Or click Copy to copy the CSV to your clipboard for pasting into Excel or Google Sheets.
- 6 Click Clear to reset both panels.
Frequently Asked Questions
Is my JSON data sent to a server?
No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device and is never stored or logged anywhere.
What JSON format is required?
The input must be a JSON array of objects (e.g. [{"name":"Alice","age":30}]). Each object becomes a CSV row. All objects should have the same keys for consistent column output.
How are commas and quotes in values handled?
Values containing commas, double quotes, or newlines are automatically wrapped in double quotes and internal double quotes are escaped as "" — following the RFC 4180 CSV standard.
What happens with nested objects or arrays?
Nested objects and arrays are converted to their JSON string representation in the CSV cell. For example, {"tags":["a","b"]} becomes a cell containing ["a","b"].
What happens with null or undefined values?
Null values are output as empty cells in the CSV. This is the standard behavior for representing missing data in CSV format.
Can I convert large JSON arrays?
Yes. The conversion runs in your browser and can handle reasonably large arrays. Performance depends on your device memory and the number of rows and columns.
How are column headers determined?
The column headers are derived from the keys of the first object in the array. If subsequent objects have different keys, those columns may have empty values for rows where the key is missing.
Can I open the CSV output in Excel?
Yes. Copy the output and paste it into a .csv file, or paste directly into Excel. Excel will recognize the comma-separated format automatically.