JSON to CSV
Convert JSON arrays and objects to CSV format. Flattens nested structures with dot notation.
# CSV output will appear here...Frequently Asked Questions
How does JSON to CSV conversion work?
The converter analyzes your JSON structure and creates CSV columns from object keys. Arrays of objects become multiple rows, with each object's values filling one row. Nested objects are flattened using dot notation (e.g., address.street).
Can I convert nested JSON to CSV?
Yes. Nested objects are flattened using dot notation for column headers. For example, {address: {city: 'NYC'}} becomes a column named 'address.city' with value 'NYC'.
How are arrays within objects handled?
Array values within objects are joined with semicolons. For example, {tags: ['dev', 'admin']} becomes 'dev;admin' in the CSV output.
Does it handle special characters in CSV?
Yes. Values containing commas, newlines, or double quotes are properly escaped. Double quotes are doubled, and the entire value is wrapped in quotes per the CSV standard (RFC 4180).
Can I open the CSV in Excel or Google Sheets?
Yes. The generated CSV follows the standard RFC 4180 format and can be opened directly in Microsoft Excel, Google Sheets, LibreOffice Calc, and any other spreadsheet application.
What if my JSON is a single object, not an array?
A single object produces a 2-row CSV: the first row contains the key names as headers, and the second row contains the corresponding values.