Please follow these steps:
Click the Data tab.
Click From Web in the Get External Data group.
Click the Options link in the New Web Query box.
Click Full HTML Formatting, then OK.
Enter the web address in the address bar, and click Go.
Each table on your web page will be indicated by an arrow, as shown below.
Click the arrow next to the table you want to import, which will turn it into a check mark.
Click the Import button, and the Import Data box pops up. Indicate where you’d like to import your HTML table, then click OK.
Format and Save your spreadsheet.
Important: Check the spreadsheet to be sure the columns were created correctly.
In some instances headings or numbers may be incorrectly separated as shown below:
When that happens you may want to copy the applicable section from the Web manually and paste it into Excel.
Then click the Data tab and select Text to Columns to correctly split the data.
Click Fixed width and then the Next button.
Click Finish if the columns are correctly separated.
Format and Save your spreadshseet.