handyman
Hazuu Tools

JSON to CSV Converter

Convert JSON arrays to CSV format — paste, configure, and copy instantly.

Input JSON
Output CSV
Converted CSV will appear here...
info

About JSON to CSV Converter

JSON to CSV Converter is a free online tool that turns a JSON array into a clean, tabular CSV file ready for spreadsheets, databases, and data pipelines. You paste a JSON array of objects and get back rows and columns — each property name becomes a column header and each object becomes a row — without writing a single line of code.

The tool is designed for the moment your data arrives as JSON but your next step expects CSV. That includes importing API responses into Excel or Google Sheets, preparing a data extract for a reporting tool, feeding records into a legacy ETL process, or supplying a flat file to a colleague who does not work with JSON. You can also switch the output delimiter between comma, semicolon, tab, and pipe to match exactly what the destination system expects, and toggle the header row off when the downstream system supplies its own schema.

Every conversion runs entirely inside your browser using PapaParse. Your JSON never leaves your machine — it is never uploaded, stored, or transmitted to a server. That makes the tool safe for confidential datasets, internal API responses, and production data exports. There are no usage limits, no account required, and no cost.

star

Key Features

check_circle

Arrays of objects to rows

Each JSON object in the array maps to one CSV row. Property names are collected from all objects to form a complete header, so sparse objects with missing keys still produce correctly aligned columns.

check_circle

Four output delimiters

Switch between comma, semicolon, tab, and pipe with a single click. Tab-separated output opens cleanly in Excel without an import wizard; semicolons are the standard in European locales.

check_circle

Optional header row

Toggle the header row on or off. Turn it off when piping output into a system that defines its own column schema or when appending to an existing CSV file.

check_circle

Client-side with PapaParse

Conversion runs in-browser with PapaParse, a mature CSV library. Your data is never sent to a server, making the tool safe for sensitive or confidential datasets.

check_circle

Handles nested-free flat arrays

The tool expects flat arrays of objects or arrays of arrays — the shape that most REST APIs and database query results already use — and produces spec-compliant CSV with values quoted when they contain the delimiter or a newline.

check_circle

Instant copy to clipboard

Copy the full CSV output with one button and paste it directly into Excel, Google Sheets, a terminal, or a text editor.

help

How to Use

01

Paste JSON

Copy your JSON array and paste it into the left input pane.

02

Configure

Choose the output delimiter and header options as needed.

03

Convert & Copy

Click "Convert", then use the copy button to grab your CSV.

code_blocks

Example

Each object in the JSON array becomes one CSV row. Property names are used as column headers in the first line.

JSON input
[
  {"id": 1, "name": "Alice", "role": "Engineer", "active": true},
  {"id": 2, "name": "Bob",   "role": "Designer", "active": false},
  {"id": 3, "name": "Carol", "role": "Manager",  "active": true}
]
CSV output
id,name,role,active
1,Alice,Engineer,true
2,Bob,Designer,false
3,Carol,Manager,true
lightbulb

Common Use Cases

  • arrow_circle_right

    Importing API responses into a spreadsheet

    REST APIs return JSON arrays. Convert the response directly to CSV and open it in Excel or Google Sheets without manual re-formatting. Unlike csv-to-json, which goes the other direction, this tool is the first step when your data source is JSON and your destination is a spreadsheet.

  • arrow_circle_right

    Preparing flat-file exports for reporting tools

    BI tools, dashboards, and reporting platforms commonly accept CSV uploads. Paste the JSON data export from your database or backend, convert it, and feed the CSV straight into the reporting pipeline.

  • arrow_circle_right

    Feeding legacy ETL and data warehouse ingestion

    Older ETL systems and data warehouse loaders often only accept delimited text files. The delimiter selector lets you target comma, semicolon, or tab format to match the loader configuration exactly.

  • arrow_circle_right

    Sharing structured data with non-technical colleagues

    JSON is opaque to people who do not write code. Converting it to CSV turns a developer artifact into a file any spreadsheet user can open, filter, and sort without any tooling.

  • arrow_circle_right

    Generating test fixtures and seed files

    When a test suite or database seeder needs a CSV rather than a JSON fixture, convert your existing JSON test data in seconds rather than maintaining two separate fixture formats.

quiz

Frequently Asked Questions

What is JSON to CSV Converter? expand_more
JSON to CSV Converter is a free online tool that converts JSON arrays of objects into tabular CSV format. Each object property becomes a column, and each object becomes a row in the output.
What JSON format is supported? expand_more
The tool supports arrays of objects (where property names become column headers) and arrays of arrays. The input must be a valid JSON array with at least one element.
What delimiters can I use? expand_more
You can choose from four output delimiters: comma (,), semicolon (;), tab, and pipe (|). The default is comma, which is the standard CSV separator.
Is my data secure? expand_more
Yes. All conversion happens entirely in your browser using PapaParse. No data is sent to any server, so your content remains completely private and secure.
Can I disable the header row? expand_more
Yes. Toggle the Header button off in the toolbar to exclude the header row from the CSV output. This is useful when your downstream system does not expect column headers.
How is this tool different from CSV to JSON? expand_more
The direction is reversed. CSV to JSON reads a flat text file and produces a JSON array of objects; this tool does the opposite — it reads a JSON array and writes CSV rows. Use this tool when your data source is JSON and your destination is a spreadsheet or CSV-based pipeline.
What happens to objects that have different keys? expand_more
PapaParse collects all unique property names across every object in the array and uses them as column headers. Objects that are missing a particular key will produce an empty cell in that column rather than causing an error.
Can I convert nested JSON objects to CSV? expand_more
The tool is designed for flat arrays of objects. Nested objects (properties whose values are objects or arrays) are serialized as a string in the cell rather than expanded into sub-columns. If you need to flatten deeply nested JSON first, use a JSON formatter or flattening tool before converting.