What should the JSON input look like?

The input should be a JSON array of objects: [{...}, {...}, ...]. Each object becomes a row. The union of all keys across all objects becomes the column headers.

What happens if some objects are missing certain keys?

Missing keys result in empty cells for that row. All unique keys across all objects are included as columns.

Can it handle nested JSON objects?

Nested objects are serialised as JSON strings within their cell. For deeply nested data, flatten the JSON first before converting.

JSON to CSV Converter

Converts a JSON array of objects to a CSV file, automatically extracting all unique keys across all objects as column headers. Handles missing fields with empty cells. Output is ready to open in Excel, Google Sheets, or any CSV-compatible application.

JSON Input (array of objects)

Turn API response data or database exports into spreadsheet-ready CSV without writing a script.

Frequently Asked Questions

Related Tools

Markdown to HTML

Convert Markdown to HTML instantly.

HTML to Markdown

Convert HTML markup to clean Markdown syntax.

CSV to JSON

Convert CSV data into a JSON array of objects.

XML to JSON

Convert XML documents to a JSON representation.

JSON to XML

Convert a JSON object or array to an XML document.

Text to Base64

Encode text as a Base64 string.