Skip to content
Developer Tools

JSON ↔ CSV

Convert JSON records to CSV, or CSV rows to JSON, with explicit choices for types and spreadsheet handling.

Data & privacy
Free to use
No signup
Processes in your browser · How your data is handled

This tool processes input in your browser. Site analytics and advertising are separate from tool processing; see the privacy policy.

Text CSV converts all fields to strings. Nulls and missing values become empty cells; spreadsheet protection can add an apostrophe. All JSON input rejects duplicate keys and unsafe numbers; maximum 1,000,000 characters and 64 levels.

About the JSON ↔ CSV

Convert JSON records to CSV, or CSV rows to JSON, with explicit choices for types and spreadsheet handling.

How to use this tool

Paste input or import a text file, select the options that match your data, and run the tool. Review the result before copying, downloading, or transferring it to another local tool.

What this tool will not do

  • Text mode reads all CSV values as strings. JSON null and missing fields become empty text cells; nested values require JSON-cell mode.
  • JSON-cell mode encodes headers and values as JSON. Empty cells represent missing properties; null, strings, booleans, numbers, and nesting remain distinct. Use matching mode on import. Spreadsheet applications may still reinterpret numeric cells.
  • Spreadsheet protection prefixes risky text cells with an apostrophe. This changes their text and is not removed on import. Disabling it can let spreadsheet applications evaluate formula-like cells.
  • Supports comma, semicolon, and tab separators, quoted delimiters, escaped quotes, and multiline cells. Maximum 10,000 records and 200 columns.