JSON to CSV converter

Convert JSON arrays into CSV rows with automatic column mapping

JSON input

Paste your JSON data here

CSV output

Converted CSV data

How to use this tool

Paste a JSON array of objects into the input field
The converter identifies all unique keys across objects to build column headers
Nested objects are flattened with dot notation for readable column names
Click "Convert to CSV" to generate the output
Copy or download the CSV for use in spreadsheets, databases, or reports

Example

JSON input:

[
  {
    "name": "Alice",
    "age": 28,
    "city": "Portland",
    "active": true
  },
  {
    "name": "Bob",
    "age": 35,
    "city": "Seattle",
    "active": false
  }
]

CSV output:

"active","age","city","name"
"true","28","Portland","Alice"
"false","35","Seattle","Bob"

Frequently asked questions

What JSON structures work best?

Arrays of objects with consistent keys produce the most predictable CSV output. Flat or shallow objects are ideal.

How are nested objects handled?

Nested objects are flattened with dot notation. For example, {"address": {"city": "Portland"}} becomes a column named address.city.

What happens to arrays inside JSON?

Arrays are converted to JSON strings in a single cell. For array-heavy data, consider preprocessing before conversion.

Can I convert a single JSON object?

Yes. A single object is treated as one row in the CSV output.

How are empty or missing values handled?

Missing keys are left blank in the CSV output. Empty strings remain empty.

Related tools

JSON to CSV converter

How the json to csv converter helps

Use the JSON to CSV converter when you have JSON data from APIs, exports, or test fixtures and need to open it in a spreadsheet, import it into a database, or share a readable table. JSON arrays of objects map naturally to CSV rows and columns, making this a common workflow for data analysts, developers, and business teams working with API responses or structured exports.

Utility Tally tools are built for quick, practical workflows: prepare the input, review the result, copy or download the output, and move on without creating an account. The guidance below explains how to use this page responsibly, what the result means, and which related tools or guides can help with the next step.

For best results, start with sample or non-sensitive data when you are learning a tool, then move to real work only after you understand the output. If the result will be sent to a client, imported into software, printed, published, or used in a security-related workflow, take an extra minute to verify formatting, totals, links, spelling, privacy, and destination requirements.

How to use it

Paste a JSON array of objects into the input field.
The converter identifies all unique keys across the objects to build columns.
Review the generated CSV and check that nested fields have been flattened sensibly.
Copy the CSV output or download it as a file.
Import into your spreadsheet application or database tool and verify the data.

How it works

The converter parses the JSON array and flattens each object into a single row. Object keys become column headers, and nested objects are flattened with dot-separated paths. Arrays within objects are stringified to preserve their content. The result is a standard CSV that can be opened in any spreadsheet application.

The result should be treated as a working output, not a substitute for professional review where tax, security, accessibility, legal, accounting, or production data requirements apply. Check the destination system, final format, and any local rules before relying on the result.

Practical tips

Consistent object keys across all entries produce the cleanest CSV output.

Nested objects are flattened with dot notation so column headers remain readable.

Empty or missing keys are left blank in the CSV output.

For JSON with deeply nested structures, preview the column mapping before importing the full result.

JSON to CSV Converter FAQ

What JSON structures work best for CSV conversion?

Arrays of flat or shallow objects produce the most predictable CSV output.

How are nested objects handled?

Nested objects are flattened with dot-separated paths as column headers.

What about arrays inside JSON?

Arrays are stringified into a single cell. For array-heavy data, consider preprocessing before conversion.