How to import lnternet Web page data into Excel

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.