Skip to content
JSONRow
Colour theme

JSON to CSV converter

Turn an API response, export or config file into a CSV you can open in Excel, Google Sheets or Numbers. Your file is processed on this device. Nothing is uploaded.

Choose a JSON file, or drop it here

JSON and JSON Lines (.json, .jsonl, .ndjson). Large files are fine; very large ones depend on your device’s memory.

Your file is processed on this device. Nothing is uploaded.

How to convert JSON to CSV

  1. Choose your file, or drop it on this page. The whole file is read once to find every field.
  2. Check Rows. When your records sit inside an object, such as {"data": [...]}, the converter picks the list that looks most like records. You can choose a different one.
  3. Untick the columns you don’t need. To rename a column, select the pencil next to it.
  4. Pick a delimiter, select Convert to CSV, then download the file.

What happens to nested data

Each nested field becomes its own column, named by its path with a dot between each level. A customer’s city inside an address becomes customer.address.city. Records that don’t have a field get an empty cell, so every row has the same columns.

Lists of plain values, such as tags, are joined into one cell with a semicolon between items. Lists of objects, such as the items in an order, stay in one cell as compact JSON, so nothing is lost.

orders.json
{
  "orders": [
    {
      "id": 1001,
      "customer": { "name": "Ana Sousa", "city": "Lisbon" },
      "tags": ["gift", "priority"]
    },
    {
      "id": 1002,
      "customer": { "name": "Kenji Watanabe" },
      "tags": []
    }
  ]
}
orders.csv
id,customer.name,customer.city,tags
1001,Ana Sousa,Lisbon,gift; priority
1002,Kenji Watanabe,,

Common problems

Only one row comes out

Your records are probably inside an object. Under Rows, choose the list that holds them. The row count next to each option shows which one it is.

Excel shows é instead of é

Excel guesses the wrong text encoding for CSV files that don’t say which one they use. Keep Mark as UTF-8 for Excel ticked and accented letters, and other scripts, open correctly.

Excel puts everything in the first column

With many European language settings, Excel expects semicolons rather than commas. Choose Semicolon as the delimiter and convert again.

“This file isn’t valid JSON”

The message gives the line and column of the problem and shows that part of the file. The usual causes are a comma after the last item in a list, comments, text in single quotes, or a file that was cut off during download.

Questions

Is my JSON file uploaded anywhere?

No. Your browser reads the file and converts it on your device. There is no server that receives it, and the CSV is written to your browser’s own storage until you download it.

How large a file can I convert?

Files of several hundred megabytes work on a typical laptop. The limit is your device’s memory and free disk space rather than a fixed size. Phones and tablets have less memory, so very large files are better converted on a computer.

What happens to null values and missing fields?

Both become empty cells. For fields that aren’t in every record, the column list shows the share of rows that have a value.

Are long ID numbers kept exactly?

Yes, in current versions of Chrome, Edge and Firefox. Integers with more than 15 digits, such as database or social media IDs, are written exactly as they appear in the file instead of being rounded. In other browsers the converter warns you before you convert.

Which delimiter should I use?

Comma is the standard and works in most programs. Use semicolon if your spreadsheet uses a comma as the decimal separator, as many European language settings do. Use tab to paste the result into another program, and pipe when your data contains many commas and semicolons.

To see exactly what happens to your file, read how the converter works, including how to check that nothing is uploaded.

  • JSON Lines to CSV: Convert NDJSON logs and exports, where each line is one record.
  • Large JSON to CSV: Files of hundreds of megabytes, read in pieces so the page doesn’t run out of memory.