Free · No signup · Browser-based

Convert JSON to Excel.

Drop a JSON file and get a real .xlsx workbook with typed cells — numbers stay numeric and dates stay dates. Nested objects and arrays are flattened into dot-notation columns — every value kept, structure not. Runs in your browser.

To convert JSON to Excel, drop or paste a JSON file — csvtodashboard parses it into rows and columns in your browser, then emits a real .xlsx workbook with typed cells. You get a real .xlsx workbook with typed cells, so Excel won't turn your numbers or dates into text on open. Nothing is uploaded; the whole conversion runs on your device.

01 · How it works

Three steps, then done.

This reads your JSON — an array of objects becomes rows, then writes a real .xlsx workbook with typed cells — numbers stay numeric and dates stay dates. Because Excel is a flat, tabular format, nested objects and arrays in your JSON are flattened into dot-notation columns (e.g. user.address.city) — that keeps every value but does not preserve the hierarchy, so the conversion is one-way. Everything runs locally in your browser.

i. drop

Drop or paste

Drag a file, click to choose, or paste data directly into the input pane.

ii. detect

We read the shape

Types are inferred so the output is correctly formatted — not strings everywhere.

iii. use it

Copy, download, or dashboard

Copy the output, download it, or hit 'Build dashboard' to chart what's in the data.

02 · Why ours

Smart Excel conversion by default.

Free Excel converters often produce sloppy output — every value quoted, types lost, errors swallowed. Ours infers types where it can, fails loudly when it can't, and pairs the conversion with a one-click path to a dashboard.

  • 01

    Correct types

    Numbers, booleans and nulls are preserved wherever Excel supports them — not every value dumped as a quoted string.

  • 02

    Local-first

    Your file is parsed and converted in your browser — verify in DevTools → Network. Nothing is uploaded, logged, or stored.

  • 03

    Fails loudly

    Malformed input gives a clear, specific error instead of silently wrong output — so you can trust what comes back.

  • 04

    One click to a dashboard

    Every conversion keeps a tabular copy, so you can send the data straight to our visualization tool to chart it.

"Needed a conversion. Ended up with a dashboard. That's the pattern."
— the typical csvtodashboard arc
Good to know

json to excel notes.

Format-specific details worth knowing before you convert JSON to Excel.

  • Nesting is flattened, not kept

    JSON can nest objects and arrays; converting to Excel flattens them into dot-notation columns. Every value is preserved, but the hierarchy is not — it is a one-way conversion.

  • A real .xlsx, not a renamed CSV

    The output is an OOXML workbook with typed cells, so Excel opens it directly without the import-wizard guesswork a raw CSV triggers.

  • Leading zeros and long IDs

    Excel strips leading zeros and shows long numbers in scientific notation; keep ZIP codes and identifiers as text columns to avoid that.

  • One sheet, literal values

    Each file is a single sheet of literal values — no formulas are generated, so what you open is exactly the data you converted.

03 · FAQ

json to excel questions.

What JSON input works?
Any JSON that is an array of objects (the most common data shape); a single object becomes one row. Deeply nested JSON works too — it is flattened with dot notation.
Nested objects and arrays are flattened into columns using dot notation (user.name, user.address.city). Arrays of scalars are joined; arrays of objects are JSON-stringified into a single cell. Your data is preserved, but the nested structure is not — this is a one-way conversion.
A real .xlsx workbook (not a CSV renamed) with typed cells, so Excel doesn't turn your numbers or dates into text.
No. The whole json-to-excel conversion happens locally in your browser — the file never touches a server.
Related tools
JSON to CSV
Just need rows? Take JSON straight to CSV.
Open →
CSV to Excel
Already have a CSV? Convert it to Excel.
Open →
CSV Pipeline
Clean or reshape the flattened data.
Open →
Dashboard Builder
Skip the export — visualize the data directly.
Open →