Convert JSON to CSV
Transform your JSON data into CSV format. Perfect for importing data into Excel, Google Sheets, or any spreadsheet application. All processing happens in your browser — your data never leaves your device.
To convert JSON to CSV, paste your JSON below. Your data is never sent to our servers.
JSON Input
Since the conversion is done inside your browser, extremely large files may cause trouble. Microsoft Edge has a smaller limit than other browsers.
Preview
About JSON to CSV Conversion
JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two popular formats for storing and exchanging data. Converting from JSON to CSV is useful when you need to work with the data in spreadsheets or other tools that accept CSV input.
This tool uses JSON5 for parsing, which allows for these additional features:
- Comments (both single and multi-line)
- Trailing commas in objects and arrays
- Unquoted object keys
- Strings can be single or double quoted
- Numbers can have leading/trailing decimal points
- Hexadecimal numbers and +Infinity, -Infinity, NaN
- Multi-line strings with line continuation
JSON is hierarchical and can contain nested objects and arrays, while CSV is flat. This converter handles these challenges by:
- Converting nested objects into string representations
- Extracting common fields from arrays of objects
- Preserving data types when possible
- Providing options for different separators
How are nested objects handled?
Nested objects are converted to string representations in the CSV. For complex hierarchical data, some information hierarchy might be lost in the conversion process.
Is my data secure?
Yes, all processing happens in your browser. Your data is never sent to any server.
What JSON formats are supported?
This converter supports standard JSON arrays of objects or a single object. For best results, use an array of objects with consistent fields.
What are the limitations?
Very large JSON files may slow down your browser. Complex nested structures might not convert perfectly to CSV format due to the inherent differences between hierarchical and tabular data formats.