In this short tutorial we will show you how to use Excel to import tables from web pages using the options. This easy to use technique can come quite handy if you need to copy table data from a web page into an Excel table.
Navigate to the Data Tab and select “From Web”. This will open a dialog box allowing you to enter the URL of the website that you want to import the table from.
In the dialog box enter the URL of the website that you want to import the table from.
Select the table you want to import from the list. If you don’t want to import all the data, you can select the “Edit” button and filter the columns you want to import. When you are done, select “Load”.
The end result is a table with all the headers and data imported into your Excel sheet.