JSON naar CSV Converter

Overview

Turn a JSON file into a CSV. Each object in an array becomes a row and its properties become columns, and arrays of arrays work too. Pick a comma, semicolon, tab or pipe to suit your spreadsheet or database, and check the preview before you download. It runs in your browser, so your data stays on your computer.

API responses to spreadsheetsTurn a JSON response from a REST API into a CSV you can look through in Excel or Google Sheets.
Database importsMake a CSV from a JSON export that you can bulk-import into a SQL database or data warehouse.
Semicolon regionsSwitch to semicolons where Excel expects them, so your columns don't break on import.
Confidential dataConvert confidential records without sending them to someone else's server.
Quick look at the dataSee how your JSON maps to rows and columns before you download anything.

Key features

Zet JSON om naar CSV
Arrays van objecten
Arrays van arrays
Komma, puntkomma, tab of pipe als scheidingsteken
Bekijk eerst een voorbeeld

Set

Document 20

Neighbours

01 Factuur Generator 02 CSV naar JSON Converter 03 CSV naar XLSX Converter 04 E-mailviewer en -editor 05 EML naar MSG-converter 06 EML-viewer

Specification

Command: document.json_to_csv
Set: Document
Input: JSON
Output: CSV
Max. bestand: 50MB
Batch: single file

Runtime

Engine: SheetJS · Intl.Segmenter
Threads: single
Isolated: —
WebGPU: —
Memory: —

Transport 0 B

Your file is opened, worked on and saved inside this tab. This tool has no upload step, so your file has nowhere else to go.

Keys

Zoeken: ⌘K
Panels: ⌘1 · ⌘2
Full width: F
All keys: ⌘/

How it works

Add your JSON

Drop a JSON file or pick one from your computer.

Pick a delimiter

Choose comma, semicolon, tab or pipe, and check how your data maps to rows and columns.

Download the CSV

Open it in a spreadsheet app or import it into a database.

Frequently asked

What JSON structures can I convert?

An array of objects, where each object becomes a row and its properties become columns. An array of arrays also works: each inner array becomes a row, and the first one is the header row.

How are nested JSON objects handled?

Each nested field gets its own column, with a dotted name: {"address": {"city": "Lisbon"}} becomes a column called address.city. A list, such as ["vip", "newsletter"], is kept as its JSON text in one cell.

Can I choose different CSV delimiters?

Yes. Pick comma (,), semicolon (;), tab or pipe (|) to match the program or region you're importing into.

How are different data types converted?

Numbers and strings come through as they are, and long numbers are written in full, not as 4.00638E+12. true and false become TRUE and FALSE, and null becomes an empty cell.

What happens with missing properties in objects?

If some objects lack a property, that cell is left empty, so the columns still line up.

Is there a file size limit?

Files can be up to 50 MB. For anything bigger, split the JSON into smaller parts first.

Keys

Zoeken: ⌘K
Panels: ⌘1 · ⌘2
Full width: F
All keys: ⌘/