JSON to CSV Converter

Convert JSON to CSV and CSV to JSON online. Flatten nested objects, handle NDJSON, and download the result. Free, client-side, no data sent to any server.

Private by default: JSON, CSV, and NDJSON conversion runs entirely in your browser. Nothing is uploaded, so you can safely inspect API payloads, exports, and internal data locally.

Paste a JSON array, a single object, or JSON Lines / NDJSON with one object per line.

Drop a .json, .ndjson, .jsonl, or .csv file here.
Drop a file here to load input instantly Large API payloads and spreadsheet exports stay in your browser.

JSON to CSV conversion

JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two of the most common data interchange formats. JSON is hierarchical and self-describing, making it ideal for APIs and configuration. CSV is flat and tabular, making it ideal for spreadsheets, databases, and data analysis tools like Excel, Google Sheets, and pandas.

Why flatten nested JSON?

Many real API responses contain nested objects such as user.profile.name or billing.address.city. Flattening those objects into dot-path columns makes the result immediately usable in spreadsheets, BI tools, and import workflows without manual cleanup. Arrays are kept as JSON strings so list data is preserved in one cell.

Why use a column picker?

Real-world JSON often includes internal IDs, debug flags, nested metadata, and other fields you do not want in a spreadsheet. The built-in column picker lets you keep the useful columns and drop the noisy ones before you copy or download the CSV.

How live conversion works

Auto-convert is enabled by default so you can iterate on payload cleanup quickly. If you are working with a very large export, turn auto-convert off and use the Convert button or press Ctrl/Cmd + Enter to run the conversion only when you are ready.

Save drafts and share setups

Your latest draft is saved locally in your browser so you can refresh the page without losing a half-finished conversion. Use Copy share link when you want to send the current settings to a teammate. Large payloads stay out of the URL automatically, which keeps sensitive data local while still sharing the conversion setup.

Supported input formats

  • JSON arrays: Best for most API responses and exported datasets.
  • Single JSON objects: Useful for turning one record into a one-row CSV.
  • JSON Lines / NDJSON: Great for logs, event streams, and bulk exports with one object per line.
  • CSV input: Convert tabular data back into JSON objects for APIs or frontend work.

When to convert JSON to CSV

  • Data analysis: Import API response data into Excel, Google Sheets, or pandas DataFrames.
  • Database import: Prepare data for bulk import into SQL databases.
  • Reporting: Convert structured data into a format stakeholders can open in spreadsheet software.
  • Data migration: Move data between systems that use different formats.

When to convert CSV to JSON

  • API integration: Convert spreadsheet data into JSON for API consumption.
  • Frontend rendering: Transform tabular data into objects for JavaScript frameworks.
  • Configuration: Convert flat data into structured configuration files.

Frequently Asked Questions

Is my data sent to a server? No. All conversion runs entirely in your browser using JavaScript. Nothing is uploaded.

What happens to fields with commas? Fields containing the delimiter character are automatically wrapped in double quotes, per the RFC 4180 CSV standard.

Can I use this with JSON Lines? Yes. Paste one JSON object per line and the converter will treat each line as a separate row.