04In the browser

JSON ⇄ CSV

Go either way. Nested fields become columns, and you download the file.

Direction
JSONCSV
3 rows

5 columns.

Everything runs in your browser. Load this page, disconnect from the network, and it still works — which is the point when the data belongs to a client.

⊕Why a tool

What the chat window cannot finish.

A converter that handles the cases the quick ones do not: nested objects and arrays flattened to dotted columns, inconsistent keys unioned rather than dropped, commas and quotes escaped properly, and a real file at the end.

For twenty rows, an assistant is genuinely faster and you should use it. For four thousand rows it will not fit, and if it does it may silently drop or invent records — which is the worst possible failure mode for data you are about to act on.

There is also the file. Chat gives you text in a scroll box. This gives you a .csv you can open in Excel, and it does the conversion locally, so client data under NDA never crosses a network.

⊕Reference

Conversion rules

Nested objects
Flattened to dotted keys — `user.address.city`
Arrays of scalars
Indexed columns — `tags.0`, `tags.1`
Inconsistent keys
Union of all keys; missing values left empty
Escaping
RFC 4180 — quotes doubled, fields with , " or newline quoted
Type coercion
CSV → JSON infers number, boolean and null; everything else stays a string
Encoding
UTF-8, with an optional BOM for Excel

These constants are published under CC BY 4.0. Quote them, cite them, put them in your own documentation. Attribution to Original Design Studio is the only condition.

⊕Governed by

The principles behind what this tool tells you.

⊕Questions
How do I convert nested JSON to CSV?

Paste it and the converter flattens nested objects to dotted column names automatically — `user.address.city` becomes a column. Arrays of scalars become indexed columns.

Is there a file size limit?

Only your browser's memory. Files in the low tens of megabytes convert fine; conversion runs on your machine, so speed depends on your machine.

Does my data get uploaded?

No. Everything runs in the browser. You can load this page, disconnect from the network, and it will still work.

Why does Excel mangle my accented characters?

Excel assumes the system codepage rather than UTF-8 unless the file carries a byte-order mark. Tick 'BOM for Excel' before downloading.

Next tool

Colour Vision Simulator

05
Apply it

Want this run across your whole product?

A written plan against the ten disciplines.