Import Excel Data into Firebase Database
I had a table of data that I wanted to feed into Firebase Realtime Database which has to be in JSON format. The table looks like this: Make sure that the key names for the JSON file should be the top row of the table. Now save the file as .csv in Excel: Go the https://codebeautify.org/csv-to-xml-json and browse the csv file and click on "CSV to JSON" button and then on "Download". In Firebase realtime database, click on the 3 dots icon on the right as shown in the image below: Then click on "Import JSON" as shown below: Then browse the downloaded JSON file and click on "Import". You will get the result as shown below: