I used to do this manually too—such a waste of time! Now I use UiPath for how to automate excel from web data. It’s a robotic process automation (RPA) tool with a free version.
You can teach it to click, copy, and paste data into Excel automatically. Steeper learning curve but super powerful.
You can teach it to click, copy, and paste data into Excel automatically. Steeper learning curve but super powerful.