Free online JSON to CSV converter. Convert JSON data to CSV format for spreadsheet applications. Supports nested JSON structures.
Input JSONLines: 1
Frequently Asked Questions
What is CSV format?
CSV (Comma Separated Values) is a simple text format where data is organized in rows, with values separated by commas. It is commonly used for spreadsheet applications and database exports.
How does JSON to CSV conversion work?
The converter takes a JSON array of objects and converts each object to a row. The column headers are derived from the object keys. Nested objects are flattened using dot notation.
What happens with nested JSON structures?
Nested objects are flattened using dot notation. For example, {"address": {"city": "NYC"}} becomes address.city as a column header with "NYC" as the value.
Can I convert arrays within JSON to CSV?
Yes, arrays in JSON are converted to semicolon-separated values within a single cell. For example, ["read", "write"] becomes "read; write".