Automate data extraction from Excel using Python

This week at work, I automated the process of extracting historic data from thousands of excel files using Python. Here is how.

You might be in the same situation as me, where you need to get some data from a daily excel report stored in one or multiple folders on some drive. The report could be orders received, or whatever your colleagues or you have decided to save in excel day after day, year after year.