ToolXkit Icon

JSON to CSV

Flatten a JSON array into rows and columns.

  • Free
  • No signup
  • Nothing uploaded
  • No watermark

Options

Separator

Use semicolons if your spreadsheet software is set to a European locale.

Nested objects are flattened into dotted column names, so { user: { name } } becomes a “user.name” column.

Processed entirely on your device. Nothing was uploaded.

How to Convert JSON to CSV Online

JSON to CSV: before and after JSON A JSON FILE JSON TO CSV CSV A CSV FILE

Flattens a JSON array into rows and columns. Where records have different keys, the union becomes the header row and missing values become empty cells — otherwise you would silently lose whatever the first record happened not to contain.

No software to install Free Works on any device

Step-by-Step Guide to Convert JSON to CSV

  1. 1. Upload a .json file, or paste your JSON

  2. 2. Choose a delimiter

  3. 3. Press Convert to CSV — nested keys become dotted columns

No .json file to hand? Download a sample JSON file (3.5 KB) and try it.

Try it now

What is JSON to CSV Conversion?

Flattens a JSON array into rows and columns. Where records have different keys, the union becomes the header row and missing values become empty cells — otherwise you would silently lose whatever the first record happened not to contain.

JSON file

.JSON

Flatten a JSON array into rows and columns.

See an Example

Before 

[{"name":"Ada","city":"London"},{"name":"Grace","city":"Oslo"}]

After 

name,city
Ada,London
Grace,Oslo

Why Use Excel and CSV Tools?

Data rarely arrives in the shape you need: one colleague sends CSV, a website gives JSON and the system wants Excel. These tools convert, merge, split and clean sheets so the rows are ready to use.

“Clean data first, and the analysis gets much easier.”
  • Any sheet into any format
  • Many workbooks in one
  • Columns picked and sorted
  • Help writing formulas
  • Duplicate rows removed
  • Large sheets split into parts
  • Tables ready for websites
  • Customer lists kept private

Popular Uses for Spreadsheet Converters

Spreadsheet chores are the same in every office, and these handle the dull ones.

  • Cleaning contact lists Remove duplicate rows from a customer or student list before sending a mailer.
  • Combining monthly sheets Join twelve monthly Excel files into one workbook for the yearly total.
  • Data for web apps Turn a sheet of products into JSON for a website or mobile app.
  • Opening exported JSON Turn a JSON or XML export from an online system into a readable Excel sheet.
  • Sharing some rows Split a large file so each branch or teacher gets only their own rows.
  • Tables for web pages Convert a CSV into an HTML or Markdown table to paste into a blog post.
  • Picking columns Keep only the name, phone and email columns from a long export.
  • Filtering and sorting Show only the rows for one city or date range, then sort them.

What the JSON to CSV Converter Does

Accepts JSON, TEXT

Reads JSON and writes CSV

Cell types are carried across — a number stays a number and a date stays a date

Quoting, delimiters and encoding follow RFC 4180, so Excel opens the result without mangling it

Why Use ToolXkit for JSON to CSV?

Your files stay with you

Everything runs inside your browser. Nothing you open or type is uploaded to a server.

Data Tools for Different Users

Small businesses

Tidy stock lists and customer records without buying extra software.

Teachers

Split class marks by section and remove repeated student entries.

Data analysts

Switch quickly between CSV, Excel, JSON and XML while preparing a dataset.

Developers

Turn spreadsheets from clients into JSON or YAML that code can read.

Marketing teams

Clean and merge lead lists gathered from different forms and events.

HR teams

Filter employee lists and share only the columns each manager needs.

Best Times to Clean Up a Spreadsheet

These tools earn their place when you are:

  • Importing contacts into a new system
  • Preparing a mailing list
  • Merging reports from several branches
  • Handing data to a developer
  • Publishing a table online
  • Opening a file Excel will not read
  • Splitting a sheet for different teams
  • Checking a list for repeats

Frequently Asked Questions

Answers to common questions about this tool.

How are nested objects handled?

They are flattened into dotted column names — an address.city key becomes a column called address.city — so nothing is lost and the sheet stays one row per record. Arrays of primitives are joined with a separator you can change.

What if the objects have different keys?

The header is the union of every key seen, in first-appearance order. A record without a key simply has an empty cell in that column.

Will Excel open the CSV correctly?

Yes. The file is written with a UTF-8 byte-order mark so accented characters survive, and values containing commas, quotes or line breaks are quoted the way Excel expects.

Do I need Excel installed to use JSON to CSV?

No. The spreadsheet is read by the page itself, so it works on computers without Microsoft Office, and on phones and tablets too. The result downloads in the format you picked.

Are my spreadsheets uploaded?

No. Customer lists, salary sheets and sales figures are processed inside your browser and never sent to a server. When you close the tab, the data is gone from the page.

Can JSON to CSV handle files with thousands of rows?

Usually, yes. Sheets with thousands of rows work well on most devices. Very large files depend on your computer’s memory, so a laptop copes better than an older phone.

Will formulas survive the conversion?

Formats like CSV, JSON and XML store values, not formulas, so a converted file holds the calculated results. Keep your original workbook if you will need the formulas again.

Why do dates or leading zeros look wrong afterwards?

Spreadsheet programs sometimes guess that a phone number or ID is a number and drop its leading zeros, or read a date in the wrong order. Check those columns, and format them as text in Excel if needed.

Further reading

More Excel & Data Tools

Other free tools for the same kind of job.

Browse all tools