Skip to content
ToolQivo

JSON to CSV

Turn a JSON array into a spreadsheet-ready CSV file.

Converters Reviews Free · no sign-up

Quick Tool Overview

JSON to CSV turns an array of JSON objects into a CSV file that opens cleanly in Excel, Numbers or Google Sheets. Headers are collected from every object in the array, nested objects are flattened with dot notation, and values are escaped to the RFC 4180 standard.

What it does
Converts a JSON array into spreadsheet-ready CSV
You give it
An array of JSON objects
You get back
A CSV file with a header row, ready to download
Best for
API exports, reporting and handing data to non-developers
Converters Free, unlimited use No sign-up Runs in your browser

About the JSON to CSV

Paste an array of JSON objects and get back a CSV that opens cleanly in Excel, Numbers or Google Sheets. Column headers are collected from every object in the array, so records with different keys still line up correctly rather than silently losing fields.

Nested objects are flattened using dot notation — an address object becomes address.city and address.postcode columns — and arrays are joined into a single cell. Values containing commas, quotes or line breaks are escaped to the RFC 4180 standard, which is the part hand-rolled converters usually get wrong. You can choose a comma, semicolon or tab delimiter; semicolon is what Excel expects in most European locales.

Key features of the JSON to CSV

Headers from every record

Columns are collected across all objects in the array, so records with different keys line up instead of silently losing fields.

Nested objects flattened

An address object becomes address.city and address.postcode columns rather than an unusable blob in one cell.

Proper RFC 4180 escaping

Values containing commas, quotes or line breaks are escaped correctly — the part hand-rolled converters usually get wrong.

Three delimiters

Comma, semicolon or tab; semicolon is what Excel expects in most European locales.

Arrays joined sensibly

List values are joined into a single readable cell instead of being dropped.

How to use the JSON to CSV

  1. 1

    Paste your JSON

    Provide an array of objects, such as a typical API response.

  2. 2

    Choose a delimiter

    Comma for most cases, semicolon for European Excel, or tab for pasting straight into a sheet.

  3. 3

    Download the CSV

    Copy the output or download it as a .csv file ready to open in a spreadsheet.

Frequently asked questions

An array of objects, where each object becomes a row. A single object is also accepted and produces a one-row file.

Reviews of the JSON to CSV

What people who use the JSON to CSV think of it. Reviews come from visitors and are posted as written.

No ratings yet

Yours would be the first.

  • 5 0 reviews rated 5 stars
  • 4 0 reviews rated 4 stars
  • 3 0 reviews rated 3 stars
  • 2 0 reviews rated 2 stars
  • 1 0 reviews rated 1 star

Write a review

Used this tool? Your rating helps the next person decide.

Your rating

Plain text only — links, email addresses and HTML are not accepted. Your name and review are shown publicly; nothing else is collected. See the privacy policy.

0 reviews

Newest first

No reviews yet

Be the first to rate the JSON to CSV. It takes half a minute and no account.

Write the first review

More converters