How to upload data from Excel to Firestore with Python

When you have to enter data into your Firestore database you are stuck with entering every document manually. This short article will show you how to use pandas and the firebase-admin sdk in Python to parse an Excel sheet and send it to your Firestore database.

I assume you already have a Firestore project. Go to your Firebase console and click on the Settings icon next to Project Overview (1.). Now you should open the Project settings menu entry (2.).



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store