tooldura
All tools

JSON to CSV Converter

Turn a JSON array into CSV, flatten nested objects into columns and preview the table

CSV output

Your CSV shows up here

Paste JSON on the left or import a file. You get a table preview and the CSV text, ready to copy or download.

Delimiter

Pick Semicolon if Excel puts every value in column A, which happens where the comma is the decimal separator.

Nested objects

{"user":{"city":"Oslo"}} becomes a user.city column.

Need it the other way? Convert CSV to JSON

Found JSON to CSV Converter useful? Share it.

About JSON to CSV Converter

The JSON to CSV Converter turns an array of JSON objects into rows and columns. Every key it finds in any object becomes a column, in the order it first appears, and an object that lacks a key gets an empty cell there. Nested objects are flattened into dotted column names, so a user object holding a city becomes a user.city column, or you can keep each nested object whole as JSON text in a single cell. Arrays always stay in one cell as JSON, which keeps the row count equal to the number of objects. Values are quoted the way RFC 4180 describes: only a value that contains the delimiter, a double quote or a line break is wrapped in quotes, and quotes inside it are doubled. If the JSON is an object with one list of records inside, such as an API response with a data array, that list is converted and the tool tells you so. Number digits are copied as written where the browser allows it, so long IDs are not rounded on the way.

✦FreeNo paywalls or tiers
⬡No SignupNothing to create
⚡InstantNo setup, no install
⊞Any DeviceMobile, tablet, desktop

The guide behind this tool

From JSON to CSV: Nested Objects, Arrays and the Excel Problem

Dot paths for nested objects, three ways to handle an array, and why Excel garbles a correct CSV: the BOM, the semicolon, 15 digits and lost zeros.

9 min read

How to use JSON to CSV Converter

  1. 1

    Paste your JSON into the left box, or import or drop a .json file onto it.

  2. 2

    Check the table preview on the right. The line above it says how many rows and columns came out.

  3. 3

    Choose the delimiter. Use Semicolon if the file is going to Excel in a country where the comma is the decimal separator.

  4. 4

    Decide whether nested objects become their own columns or stay as JSON text.

  5. 5

    Tick the Excel-friendly encoding box if the data has accents or other non-English characters and will be opened in Excel.

  6. 6

    Copy the CSV, or download it as a .csv file (.tsv when the delimiter is Tab).

Frequently Asked Questions

Excel opens a CSV in the computer's legacy code page unless the file starts with a byte order mark (BOM), so UTF-8 text such as é or ü comes out as two odd characters. Tick Excel-friendly encoding before downloading and the file gets a BOM, which Microsoft's own guidance names as the way to make a UTF-8 CSV open correctly. The box changes only the downloaded file. Copied text stays without a BOM, because many other programs would read it as part of the first column name.