Share via

How to pull data from multiple pages?

Anonymous
2018-05-23T03:43:34+00:00

Hi,

I've case data to pull from a page. However, the page can list only 50 cases per page. Hence, when I try pulling the data to excel sheet using URL, its only pulling the 50 cases and not rest of the cases which are in rest of the pages.

Can anyone help me out here? I want to pull data from all pages at once.

Regards,

Vishal.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-05-23T06:58:53+00:00

    Hello,

    why can the page list only 50 cases? Excel has a million rows.

    What URL are you referring to? Excel uses formulas, not URLs.

    I have a feeling that the description of your scenario is incomplete. 

    Are you pulling data from a web page URL that serves only 50 cases per page? And then you create a similar web query on another sheet for page 2? and then another sheet for page 3?

    If so, this is a very clunky approach. Modern Excel has tools to pull data from paged web content with Power Query, but there is a learning curve to that.

    Was this answer helpful?

    0 comments
  2. Lz365 38,201 Reputation points Volunteer Moderator
    2018-05-23T04:54:38+00:00

    @Vishal

    Assuming you pull the data using Get & Transform have a look to:

    Hope this helps

    Was this answer helpful?

    0 comments