This 3 minute video shows how easy it is to link to web page data with Excel.
In this scenario it’s connecting to the Reserve Bank of Australia exchange rates web page.
Get & Transform is built into Excel 2016.
It was previously known as Power Query and is still a free download for Excel 2013 / 2010.
This identical functionality is available in PowerBI Desktop.
The URL if you want to give it a go yourself…
Find out more
Power BI is free to a large extent, and you can do a huge amount without any cost.