Learn how to use Get Data from web in Excel and link to tables available on the internet.
In this example, we'll link a list of countries from Wikipedia and also go a little into the Data type Geography to bring even more additional information related to those countries.
Not all websites will offer the data in a table import format. But, if you see a table when you visit the page, chances are you can bring that table into Excel.