Instead, Excel has an in-built way to easily import the table to your spreadsheet.
We will use the Wikipedia page on world population as our example.
Head to the Excel workbook where you want to import the table.
Lucas Gouveia / How-To Geek |Kamil Zajaczkowski/ Shutterstock
If you’re happy that Excel is importing the correct data, click “Load.”
Your imported table will then show in the Excel workbook you have open (in a new tab).
Let’s look at how best to manage the imported data.
Again, depending on the size of the data, this may take a while to complete.
Uncheck the “Adjust Column Width” option.
Then, in the Query Properties window, head to the “Usage” tab.
Choosing only these two options means that Excel will run more smoothly without constant interruptions through automatic refreshes.
You’ll see the status of the refresh at the bottom of your Excel window.
