Xoricon Toolbox LogoXoricon

JSON to CSV

Convert JSON files or pasted JSON text to CSV directly in the browser.

CSV settings

Delimiter

Input

Private by design: your file never leaves your device.

Output

Paste valid JSON to see the CSV preview.

Paste valid JSON to see the CSV preview.

Good to know

The JSON to CSV converter converts JSON arrays into CSV directly in your browser, with a data source selector that determines which array in the JSON serves as the row source. Nested objects can be flattened into columns like address.city, and arrays with simple values can be joined into a single cell instead of being stored as JSON.

Typical searches include JSON to CSV, CSV from API response, and Excel JSON CSV. A formula-protection option prepends an apostrophe to dangerous cell values so spreadsheet programs don't execute injected formulas — an important defense against CSV injection. CRLF line endings and a UTF-8 BOM can be enabled for spreadsheet compatibility.

Typical use cases

Export an API response for a spreadsheet

Choose the relevant array from a nested API response as the data source to export it directly as CSV for Excel or Google Sheets.

Export user data with safe formatting against CSV injection

Enable formula protection when cell values might come from user input, to prevent unintended formula execution in Excel.

Tips for better results

Enable formula protection for externally sourced data

If JSON values come from untrusted sources, formula protection prevents spreadsheet programs from executing injected formulas.

Use UTF-8 BOM for special characters in Excel

Enable the UTF-8 BOM if umlauts or other special characters display incorrectly when opening the CSV file in Excel.

How it works

Step by step

  1. 1

    Paste JSON or open a file

    Paste JSON or open a JSON file up to 200 MB.

  2. 2

    Choose the data source and CSV options

    Choose the source array, delimiter, flattening options, and formula protection.

  3. 3

    Copy or download the CSV

    Copy the generated CSV or download it as a file.

Features

Formula protection against CSV injection

Prepends an apostrophe to dangerous cell values so spreadsheet programs don't execute formulas.

Flatten objects and join arrays

Nested objects become columns like address.city, primitive arrays can be joined into a single cell.

Data source selection

Deliberately choose which array in the JSON serves as the row source for the CSV.

Frequently asked questions

What is formula protection?

It prepends dangerous cell values such as =SUM(...) with an apostrophe so spreadsheet programs don't execute them as a formula.

Is my file uploaded?

No. Conversion runs entirely locally in the browser.

More tools

CSV to JSON

Convert CSV, TSV files, or pasted table data to JSON directly in the browser.

JSON Formatter

Validate, format, minify, analyze, and inspect JSON as a tree locally.

JSON to YAML

Convert JSON files or pasted JSON text to YAML directly in the browser.

JSON to XML

Convert JSON files or pasted JSON text to XML directly in the browser.