In this dialog you can see a list of Html tables that excel parsed out on the left side, select the table which you want and it will display the table data on the right side. If you need to add headers or parameters to the url you can select the Advanced radio button to add more parts to the basic url then click the OK button. Input the web page url in the popup From Web dialog URL text box.
Click excel Data -> New Query ( in Get & Transform group ) -> From Other Sources -> From Web in the excel top toolbar.Because it parses the Html page in the background, it does not use a web browser to parse the web page, so it can parse out more Html tables. This method is better than method one.If you find the above web browser can not parse out Html table data in the web page, and this makes you can not get the table data that you need, you can use the below method.Ģ.2 Import Web Page Data Into Excel By Data -> New Query – > From Web Menu.During the process, it will prompt the excel cell range confirm dialog to you, and you can change the table data target excel cell range.