JSON to CSV Converter

Turn API responses and JSON exports into a spreadsheet-ready CSV. Columns are the union of all keys in the order they first appear, nested objects can be flattened into columns like address.city, and arrays are joined into a single cell. Values are quoted correctly so commas, quotes and line breaks never break the file.

How to use the JSON to CSV Converter

1. Paste a JSON array or open a .json file.
2. Choose a delimiter and how array values should be joined.
3. Turn flattening, the header row and the UTF-8 BOM on or off.
4. Check the table preview.
5. Copy the CSV or download it.

Features

• Header built from the union of keys across all records
• Dot-notation flattening of nested objects
• Arrays of simple values joined with your separator
• Correct RFC 4180 quoting for commas, quotes and newlines
• Optional UTF-8 BOM and CRLF line endings for Excel
• Accepts arrays of objects, arrays of arrays or a wrapped data array

Benefits

• Open JSON data in Excel, Google Sheets or Numbers
• Share API results with people who do not read JSON
• Conversion runs locally with no upload

Frequently asked questions

What does the UTF-8 BOM do?

It is an invisible marker at the start of the file that tells Excel the file is UTF-8, so accented and non-Latin characters display correctly.

How are nested arrays of objects handled?

Arrays that contain objects are written as JSON text in a single cell, so no data is lost.

What JSON shapes are accepted?

An array of objects, an array of arrays, a single object, or an object with one array property such as {"data": [...]}.

Related tools

• Data Storage Converter — Convert bits, bytes, KB, MB, GB, TB and PB, plus binary KiB, MiB, GiB and TiB, with 1000 vs 1024 clearly labelled.
• Image Metadata Viewer — View EXIF, GPS, XMP and IPTC metadata in photos: camera, lens, exposure, date and location, then export or remove it.
• CSV to JSON Converter — Convert CSV to JSON with full RFC 4180 support, delimiter auto-detection, header rows and optional number and boolean detection.
• Percentage Calculator — Work out X% of Y, what percent one number is of another, percentage change, or increase and decrease a value by a percent.
• Loan EMI Calculator — Calculate the monthly EMI for any loan, plus total interest, total payment and a year-by-year repayment breakdown.
• Invoice Generator — Create a professional invoice with your details, line items, discounts, tax and shipping, then download it as a PDF or print it.