ToolJovia
Developer

JSON to CSV

Convert a JSON array of objects into a quoted CSV table with spreadsheet formula protection.

✓ Browser-local processing

Loading tool…

How to use JSON to CSV

Create a CSV table from record-style JSON. Columns are collected from all objects, missing values become blank cells, and nested data stays as JSON in a cell.

  1. Paste a non-empty JSON array of objects.
  2. Convert the records into a CSV table.
  3. Download the CSV and import it into your spreadsheet application.

Good to know

  • Up to 5,000 records and 200 columns, within the JSON input limit.
  • Nested objects and arrays are serialized in a single cell; they are not flattened.
  • Cells beginning with formula-like prefixes receive a leading apostrophe for spreadsheet safety. Null and missing values both become blank cells.

Common questions

Why is there an apostrophe before some values?

It prevents spreadsheet software from treating a value such as =SUM(A1) as a formula. Import behavior varies, so review the data after importing.

How are columns ordered?

Columns follow their first appearance across the input records.

Keep going with related tools

All developer →
Developer

JSON Formatter

Format and indent valid JSON in your browser, with downloadable output and clear syntax errors.

Developer

JSON to XML

Convert JSON into escaped, typed XML while preserving arbitrary object keys and array ordering.

Data

JSON Parent and Child Array Unnester

Create a relational CSV from one explicit child array while retaining parent/child record provenance.

Data

JSON Flattener

Flatten nested JSON into a JSON Pointer map of leaf values without ambiguous dotted keys.

Data

Embedded JSON Field Extractor

Append scalar JSON Pointer fields from JSON text stored in CSV records while preserving numeric source spellings.

Text

CSL Citation Metadata Review

Review a clearly limited CSL JSON metadata profile and list unassessed fields without inventing bibliographic facts.