How to upload data from Excel to Firestore with Python

Daniel M
3 min readDec 18, 2020

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.).

--

--