How to store Excel data in Firebase?

Question

I have an excel sheet of all my data (thousands and thousands of rows). How can I get this “loaded” in Firebase to use?

I created a Firebase project and tried to take a look at some tutorials for a real-time database, but that is not quite what I want. I do not want to receive data in real time yet. I just want the data that I have to download first. How should I do it?

Thanks!

Answer 1

I figured it out myself.

First, take an Excel spreadsheet and clean it so that the first row contains the headers and the rest is the actual data. Remember that Firebase keys (which correspond to the column headings) must be encoded in UTF-8, which means they cannot contain it. $ # [] / or ASCII control characters 0-31 or 127.

Then save it as a CSV file. For example, in Excel 2013 it would be: File> Export> Change File Type> CSV.

Then visit various resources on the Internet that can convert CSV to JSON. The one I used was: http://codebeautify.org/csv-to-xml-json

Finally, grab this .json file and upload it to the Firebase database. Voila!

Answer 2

STEPS TO DOWNLOAD THE LIST OF COUNTRIES IN FIREBASE:

1. Download the list of countries with the country code, currency code and currency name, what you need:
2. convert it to csv.
3. convert CSV to JSON from ( https://codebeautify.org/csv-to-xml-json# ).
4. check JSON from https://jsonlint.com/
5. save in the file say test.json.
6. open firebase with login.
7. select a database.

8. press (...) in the text, next to the + - sign,

9. click on import.

10. find and select test.json file
11. Import
12. Now it's great !!!!!!! Hooray!