I've connected various queries to Excel using Microsoft Excel Power Query. Unfortunately, I have to log in each time again at Salesforce via a dialog window. Is there a VBA script with which I can automate this login?

I know there are some docs where its explained that but.
I have a csv for an custom object with 10000 records.
I want to upload this data to my org using bulk api.
I know there are tools are dataloader.io and apex data loader. but i want it as custom tool in python.
Thanks.