A search result, a product category or a directory almost never fits on one screen. The first 20 or 30 items are easy to copy; the other 900 are spread across numbered pages, hidden behind a Load more button or only appear as you scroll. ScrapeSheet collects all of them in one run and merges them into one table.
Step by step
- Add ScrapeSheet to Chrome and open the first page of the list you want.
- Click the ScrapeSheet icon to open the side panel and press Extract this page. Check the preview: if it picked the wrong block, press Suggest another table, or use Select manually (highlight) and click one item of the list.
- In Collect, choose All pages, or Custom… and type how many pages you want (up to 200).
- If the site uses a Load more or Show more button, or its Next link is not found automatically, press Mark the «Next / Load more» button and click that button on the page once. ScrapeSheet remembers it.
- Press Extract this page again. A counter shows the rows collected so far; you can Pause and resume, or Cancel.
- When the run ends you get a notification. Export with Excel, CSV, Copy or Sheets.
How each kind of list is handled
- Numbered pagination. ScrapeSheet looks for the page's own next link (the
rel="next"tag, a "Next" or "›" link, its label) or a page number in the address such as?page=2, opens the next page and waits for it to load. - Load more buttons. It clicks the button you marked, waits until new items really appear and learns how long that site needs, so the next run can suggest a sensible delay.
- Infinite scroll. It scrolls in steps until no new items arrive. It also works when the list scrolls inside a side panel rather than the whole window, which is common on maps, chats and dashboards.
- Duplicates. Identical rows are removed, so overlapping pages do not inflate your count.
Limits worth knowing
- Collecting several pages is a Pro feature. The free plan extracts the page you are on, with up to 20 rows per export.
- A run stops at 200 pages or 5,000 rows, or when three rounds in a row bring nothing new.
- Some very long feeds remove items once they scroll out of view (so-called virtualised lists). On those sites part of the list may be missed; a Load more button or numbered pages, when available, give more complete results.
Want the background first? Our guide How to scrape multiple pages explains the three pagination types in more detail. Once you have the full list, see web scraper to Excel or scrape to Google Sheets for the export side.
Use it responsibly
ScrapeSheet is meant for publicly available data. It reads the page you have open in your own browser, at your own pace; it does not get around logins, paywalls, CAPTCHAs or anti-bot protection, and it should not be used to try. Before you extract, check the website's terms of use: if a site forbids automated collection, don't use ScrapeSheet there. If the data includes people (names, emails, phone numbers), privacy law such as the GDPR applies to what you do with it. More in Is web scraping legal?
FAQ
Can ScrapeSheet scrape pages with infinite scroll?
Yes, with Pro. Choose All pages in Collect: ScrapeSheet scrolls the page, or the scrolling panel that holds the list, until no new items load, then extracts everything into one table.
How do I scrape a website that has a Load more button?
Press Mark the Next / Load more button in the side panel and click the site's button once. ScrapeSheet then clicks it for you, waits for the new items and keeps collecting until nothing new appears.
How many pages can I collect in one run?
Up to 200 pages or 5,000 rows per run on Pro. The free plan extracts the page you are on, with up to 20 rows per export.
Will overlapping pages create duplicate rows?
No. Identical rows are removed as they are collected, so you get each item once.
Can I pause a long run?
Yes. Pause keeps what has been collected so far, shows it so you can export it, and Resume continues from the same point. Cancel stops the run and discards what was collected.
Related use cases
Back to the ScrapeSheet home page · all use cases · ScrapeSheet Pro