1 / 6

Efficient Data Extraction and Transfer Process in Excel

Learn how to extract data from websites and transfer it accurately in Excel. Follow step-by-step instructions for effective data manipulation and organization.

kiayada-webb
Download Presentation

Efficient Data Extraction and Transfer Process in Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Move the cursor to cell A1 of the ‘Input’ worksheet. • Click on New Web Query… from the Data, Get External Data menu. • In the New Web Query dialogue box, click on Browse Web… • The web browser will load. • In the web browser, browse to the required website or select from a saved bookmark (e.g. Favorites)

  2. Minimise the browser window and you will see that the URL has been entered directly into the input box. • Click OK • In the last input box, check that the data will be entered into the correct cell and worksheet.

  3. The data will be entered into the spreadsheet. • Note other features of the web page have also been entered.

  4. Highlight the data to be processed. • Prepare the selection for copying by using CTRL + C or the Edit menu.

  5. Move the cursor to the required cell on the Process worksheet. • Select Paste Special.. from the Edit menu. • On the Paste Special dialogue box, select Paste Link.

  6. The data will be entered into the cells from the Input worksheet. • Note that it is the cell reference that has been pasted.

More Related