1. Open up a blank workbook, or you can select the Insert Worksheet command if it is an existing workbook.
2. Run a web query by choosing the Get External Data from web command in the Data tab as seen below: 
You can also simply click the "From Web" shortcut option as well.
3. Open the web page containing the table that you want to extract data from by entering its URL into the Address field and click "OK".
4. Excel will automatically detect tables that exist on the Web page and offer a selection of the ones that are found, you can select one or select multiple tables. After you select the table you need, click on "Load":
You can also select "Transform Data" to open the table in Power Query for additional editing/cleaning.
5. You should see the selected table appear in your Excel worksheet:
