How do I export Firebase data to an Excel sheet

Question

I want my Firebase database in Excel worksheets. I have all these children: Names, Branch, Batch, Collegelike all user attributes. I want to export them to Excel Sheets.

Here is an example of items in a database:

And this is how I want Excel Excel to look like this:

Answer 1

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

Then convert JSON to CSV. There are many csv converters online. You can try https://json-csv.com/ . Save csv and open Excel.

Answer 2

Firebase JSON. , , - Excel.

Answer 3

I would like to explain more, as this is not clear to some people. Step 1. Select the Real-time Database (you will not find a single download button in Cloud Firestore). To do this, select Database> Real-time Database

Step 2. There you will find a three-point button in the upper right corner. Choose your option (import / export)