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.jsongives newline-delimited documents (.ndjson-style).- Add
--jsonArrayto 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
usersordata(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
- JSON to Excel
- NDJSON / JSONL to Excel
- Nested JSON to Excel
- Postman JSON to Excel
- API Response to Excel
- JSON to CSV vs Excel
- JSON Array to Excel
See all guides or the FAQ.