CODEWITHSUNDEEP
excelfirebasefirebase-realtime-database
noblerare
noblerare

Reputation: 11873

How do I store Excel data into Firebase?

I have an Excel sheet of all my data (thousands and thousands of rows). How do I get that "loaded" into Firebase to be used?

I've created a Firebase project and tried to look at some tutorials for the realtime database but that's not quite what I want. I don't want real-time data quite yet. I just want data that I have to be loaded in first. How do I go about doing that?

Thanks!

Upvotes: 21

Views: 58890

Answers (2)

SUBRATA NANDI
SUBRATA NANDI

Reputation: 331

STEPS TO UPLOAD COUNTRY LIST IN FIREBASE:

  1. download country list with country code, currency code and currency name what you require:
  2. convert it into csv.
  3. convert csv into json from (https://codebeautify.org/csv-to-xml-json#).
  4. validate json from https://jsonlint.com/
  5. save in a file say test.json.
  6. open firebase with login.
  7. select database.

  8. click on (...) in verticle, beside + - sign,

  9. click on import.

  10. browse and select test.json file
  11. import
  12. now it is great!!!!!!! cheers!

Upvotes: 22

noblerare
noblerare

Reputation: 11873

I figured this out on my own.

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

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

Then, visit various resources online that can do CSV to JSON conversion. The one I used was: http://codebeautify.org/csv-to-xml-json

Finally, take that .json file and load it into the Firebase database. Voila!

Upvotes: 33

Related Questions