OpenGPT.in

JSON to CSV

Turn JSON into a spreadsheet-ready CSV file.

Runs in your browser Runs entirely in your browser. Nothing you put in it ever leaves your device.

Paste JSON, or drop a .json file here. Converts as you type.

Ready. Everything runs in this page.

Preview

Paste some JSON to see a preview.

Was this useful?

About this tool

Give it an array of objects and it produces a CSV file you can open in Excel, Numbers or Google Sheets. Nested objects become dotted columns, and lists of simple values are joined into a single cell.

How to use it

  1. Paste your JSON, or drop a .json file onto the editor.
  2. Pick a delimiter and decide whether to flatten nested objects.
  3. Review the preview table.
  4. Copy the CSV or download it as a .csv file.

Supported input

  • Array of objects
  • Single object (one row)
  • Array of values (one column)

Privacy

Runs entirely in your browser. Nothing you put in it ever leaves your device. Everything happens in JavaScript on this page, so the tool keeps working even if you go offline after it has loaded — which is the simplest way to see for yourself that nothing is being sent. Read the full privacy information.

Questions

How are nested objects handled?

With flattening on, `{"user":{"name":"Asha"}}` becomes a column called `user.name`. With flattening off, the nested value is written into one cell as JSON so nothing is lost.

What happens to arrays inside my objects?

An array of simple values becomes one cell with the values joined by a semicolon. An array of objects becomes indexed columns such as `items.0.sku` so every field keeps its own column.

Will it work with Excel?

Yes. The output follows RFC 4180 with CRLF line endings, and cells starting with =, +, - or @ are prefixed with an apostrophe so spreadsheets do not treat them as formulas.

Is my data uploaded?

No. The conversion runs in your browser and nothing is sent to our server.

Related tools