Private developer tools

JSON ↔ CSV Converter

Convert arrays of JSON objects into correctly escaped CSV, or parse quoted CSV records into clean JSON without uploading the data.

Input

JSON array

184 chars

Output

CSV result

0 chars

Choose options, then convert.

How to use it

Get a reliable result

  1. Choose JSON to CSV or CSV to JSON and paste the source records.
  2. Select the delimiter and relevant header, type-inference, or spreadsheet-protection options.
  3. Convert the data, review the row and column counts, then copy, download, or move the result into the opposite converter.

Useful for

Common workflows

  • Prepare API records for a spreadsheet
  • Turn exported table rows into JSON fixtures
  • Convert comma-, semicolon-, or tab-delimited datasets

Examples

What to expect

Quoted CSV fields
Input
A JSON record containing Hopper, Grace and a multiline note
Output
CSV fields wrapped in quotes with embedded quotes doubled

Commas, quotes, carriage returns, and newlines are escaped according to CSV conventions.

Typed JSON records
Input
CSV values true, 42, and null with type inference enabled
Output
JSON boolean, number, and null values instead of strings

Know before you start

Important limitations

  • CSV has no universal schema or type system; values remain strings unless optional primitive inference is enabled, and empty strings stay empty strings.
  • Nested JSON arrays and objects are serialized into cell text and are not reconstructed automatically during CSV-to-JSON conversion.
  • Spreadsheet-formula protection intentionally prefixes risky string cells with an apostrophe and therefore changes those values.
  • Duplicate or empty headers and rows with more fields than available columns are rejected instead of being guessed.
  • Input is limited to 1,000,000 characters, 10,000 data rows, and 200 columns to keep browser processing responsive.

Keep exploring

More developer tools

JSON FormatterValidate, beautify, sort, inspect, minify, copy, and download JSON locally.Open JSON Formatter →YAML ↔ JSON ConverterConvert YAML to formatted JSON or JSON to readable YAML with validation.Open YAML ↔ JSON Converter →Text Diff CheckerCompare two text versions with line and word highlights, then copy or download the diff.Open Text Diff Checker →

Common questions

JSON ↔ CSV Converter FAQ

Does the parser support commas and newlines inside fields?

Yes. Properly quoted fields can contain delimiters, escaped double quotes, carriage returns, and line breaks.

How are nested JSON values represented in CSV?

Arrays and objects are serialized as compact JSON text inside one CSV cell. CSV-to-JSON does not automatically rebuild those nested structures.

What does spreadsheet-formula protection do?

For JSON string values beginning with =, +, -, @, a tab, or a carriage return, it prefixes an apostrophe so common spreadsheet applications treat the cell as text. Disable it when exact string preservation matters more than spreadsheet safety.

Is converted data uploaded?

No. Parsing, formatting, copying, and file creation happen locally in the current browser tab.

Browser-local

Processed on your device

JSON, CSV, and converted results stay in this browser and are never uploaded or stored.

How this processing works

The tool reads and processes this input in your browser. Tool Packer's application server does not receive the input or generated result.

Read the full privacy explanation