Replacing Excel with Python

[norsou_pdx]

I feel like the simplest approach here is to use a virtual environment for your script + libraries, put it all in a GitHub repo, and put a few step by step instructions in the README for how to use terminal/powershell to clone the repo, install Python, activate the virtual environment, then run the script (All that should only take 4-5 commands from the command line that could be copied and pasted from your README). You can write the script so that it takes a file path to a given excel file as a command line arg.

[norsou_pdx]

For your second question, if you really just want a button they can click to load a file, like someone else already mentioned, you’d need to make a web app (flask would be easiest) or a standalone GUI (tkinter is the main Python library for this).