Excel makes it easy to extract table data from a Web page - but to be of use in a worksheet, you will need to convert the text tables into. Web queries offer a handy way to import data from selected tables into a worksheet-but Excel isn't as accommodating as it should be. In Excel 2000: Choose how often you want to refresh the data. In Excel XP: Enter the URL of the web page from which you want to import the data and click Go. From the Data menu select either Import External Data or Get External Data.
4 min - Uploaded by Jason Khoo This video show you how to retrieve data. In the Import Data dialog box, do one of the following: 6 min - Uploaded by Computergaga Import data. Select the Web query that you want to run. In the Look in box, locate the folder where your query file is stored. Click the Microsoft Office Button, and then click Open.
Download Link data from internet to excel
0 kommentar(er)
