Using Python to Read Excel Data and input value into new excel sheet

I’ve got a task that I complete each week for work, where I export data in excel from a web browser-based software and pull specific data from that workbook. I then input that data into new workbooks for specific branches of our company to compute weekly profitability reports.

Is there a way to automate this using Python where it will pull the data each week and then write it into a new copy of the profitability workbooks for each location? I’m new to Python and only want to go further if this would be possible.

Any ideas or thoughts would be extremely helpful. Thanks in advance!

This is certainly possible. I’m away from my PC right now so I can’t go into to much detail. I’ve had success reading and writing XLSX files with the openpyxl and xlsxwriter packages.

Automatically downloading XLSX exports may be more tricky however, but that’s not sure to limitations with Python

helpful information thank you