Tools Viewer

JSON to CSV

What Is a JSON to CSV Converter?

A JSON to CSV converter turns JSON data into rows and columns you can open in Excel, Google Sheets, or import into a database. It works best with an array of objects, where each object becomes a row and each key becomes a column.

ToolsViewer's online JSON to CSV tool is a file workspace. You can convert one or several JSON files at a time, adjust the CSV options, preview the result, and download it.

How to Use the JSON to CSV Converter

Step 1: Add your files
Drop or import one or more .json files. You can also bring in content from another tool using Send. Set your options before converting if you need to.

Step 2: Choose your CSV options
Pick the delimiter, line ending, how to handle empty values and arrays, how to flatten nested objects, and whether to include a header row.

Step 3: Click Convert
The tool converts your files and shows a CSV preview. If you change an option, use Rebuild to update the result.

Step 4: Download or send
Download the CSV, or send it to a tool like CSV to JSONL.

JSON to CSV Features

  • Arrays of objects become rows
  • An object that wraps an array uses that array
  • A single object becomes one row
  • Delimiter: comma, semicolon, tab, or pipe
  • Line endings: LF or CRLF
  • Empty and missing values: leave empty, write null, or write N/A
  • Arrays: keep as JSON or join with |
  • Flatten nested objects using . or _
  • Include or skip the header row
  • Quote every field
  • UTF-8 BOM option for Excel
  • Skip empty rows
  • Batch convert and Rebuild
  • Download and Send to other tools
  • Private processing in your browser

Common Uses

Open API data in Excel or Google Sheets: Turn JSON responses into a spreadsheet.

Convert several files at once: Process a batch of JSON files in one go.

Prepare data for import: Choose the delimiter and quoting your target system expects.

Share data with non-developers: Give teammates a format they already know.

Fix Excel character issues: Add the UTF-8 BOM so special characters display correctly.

Supported Formats

  • .json files
  • JSON text sent from other tools
  • Output as .csv

Deeply irregular nesting is flattened or converted to text, so check the output before relying on it in a spreadsheet.

Explore related tools like JSON Validator, JSON to YAML and JSON Path Tester to validate, query, and convert data online.