ToolzyLab ToolzyLab

JSON ↔ CSV Converter

Convert JSON objects into CSV or transform CSV back into JSON instantly in your browser. Fully offline, privacy friendly, fast, and built with a clean side-by-side workspace so large data stays easy to use on desktop and mobile.

Developer-Friendly Data Conversion

Perfect for APIs, spreadsheets, exports, dashboards, ETL prep, debugging, admin tools, content migration, and data cleanup. Paste JSON arrays or CSV tables, auto-detect the format, flatten nested objects, and export clean results without uploading anything.

🔁 JSON → CSV 🔄 CSV → JSON 🧠 Auto Detect 🪄 Flatten Nested JSON 📑 Custom Delimiter 🔒 Browser Only
📊

Drop a JSON or CSV file here

Paste text below or upload a file to convert it instantly.

📄 .json .csv .txt · ⚡ instant conversion · 📥 download result · 🧾 headers supported · 🔒 no upload

Conversion Controls

Choose auto detect or force a direction, then control delimiter, header row, nested object flattening, and output formatting.

🟡 Waiting for input
Ready. Paste JSON or CSV, or choose a file to begin.
StatusWaiting
Detected Input
DirectionAuto
Input Size0
Output Size0
Rows / Items0

Input & Converted Output

Paste raw JSON or CSV on the left. The right side shows the converted result inside a compact, scrollable output pane.

No action yet Line 1, Col 1

Input

Editable 0 chars
1
Ready for input No file loaded
Detection idle

Output

Result preview 0 chars
1
No output yet Ready to download
Type idle

Input Analysis

Inspect detected format, delimiter, header state, row count, key count, and a compact structural preview before converting.

Run the tool or click Analyze Input to inspect the current content here.

Best practice

Use a JSON array of objects for the cleanest JSON → CSV conversion. For CSV → JSON, keep the first row as headers when possible so the result gets meaningful field names.

This tool runs fully inside your browser. Nothing gets uploaded, stored on our servers, or sent anywhere.

Result Snapshot

See quick stats about the current output including direction, estimated row count, detected delimiter, and overall size.

Snapshot idle
Detected Input
Delimiter
Header Row
Rows / Items0
Keys / Columns0
Output Size0 B

Keyboard shortcuts

  • Ctrl + Enter convert data
  • Ctrl + K analyze input
  • Tab stays natural inside the editor

What this tool does

It can detect whether your input is JSON or CSV, convert between both formats, flatten nested JSON keys, keep big workspaces compact with scrolling, and help you export developer-friendly output fast.

Structured records and tabular exchange

Convert JSON and CSV by defining records, headers, delimiters, nested values, and type expectations

JSON can represent nested objects and typed values; CSV represents rows and fields with conventions that vary by producer. Choose conversion direction, delimiter, header handling, JSON indentation, and nested-value flattening, then inspect quoting, missing columns, arrays, numbers, booleans, nulls, and spreadsheet behavior before import.

Record shape

A JSON array of similar objects maps most cleanly to a table

Each object can become a row and the union of keys can become columns. Nested objects and arrays need flattening, JSON-string encoding, or a separate relational design. Missing properties and explicit null are not always equivalent to an empty CSV field, so define how the receiving system distinguishes them.

CSV rules

Delimiter selection does not remove the need for correct quoting

Fields containing the delimiter, quotes, or line breaks must be quoted and embedded quotes escaped. Comma, semicolon, and tab choices depend on locale and destination. A header row improves mapping, but duplicate or blank headers should be corrected before conversion.

Types and spreadsheets

CSV fields are text until an importer infers dates, numbers, or formulas

Leading zeros, long identifiers, dates, scientific notation, and values beginning with equals, plus, minus, or at-sign can be changed or executed by spreadsheet software. Review sensitive exports and use a controlled import schema when exact types or untrusted data matter.

Practical review

JSON and CSV conversion check

Open the result in the real destination with a small edge-case dataset first.

  • Confirm the JSON root and record shape match the selected direction.
  • Review delimiter, header row, quoting, embedded line breaks, and duplicate headers.
  • Define treatment for nested objects, arrays, missing fields, null, and empty strings.
  • Protect leading zeros, long identifiers, dates, and spreadsheet-formula-like values.
  • Compare row and column counts plus representative records after import.

Technical references: RFC 4180 CSV format RFC 8259 JSON specification

JSON and CSV questions

Record arrays, nested data, delimiters, quotes, null values, and spreadsheet types

What JSON shape converts best to CSV?

An array of objects with consistent keys maps naturally to rows and columns. A single object, nested records, or arrays inside fields need an explicit flattening choice.

How are nested JSON objects represented in CSV?

Flattening can create path-like column names, while another approach stores nested values as JSON text. Neither is universally correct; match the receiving system.

Why are commas inside CSV fields not splitting correctly?

Fields containing the delimiter must be enclosed in quotes, and embedded quotes must be escaped according to CSV rules. Verify the selected delimiter.

What is the difference between null and an empty CSV cell?

JSON null is an explicit value, while a missing property and an empty string are distinct. CSV has no universal native representation for those differences.

Why did a spreadsheet change IDs or dates after opening the CSV?

Spreadsheet software infers field types and may remove leading zeros, convert dates, or use scientific notation. Import with explicit column types when precision matters.

Can CSV values create spreadsheet security problems?

Untrusted fields beginning with formula characters may be interpreted as formulas by spreadsheet apps. Follow the destination's CSV-injection mitigation policy.