# JSON to CSV

Turn a list of flat JSON objects into a quoted CSV dataset.

[Open this tool](https://whatson.pk/developer-json-csv-calculator/)

Category: Developer & Data

A list of object records can become a spreadsheet dataset when their fields are made explicit.

Paste the records and inspect the combined columns before exporting. Review missing values on the same basis.

## Inputs and controls

* Array of objects
* Input separator: Comma; Tab; Semicolon; Pipe
* CSV export values: Protect spreadsheet formula cells; Preserve raw machine values

## How to use

* Paste or enter array of objects.

* Choose input separator and CSV export values.

* Select Process input. Read the returned values alongside the assumptions below before copying, exporting or acting on the result.


## Why use this tool

The union of field names prevents a column from disappearing because it was absent in the first record.


## Before relying on the result

Fields use the union of object keys. Missing and null fields become blank cells. Nested objects and arrays become compact JSON in a cell.


## Tool limitations

Fields use the union of object keys. Missing and null fields become blank cells. Nested objects and arrays become compact JSON in a cell.

## Questions

### What happens to nested objects?

They become compact JSON inside a CSV cell. Missing and null values become blank cells.

### What should I check before using JSON to CSV?

Check Array of objects, Input separator and CSV export values. Use the exact units shown beside the controls and replace any example values with your own inputs.

Source page last modified (UTC): 2026-10-04T16:58:29+00:00

This profile describes the tool. It does not execute it or supply a professional certification.