1, click on the menu "data" click on the Window "Import external Data" and then "new Web query."
2. In the Open New Web Query dialog box, in the Address Drop-down list text box, enter the page address.
3, click the ' Go to ' button to open the selected page. The displayed portion of the page is divided into multiple content parts, and the left arrow is displayed in the upper-left corner of each item that can be imported as a datasheet. Click the arrow ID in the upper-left corner of the data table that you want to import into Excel, and the selection of this table area will change to a tick.
4, click the Import button "Open the Number of Imports" dialog box. Select the existing worksheet, radio button, in the combo box where the data is placed. and enter the starting cell position of the data Guide in the text box, and click OK.