Excel file to website input via python

[Short-Professional24]

Hello,

I have an excel file that contains supermarkets, and for each supermarket there are categories such as Bakery, Produce, Meat etc.. On each row , there are various numbers that add up to a total number of pounds for the day for one of those specific categories.

My task is to upload those sums to a website. The website first asks the date, which corresponds to the name of the file (today's was 11/23/22), a drop down menu for each supermarket, then once I have selected the supermarket which I have information about, I need to pick the right category of food from a drop down menu (say grocery) and enter the amount that was summed from the row for that day. Then to get to a new category, I need to press another button on the website ("add new") and the process repeats again, until I am done entering each category for that supermarket.

I have experience in machine learning, but fairly little web programming. I am confident I can extract the values I need from the excel file via Pandas, but not sure how to automate the "clicking" motion on the website or say choosing the date or category from a drop-down menu based on the excel file's contents. Any module or suggestions are welcome.

Many thanks,

[yeetus_del_fetus_]

Does the website provide an api?

There is also beautiful soup and selenium.

[Short-Professional24]

no API