What JSON structure is supported?

The tool works best with arrays of objects (e.g., [{name: 'Alice', age: 30}, ...]). It auto-detects all unique keys across objects as CSV columns. Nested objects are flattened using dot notation.

Can I use a custom delimiter instead of commas?

Yes. You can choose comma, semicolon, tab, or pipe as the delimiter. This is useful for systems that expect TSV (tab-separated) or other formats.

How are nested JSON objects handled?

Nested objects are flattened using dot notation. For example, {address: {city: 'NYC'}} becomes a column named 'address.city'. Arrays within objects are joined with semicolons.

Can I convert an API response directly to CSV?

Yes. Paste the JSON response from any REST API. If the data is wrapped in an envelope (e.g., {results: [...]}), the tool detects the array inside and converts it. You can then download the result as a .csv file.

How do I open the CSV file in Excel?

Download the .csv file and double-click to open in Excel. If columns don't separate correctly, use Excel's Data > From Text import wizard and select the correct delimiter (comma, semicolon, or tab).

What happens with missing fields in my JSON?

If some objects in your array are missing certain keys, those cells will be empty in the CSV. All unique keys across all objects are used as column headers, ensuring no data is lost.

JSON to CSV Converter — Export & Download

How to Use the JSON to CSV Converter

Paste a JSON array of objects into the input panel and the CSV output generates in real time. Validate your JSON first with our JSON Formatter. The tool auto-detects all unique keys across objects and uses them as column headers. Choose your preferred delimiter (comma, semicolon, tab, or pipe) and toggle header inclusion. Click Download to save the result as a .csv or .tsv file that opens directly in Excel, Google Sheets, or any spreadsheet application.

How Nested JSON Is Handled

Nested objects are flattened using dot notation. For example, a JSON object like{"user": {"name": "Alice", "address": {"city": "NYC"}}} produces columns named user.name and user.address.city. Arrays within objects are joined with semicolons. This approach preserves all data while creating a flat structure compatible with spreadsheet formats. If an object is missing a key that other objects have, the cell is left empty in the CSV output.

Common Use Cases

Export API response data to spreadsheets for analysis. Convert MongoDB or Firebase query results to CSV for reporting. Transform JSON log files into tabular format for data processing. Need YAML instead? Use our JSON to YAML Converter. Prepare data exports for clients who need Excel-compatible formats. All conversion happens in your browser — your JSON data never leaves your device.

JSON to CSV Converter

How to Use the JSON to CSV Converter

How Nested JSON Is Handled

Common Use Cases

Frequently Asked Questions

Related Tools

JSON Formatter & Validator

JSON to YAML Converter

Base64 Encoder / Decoder

String Encoder / Decoder