Data Tools

JSON to CSV

Feedback

Preview JSON records, choose columns, and export CSV or TSV on your device

Your data stays in your browserFiles and pasted text are processed on your device. Page resources must load before use; no conversion service receives your data.

UTF-8 text up to 2 MiB · 10,000 data rows · 100 columns · 100,000 cells.

Results appear after conversion. Copy and download use the complete result. Output limit: 8 MiB.

Data is processed on your device. JSON numbers must stay within the supported safe range; put long identifiers in quoted strings. Ordinary decimal numbers use standard floating-point precision.

How to use JSON to CSV

  1. Add JSON records

    Paste or open a UTF-8 JSON array of objects. Quote long numeric identifiers so they are treated as text.

  2. Choose the output

    Convert and review the available fields. Select and order columns, choose a delimiter, and decide how formula-like text should be exported.

  3. Review and export

    Check the table preview and conversion notices, then copy or download the CSV or TSV result.

reference

About JSON to CSV

Convert a JSON array of objects into a delimited table. Fields are collected across the records in first-seen order, and you can choose and reorder the output columns. Nested objects and arrays are serialized into individual cells rather than expanded into extra rows. Review the exported values and the handling of empty cells before copying or downloading. A spreadsheet-oriented export option treats formula-like text explicitly, while original-text export is available when exact cell text is needed.

Useful for

  • Prepare an API data export for a spreadsheet or another tabular import.
  • Choose a consistent set of columns from records with different optional fields.

Before you start

  • Input must be a JSON array of objects. Comments, trailing commas, scalar arrays, and automatic JSON repair are outside this tool.
  • Null, missing fields, and empty strings become empty cells. CSV cannot preserve every JSON type or provide a lossless round trip.
  • Nested objects and arrays are stored as JSON text within a cell. Field flattening and array-to-row expansion are not included.
  • JSON numbers outside ±9007199254740991 and numbers that overflow or underflow are rejected before conversion. Store long identifiers as strings; ordinary decimals use standard floating-point precision.
  • Spreadsheet-oriented export may prefix formula-like text. The preview and notices show the effect; original-text export keeps the original cell text.

Frequently Asked Questions

What happens to nested objects and arrays?

Each nested value is serialized as JSON text in a single cell. It is not expanded into additional columns or rows.

Can I choose the columns?

Yes. The field list includes keys found across all records. Select the fields you need and arrange their output order.

Is conversion lossless?

No. CSV stores a table of text values, so null, missing values, and empty strings share an empty-cell representation. Converting back does not automatically restore the original JSON types.

Why are some numeric identifiers rejected?

JavaScript cannot represent every large integer exactly. The tool checks numeric input before conversion and asks you to quote unsafe identifiers rather than silently round them.

Continue with another tool

More Data Tools

All →

Try Our Browser Extension

Access essential tools instantly from your browser sidebar. Available for Chrome and Microsoft Edge.

Lightning fast
Privacy first
Search enabled