Previous Topic Next Topic

Webpage to excel

Solved/Closed
priyaa - Jun 11, 2011 at 06:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 17, 2011 at 09:31 AM
Hello,
Could you please help me in downloading data's from a web page
to an excel.
If that web page has multiple pages ( 1,2,3,4.... ), i want all page datas from web page in to excel at a time.
Could you please advice how to do this?

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 17, 2011 at 09:31 AM
Hi Priyaa,

Goto top menu's > Data > Import external data > New webquery.

A webbrowser appears in which you select the desired webpage.

After importing repeat for the other pages.

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses