CODEWITHSUNDEEP
excelfirebasefirebase-realtime-database
Cycl0n3
Cycl0n3

Reputation: 697

How I export my Firebase data in Excel Sheet

I want my Firebase database in Excel sheets. I have all these children: Names, Branch, Batch, College as attributes of all users. I want to export these in Excel Sheets.

Here's an example of items in the database:

Firebase Database

And this is how I want the Excel Sheet to look:

Excel Sheet

Upvotes: 18

Views: 45359

Answers (4)

iqfareez
iqfareez

Reputation: 887

All the answers here are mentioning online converter tools. You can also use Excel's built-in data importer. I found it useful when I have to export it in a excel table.

Say I have the following data: enter image description here

Similar like other answers, click the triple dot > Export JSON..

Then, open Excel. Go to Data > Get Data > From File... > From JSON

Import JSON

Then, click on Into Table

Into table

Click, Close and Load

CLose & load

Result:

Result excel

Upvotes: 0

Rajitha Fernando
Rajitha Fernando

Reputation: 1865

I would like to explain more Since its unclear to some people. Step 1. Select Realtime Database (You won't find any download button in Cloud Firestore). for that, Select Database > Realtime Database enter image description here

Step 2. In there, you'll find a three-dotted button in the right top corner. Select your option (Import/ Export)

enter image description here

Upvotes: 3

Arjan Poudel
Arjan Poudel

Reputation: 11

In the firebase database, you can see export to JSON file, When you export it download it and then use an online converter to change to excel file.

Upvotes: 1

tingyik90
tingyik90

Reputation: 1711

Export your firebase to JSON. Just click the settings on the right of your database.

enter image description here

Then, convert the JSON to CSV. There are a lot of csv converter online. You can try https://json-csv.com/. Save the csv and open with Excel.

Upvotes: 40

Related Questions