Download firebase data in excel/csv formet

Dhiren_Patel · September 30, 2021, 3:32pm

Hello
How to download Firebase data in Excel or csv format by clicking a button?

dora_paz · September 30, 2021, 3:34pm

If you have no authentication rules then you could use Web component. Set Web1.Url to

https://<PROJECTID>.firebaseio.com/.json?

and then when Web1.GotText set label to get responce content

Dhiren_Patel · September 30, 2021, 3:39pm

How to configure blocks? Explain if there is any example.

If there is any such AIA file, please provide it.

dora_paz · September 30, 2021, 3:46pm

TimAi2 · September 30, 2021, 3:53pm

no question mark needed…

soyla_school · October 30, 2021, 3:25pm

please give me a soluation

please give me an AIA file

dora_paz · October 30, 2021, 3:26pm

Solution for what ?

soyla_school · October 30, 2021, 3:27pm

How to download Firebase data in Excel or csv format by clicking a button?

dora_paz · October 30, 2021, 3:32pm

You can not, you can get all data in json format

soyla_school · October 30, 2021, 3:36pm

Let me know if there is any other way to download FireBase Realtime Database in Excel format.

dora_paz · October 30, 2021, 3:40pm

Where is the problem to get it in json format ? Afterwards you work with dictionary blocks to get the data you need

TimAi2 · October 30, 2021, 3:54pm

might need to tidy up the csv table using the text replace block to remove some double quotes…

system · February 13, 2022, 4:50am

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.