JSON & CSV · BROWSER TOOLS

JSON · CSV Converter
Make spreadsheet data easier

Convert JSON to CSV or CSV to JSON and preview the structure. Your input data stays in your browser.

JSON ↔ CSVQuotes and line breaksUTF-8 file support

Conversion directionCSV delimiter

JSON array path (optional)

Select the array to convert in an API response. This path syntax does not support keys containing dots.

Flatten nested objects into columns (address.city) Include UTF-8 BOM in CSV downloads Protect against spreadsheet formula prefixes

Formula protection adds an apostrophe before strings starting with characters such as =, +, - or @. Negative numeric values remain unchanged.

Paste text or open a file.

Copy the output or download it as a file.

Ready to convert.

Data preview

Showing up to 20 rows and 20 columns. Download the file for the full result.

Convert to preview column names and data.

Practical conversion examples

Product code 00123, notes containing commas and nested addresses need different checks. Our guide covers leading zeros, duplicate headers, UTF-8 text and array paths.

JSON & CSV guide: leading zeros, nested values and UTF-8 →

JSON → CSV

Convert an object or an array of objects into a table. Columns include keys from every row. Nested objects and arrays are JSON strings by default. Enable flattening to create columns such as address.city.

CSV → JSON

The first row contains column names. Quoted delimiters and multiline text are supported. Values remain strings to preserve leading zeros in codes and postal codes.

Your data stays in your browser

Files are not uploaded to a server. Input is limited to 5 MB. Format or minify JSON to adjust its whitespace.

Before you convert

How is nested JSON converted?

Objects and arrays are stored as JSON strings by default. Flattening converts nested objects to dot-separated columns; arrays remain strings. Without flattening, a profile object stays in the profile column. Converting CSV back to JSON does not automatically restore nested objects.

Are CSV numbers and dates converted automatically?

CSV to JSON keeps all values as strings to avoid changing 00123, long identifiers or dates. Duplicate or blank headers and rows with a different number of columns produce errors.

What if non-English text looks wrong in Excel?

Download CSV with UTF-8 BOM enabled. You may also need to use Excel’s data import and select UTF-8 with the correct delimiter.

What do formatting and minifying change?

Formatting uses two-space indentation; minifying removes unnecessary whitespace. JavaScript parsing and serialization rules apply, including key ordering and numeric precision. Enter very large integers as strings. For duplicate keys, JSON.parse keeps the last value.