Data and JSON tools Free · No sign-up · No upload

Convert JSON to CSV

Turn a JSON list of records into a CSV you can open in Excel, Sheets or a database tool. Nested data becomes columns. Your data is converted in your browser and never uploaded.

  • No watermark or limits
  • Client-side only
  • Nested values become columns
  • Formula guard option
Your data
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: JSON → OUT: CSV
How was JSON to CSV?
How it works

JSON to CSV in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Start with your JSON

    Use a list of objects, or an object that wraps a single list.

  2. STEP 02

    Set the output options

    Choose how to treat nested values, the CSV separator, and whether to guard against spreadsheet formulas.

  3. STEP 03

    Copy or download the CSV

    The note shows how many rows were written.

What you get

What JSON to CSV does, and what it doesn't

We'd rather tell you up front than surprise you after the download.

What you get

  • Columns from all recordsThe header is the combined set of keys across every record, so a field that appears in only some of them still gets a column.
  • Three ways to treat nestingFlatten everything into columns like address.city and tags.0, flatten objects but keep lists as JSON text, or keep nested values as JSON text.
  • Separator choiceWrite with commas, semicolons or pipes, for regional spreadsheet settings or tools that expect them.
  • Formula guardOptionally escape cells that start with =, +, - or @, which spreadsheets might treat as formulas.
  • Proper quotingValues with separators, quotes or line breaks are quoted, with inner quotes doubled, as RFC 4180 describes.

Good to know

  • Wide, sparse dataRecords with very different shapes produce many mostly-empty columns. Convert one record type at a time.
  • Line breaks are LFRows end with a line feed rather than CRLF. If a tool wants CRLF, run the file through the CSV formatter.
  • Big integersNumbers beyond 2^53 are read by the browser and may lose precision before conversion.
Private by design

Your data never leave your device

The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.

Typical online tool upload

Your device→Their server→Your device

Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.

Mediaextractr no upload

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

When people use JSON to CSV

Analyze an API export in a spreadsheet

Open the result in Excel or Google Sheets for filtering and pivots.

Load records into a database

Use CSV for a bulk import, or go straight to JSON to SQL INSERT.

Share data with colleagues

Give non-developers a file they can open.

Check data quickly

See a table of values rather than nested braces.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends on their servers

How JSON becomes rows and columns

Each object in the list becomes one row. Each key becomes a column. For nested objects, the default is to join the key names with a dot, so {"address": {"city": "Pune"}} gives an address.city column. List entries get a position, such as tags.0 and tags.1.

If your JSON is a single object with one list inside, the tool uses that list automatically and tells you which key it used.

Avoiding common surprises

Spreadsheets can change data on open, so a little care helps:

  • Long numeric IDs and leading zeros can be altered by Excel. Import the file as text instead of double-clicking it.
  • Turn on the formula guard if the data comes from users and the file will be opened in a spreadsheet.
  • Use semicolons if your spreadsheet uses a comma as the decimal mark.
  • Go the other way with CSV to JSON.

From API data to a spreadsheet

A typical flow is to copy a JSON response from your browser's network tab, convert it here, and open the CSV in a spreadsheet for sorting and pivot tables. If the response wraps its records in an object with one list, such as a data or results key, the tool finds that list for you and tells you which key it used.

FAQ

Questions, answered

How do I convert JSON to CSV?

Paste a JSON list of records, pick your options and copy or download the CSV.

How does it handle nested JSON?

By default nested keys become dotted column names, such as address.city. You can also keep nested values as JSON text.

Is customer data in my JSON uploaded during conversion?

No. The conversion to CSV happens in this browser tab and nothing is transmitted, so exports with personal details stay on your device.

What does the formula guard do?

It escapes cells that begin with =, +, - or @, so a spreadsheet shows them as text instead of evaluating them as formulas.

Can I get semicolon-separated output?

Yes. Choose the semicolon as the CSV separator.

Can I convert on Android or iPhone?

Yes. It works in the current mobile browsers, and the CSV can be saved to Files or Drive.