Toolsky

Free Online Tools & Utilities for Every Task.

JSON To CSV

Convert JSON to CSV Format

JSON Data
Drop JSON File Here
CSV Result Output
Data Preview 0 rows
Output Size: 0 B CSV Document: 0 lines
CSV Layout Options
JSON to CSV Converter Guide
1. Paste JSON Arrays
Paste your formatted array or singular objects into the left workspace.
2. Delimiter Control
Choose your column separation dividers (commas, semicolons, or tabs) and quote encapsulations.
3. Real-time Preview
Instantly verify details through the live interactive table dashboard, and click Copy or Download.

Converting JSON to CSV means turning structured data — usually an array of records — into rows and columns that a spreadsheet can open. JSON is how applications and APIs store and exchange information, but the people who need to sort, filter, chart, or eyeball that information usually reach for Excel, Google Sheets, or a similar tool, and those tools speak CSV. This converter bridges the two: paste your JSON, and get back a comma-separated file with a header row and one line per record.

Why Records Need Flattening to Become a Table

A CSV file is a grid: columns across, records down, every value a piece of text separated by commas. JSON is a hierarchy: objects nest inside objects, and arrays hold lists of varying length. Conversion therefore involves a decision about shape. For the common case — an array of flat objects that all share the same keys — the mapping is direct: the keys become the column headers, and each object becomes one row. Difficulties begin with nesting: an "address" object inside a customer record has no single column to live in, so converters either flatten it into columns such as address_city and address_zip, or leave it out. Knowing this in advance tells you what to expect from any conversion and how to prepare your data for a clean result.

What This JSON to CSV Converter Handles

  • Header row from your keys: the field names in your JSON become the column headings, so the spreadsheet opens with meaningful labels.
  • One row per record: each object in your array becomes a single line in the CSV, preserving the order of your data.
  • Proper quoting: values that themselves contain commas, quotes, or line breaks are wrapped in double quotes, with inner quotes doubled, as the CSV format requires.
  • Spreadsheet-ready output: the resulting file opens directly in Excel, Google Sheets, LibreOffice Calc, and most data tools.

How to Convert JSON to CSV Step by Step

  1. Prepare your JSON as an array of objects — a list of records such as products, orders, users, or transactions.
  2. Copy the JSON and paste it into the converter's input area.
  3. Run the conversion action.
  4. Check the preview: confirm the header row lists the columns you expect and the row count matches your record count.
  5. Download or copy the CSV output.
  6. Open the file in your spreadsheet application and verify that columns line up and special values (commas inside text, for example) stayed in their cells.

A Worked Example: Product Records to Spreadsheet Rows

Take this small inventory export:

[{"name":"Desk Lamp","price":34.5,"stock":120},{"name":"Notebook, A5","price":6.99,"stock":850},{"name":"USB Cable","price":9.25,"stock":430}]

Converted, it becomes four lines of CSV — a header plus three data rows:

name,price,stock
"Desk Lamp",34.5,120
"Notebook, A5",6.99,850
"USB Cable",9.25,430

Notice the second product: its name contains a comma, so the whole value is wrapped in double quotes. Without that quoting, a spreadsheet would split "Notebook" and " A5" into two cells and shift every value after it into the wrong column. This tiny detail is the main thing a converter does for you — hand-writing CSV around real-world text is where spreadsheets silently corrupt data.

Everyday Reasons to Turn JSON into CSV

Business users export API data — orders from a shop platform, leads from a CRM, submissions from a form service — into spreadsheets for reporting and sharing with colleagues who do not read JSON. Analysts convert logs and sensor exports as a first step before filtering and charting. Developers generate quick CSV fixtures for testing imports. Anyone migrating between systems uses CSV as the neutral middle format almost every platform accepts. If your data flows the other way — a spreadsheet that needs to become structured data — the reverse is covered by the CSV to JSON converter.

Limitations and Mistakes to Watch For

CSV has no concept of data types: everything is text, so a spreadsheet may reinterpret values — turning "00123" into 123, or a long identifier into scientific notation. Check ID-like columns after opening the file. Nested arrays are the other hard limit; a field holding a list cannot occupy one cell gracefully, and different converters flatten or drop such fields differently, so inspect records that contain them. Inconsistent keys across records also matter: if only some objects have a "discount" field, expect a mostly empty column. Finally, mind encoding — save and open the file as UTF-8 so accented names and currency symbols survive; a quick look in the JSON Viewer before converting helps you confirm the source structure is what you think it is.

Frequently Asked Questions About Converting JSON to CSV

What JSON shape converts to CSV most cleanly?

An array of flat objects with consistent keys. That maps directly to a header row plus one row per object. Single objects convert to a two-line file, and deeply nested data needs flattening decisions first.

What happens to nested objects inside my records?

They cannot live in a single CSV cell as a structure. Depending on the data, they are flattened into dotted or underscored columns, or omitted. Check the preview for any record that contains an object or array value.

Why is one of my values wrapped in quotes?

Because it contains a comma, a double quote, or a line break. CSV rules require such values to be quoted so they stay in one cell; spreadsheet applications understand this automatically.

Can I open the result in Excel?

Yes. CSV is Excel's native interchange format, and the same file opens in Google Sheets, LibreOffice Calc, and most database import tools.

Will numbers stay numbers?

The CSV preserves their text form; how a spreadsheet displays them is the application's choice. Values with leading zeros or very long digit strings may be reformatted on open, so verify identifier columns.

What if my JSON is a single object instead of an array?

It converts to a header row plus one data row. If you expected many rows, your records are probably nested inside a wrapper key such as "data" or "results" — extract that inner array first.

How is this different from converting to TSV?

The structure is identical; only the separator changes — commas for CSV, tabs for TSV. TSV is often safer when your text values contain many commas; the JSON to TSV converter produces that variant.

From API Data to a Working Spreadsheet

Most data eventually has to be looked at by a person, and people look at tables. Converting JSON to CSV is the small, reliable step that moves application data into the spreadsheet world without hand-copying or fragile manual edits. Prepare a clean array of records, convert, and open — your data is ready to sort, filter, and share.