How I export my Firebase data in Excel Sheet

Question

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:

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

Answer 1

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

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.

Answer 2

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.