SuperSEOPlus

Development Tools

JSON to CSV and CSV to JSON Converter

Paste a JSON array of objects and get a CSV you can open in a spreadsheet, or paste CSV and get JSON. Nested objects become dotted columns such as address.city, rows with different keys are lined up under one combined header, and quoted fields with commas or line breaks are handled correctly. CSV input can use comma, semicolon, tab or pipe delimiters, detected automatically. Output cells that begin with = + - or @ are neutralised so a spreadsheet does not run them as formulas. Files up to about 20 MB are read in your browser; nothing is uploaded.

How to use it

  1. Choose the direction, then paste your data or open a .json or .csv file.
  2. Adjust the delimiter and the options for flattening, types and formula protection.
  3. Copy the result or download it as data.csv or data.json.

Example

[{"name":"Ann","city":{"town":"Leeds"}},{"name":"Bo"}] becomes a CSV with the columns name and city.town, and the second row leaves city.town empty.

When CSV goes wrong

  • Dates and ID numbers: spreadsheets may reformat 00123 or 2026-01-02 when opening a CSV. Import the column as text.
  • Character encoding: the download includes a byte-order mark so Excel reads accented characters correctly.
  • Inconsistent records: keys missing from some objects leave empty cells, never shift values.

Which tool fits your task?

This page is for converting between JSON and CSV.

  • JSON Viewer: for validating and formatting JSON, not converting between JSON and CSV.
  • XML Formatter and Validator: for checking and indenting XML, not converting between JSON and CSV.
  • SQL Formatter: for tidying SQL queries, not converting between JSON and CSV.
  • CSV Viewer and Cleaner: for sorting, filtering and cleaning a CSV file, not converting between JSON and CSV.

Questions

How are nested objects and arrays handled?

Nested objects become columns with dotted names. Arrays of simple values are joined into one cell with semicolons, and arrays of objects are expanded into numbered columns. Anything else is written as JSON text.

Why does a cell start with an apostrophe?

Spreadsheets can run text that starts with = + - or @ as a formula. That is a known attack on CSV downloads, so such cells are prefixed with an apostrophe. Turn the protection off if you need the raw text.

Can it read semicolon-separated CSV from Excel?

Yes. Leave the delimiter on auto-detect, or choose semicolon. Many European Excel versions save CSV with semicolons.

Does it guess data types?

Only if you ask. With “Convert numbers, true/false, null” on, values such as 42, 3.5 and true become JSON numbers and booleans. Otherwise every value stays a string, so leading zeros are never lost.

Is there a size limit?

Text up to 20 million characters and 500,000 rows. Larger files should be split.

Get practical SEO tips by email

Occasional emails with new guides and tools. Confirm by email first; unsubscribe in one click.