How to import CSV files into Firebase / Firestore in 7 minutes

This video is about how to quickly build an app to import CSV row data into Firebase or Firestore. We use Retool, a developer tool for building internal tools.

Try Retool here:

Check out the Retool community here:

[Geko]

Thank you so much for this great video and good explanation.

[Geko]

Filepicker component now is called "upload".

[pashabig]

What can I do if my csv is too large? Currently I am dealing with a 185 MB csv (this is just a portion of the whole data I need to import). My chrome page fails and mentions it is out of memory.

[ccnmagno]

Hi, that last BULK script takes some time in each loop : so with a litle change turns more efficient with a forEach:

const rows = sourceCsv.parsedValue[0];
if (rows.length===0){
console.log('no data')
}

rows.forEach((data, index)=>{
insertRoomBulk.trigger({
additionalScope:{data:data},
file ', index)}
});
})
Thanks

[mohebjami]

How to export Firebase data in excel file with the mobile app

[Atlantis]

Did you make the "Upload entire CSV file" video yet? When I run the current code here, all the rows data uploads as "null"

[a.frederick]

Great video, easy to follow, and awesome content! Wanted to ask if bulk import also works for Firebase Auth? Thanks!

[MusicMartijn]

Thank you for the nice tutorial!

Unfortunately, I'm running into a problem. When a value in the csv is less then 0, 01, the value in firebase is automatically changed to ''null'. I just made a ticket on the retool community. Perhaps more people run into this. I wonder how to fix this.

[doyeon]

This is really great tutorial! but i tried to upload csv file same as the video but i got whole data in one cell like the data received was having different format from your format. i even tried to download the csv file that Retool provided [book.csv] on the documentation, but it wont work as well. Do you have to reset the table format? i badly need this but doesnt work for me

[andreasfranco]

Sure this tutorial is still valid... have you changed the naming and layout.. ??

[redlobsta]

I just signed up for ReTool to try and follow along, the file picker module is missing.

[remkm]

And here i was thinking to just simply upload some data to Firebase... You should edit the Description of this video to let people know its outdated. also some issue with csv uploading

[TrilochanSatapathy]

Hey! great job man. I have one doubt, suppose the firestore database previously has a large amount of data, then I want to push some data from a CSV/JSON file to the database, I don't to overwrite, I want those data to be added newly. Will this tool help?

[zakblacki]

Why didn't you put the JavaScript code in the description ?

Also You did not show the click handler for the button " Insert all rows from csv"
Correct me if I'm wrong

Action : Trigger query
Query : InsertDocBulk

[dallasrieck]

title should be: "share on how to create a firebase/CSV import tool..."; boarder line clickbait

[mattd]

They changed the UI so much that this tutorial is now obsolete.