UtilityPilot.Find a tool

Data & Tables

JSON to CSV converter

Turn a JSON array of object records into a downloadable table. Choose nested-object flattening and keep only the columns you need.

Processed in your browserPrivacy details ↗

5 MiB per input · 50,000 records · 200 columns

Adjust your options

Spreadsheet-safe export can change formula-like cells by adding an apostrophe. Turning it off preserves raw values; use raw exports only in a trusted importer.

No sign-up. No upload.

A QUICK WALKTHROUGH

How to use this tool

  1. Paste an array of objects, or select its JSON file.
  2. Choose flattening, output delimiter and optional column positions.
  3. Convert, inspect the table preview and download the complete CSV.

How it works

Keys are collected in first-seen order across all records. Nested object fields can become dot-separated columns. Arrays stay serialized JSON inside one cell rather than multiplying rows. Missing and null values both become empty cells, so this conversion is not generally reversible. A literal dotted key conflicting with a flattened path is rejected.

A practical example

Start with

[{"id":"00123","address":{"city":"Lahore"}}]

What to expect

id,address.city
00123,Lahore

Important considerations

A nested array is not automatically expanded into several rows. Spreadsheet software may infer types when opening the result; import identifier columns as text to preserve leading zeros.

5 MiB per input · 50,000 records · 200 columns. Input remains in page memory until you reset or leave. Copy and download actions are initiated by you. No tool input is sent to a processing service.

One more useful detail

Can I convert a single object?

Wrap it in square brackets to make a one-record array. Empty arrays have no tabular schema and are rejected.