Skip to content
Developer Tools

CSV ↔ JSON Converter

Convert CSV to JSON or JSON objects to CSV locally with validation and spreadsheet-safe output.

0 input characters

JSON output

0 output characters

Conversion runs locally in your browser. CSV values become JSON strings; arrays stay as JSON text in CSV cells.

Data handling

Storage and export controls

Retention
The tool's working state is kept only while this page is open. Inputs and results are not saved to persistent storage by Got A Tool.
Export
The tool may prepare a result after you run it. It downloads or copies it only when you choose that action.

Advertising and analytics are separate site services. We do not send selected tool input to them. Read the Privacy Policy for details.

How it works

Convert structured data in three steps

01

Choose a direction

Convert a headed CSV into JSON records or a JSON object array into CSV.

02

Paste and validate

Add your data and review clear errors before any output is produced.

03

Copy or download

Copy the converted text, download the correct file type, or reverse the conversion.

Predictable conversion

Preserve values without hiding ambiguous data.

Duplicate or empty CSV headers and mismatched rows are reported instead of silently overwriting values. JSON columns follow their first-seen order across every object.

Quoted CSV support

Handles commas, line breaks, quotes, Unicode text, and automatically detected delimiters.

Flexible JSON input

Accepts one object or an array of objects and builds a union of their property names.

Nested data controls

Keep objects and arrays as JSON text by default, or flatten nested objects into dot-notation columns.

Spreadsheet safety

Optional, enabled-by-default protection neutralizes cells that spreadsheet apps may interpret as formulas.

FAQ

Common questions

What JSON shape can be converted to CSV?

Use one JSON object or an array containing objects. Primitive array items are rejected because they cannot form named CSV columns without inventing a schema.

Are CSV numbers and booleans automatically typed?

No. CSV has no universal type metadata, so CSV values become JSON strings. This avoids changing identifiers, leading zeros, dates, or other values based on guesses.

What happens to nested JSON objects and arrays?

By default, nested objects and arrays are stored as JSON text in CSV cells. When you choose Flatten nested objects, objects use dot-notation columns such as user.address.city; arrays remain JSON text. Converting CSV back to JSON never guesses and rebuilds nesting.

Why is spreadsheet formula protection enabled?

Spreadsheet apps may execute cells beginning with certain characters as formulas. Protection prefixes those values with an apostrophe. Disable it only when exact formula-like text is required and you trust the data.

Is my data uploaded?

No. Parsing, validation, conversion, copying, and file creation happen locally in your browser.

Practical guide

Read the CSV and Excel safety guide

Check identifiers, spreadsheet formulas, and file structure before you open a reviewed CSV in a spreadsheet.

Open the guide →

Keep working