Export MongoDB & Firebase JSON to Excel

Last updated: 6 June 2026

Databases export JSON, but stakeholders want spreadsheets. Whether you're pulling a collection from MongoDB or a node from Firebase, you can turn that JSON dump into a clean Excel file in seconds - free, no signup, and processed in your browser so your data stays private.

Exporting from MongoDB

mongoexport produces either a JSON array or NDJSON (one document per line) - both are supported here. For example:

mongoexport --db shop --collection orders --out orders.json gives newline-delimited documents (.ndjson-style).
Add --jsonArray to get a single JSON array instead.

Drop the file in as-is. Mongo's extended-JSON IDs like { "$oid": "..." } flatten into a readable column (for example _id.$oid), and long numeric IDs are preserved exactly rather than rounded.

Exporting from Firebase

Firebase data comes in two shapes, and they behave differently:

A list of records under a key such as users or data (for example { "users": [ {...}, {...} ] }) - the converter detects the list and turns each record into a row.
An object keyed by document id (for example { "users": { "u1": {...}, "u2": {...} } }) - this is an object, not a list, so it flattens to a single wide row (users.u1.name, users.u2.name…). To get one row per document, first convert the keyed object into an array of records (in JavaScript, Object.values(obj.users)), then convert that array.

Nested documents → columns

Database documents nest deeply. By default, nested objects flatten into dotted columns (address.city), arrays of simple values become comma-separated cells, and arrays of sub-documents are kept as JSON text in one cell so each top-level document stays a single row.

Step-by-step

Export your collection/node as JSON or NDJSON.
Drop the file (up to 15 MB) or paste the JSON.
Preview the columns, then download the .xlsx.

Large collections

For exports over 15 MB, narrow the query (a date range or a projection of just the fields you need) before exporting, or split the collection into a few files and convert each. Filtering at the database keeps the spreadsheet fast and focused.

Related guides

See all guides or the FAQ.

Open the free JSON to Excel converter →