Convert JSON to CSV — export structured data for spreadsheets

Paste a JSON array of objects or upload a .json file, then export a CSV that works in Excel, Google Sheets, and data import systems.

JSON to CSV Converter

How it works

This converter turns a JSON array of objects into a CSV file for spreadsheets and data imports. It automatically collects keys across objects and outputs a consistent column set.

  • For best results, provide a JSON array: [{"a":1},{"a":2}].
  • Choose semicolon delimiter if your system expects European CSV formatting.
  • Conversion happens locally in your browser.

Related tools

FAQ

Nested objects will be converted to JSON strings. For clean columns, flatten your data first.

Columns are created from discovered keys. For strict ordering, pre-process your JSON keys in the desired order.

No. Local-only processing.

Explore related tools and guides

Use these internal links to complete your workflow faster (compress, convert, merge, split) and follow the most relevant guides.

Compress PDF

Reduce PDF size for portals, email and uploads.

Split PDF

Extract ranges or split large PDFs into smaller parts.

Rotate PDF

Fix sideways pages for submissions and printing.

Reorder PDF

Re-arrange pages before you upload or sign.

Delete PDF Pages

Remove unwanted pages to cut size and clutter.

JPG to PDF

Convert images into a single shareable PDF.

How to Compress PDF

Step-by-step PDF compression workflow.

JSON to CSV: Convert JSON Data to a Spreadsheet Format

API responses, database exports, and configuration files often come as JSON. This tool converts JSON arrays into clean, comma-separated CSV files ready to open in Excel, import into a database, or load into a data analysis tool — processed entirely in your browser.

How to convert JSON to CSV

  1. Paste your JSON or upload a .json file.
  2. Click Convert — the headers are extracted from the JSON keys automatically.
  3. Download the CSV or copy the output.

Common use cases

Frequently asked questions

What JSON structure is supported?
The converter expects an array of objects at the root level — the most common API format. Nested objects are flattened using dot notation (e.g., address.city).
What happens with nested or complex values?
Simple nested objects are flattened. Arrays within objects are converted to a pipe-separated string in a single cell.
Is my data private?
Yes — all processing is local in your browser with no server communication.

Related tools