Pull Web Page Results into Excel

Go to Data Menu, choose the “From Web” option under the “Get External Data” section. Put a valid web page address, and click on “Import” button at the bottom.

It will put the web page content to the Excel worksheet. If the web page makes updates in the background and if you need to pull the updated content to Excel, that is easy as well.

You just have to right-click on the download content and hit “refresh.” The content will be pulled again, and the new content will replace the old one on the worksheet.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts