Guides › Multi-page tables

How to export a table that's split across several pages

Updated 14 October 2026

Reports, search results and admin screens often show the data 10 or 25 rows at a time with "Next" buttons underneath. Copying page after page and pasting each one under the last is slow, and it's easy to miss or double up rows. Here are better options, from quickest to most powerful.

Quick answerFirst look for a "rows per page" setting or an Export button on the site. If there isn't one, a browser extension that follows the "Next" button can collect every page into one file and remove duplicate rows.

1. Show more rows per page

Look near the bottom or top of the table for a setting like Show 25 / 50 / 100 or Rows per page. Setting it to the maximum may put everything on one page, which you can then copy or export in one go.

Sometimes the page number or page size is in the address bar, such as ?page=2 or &per_page=25. Changing per_page to a larger number occasionally works, but some sites cap it.

2. Use the site's own export

Business tools (CRMs, accounting software, e-commerce dashboards) usually have an Export or Download CSV button that exports all matching rows, not just the visible page. It's the most complete option when it exists.

3. Google Sheets, when the page number is in the address

If the address changes predictably (?page=1, ?page=2…) and the page is public, you can put an IMPORTHTML formula for each page on top of one another:

=IMPORTHTML("https://example.com/results?page=1", "table", 1)
=IMPORTHTML("https://example.com/results?page=2", "table", 1)

This doesn't work for pages behind a login or tables that the site draws with JavaScript. See importing a web table into Google Sheets for why.

4. Let an extension click "Next" for you

For everything else (logins, tables built with JavaScript, "Next" buttons that don't change the address), an extension can work through the pages the same way you would, but faster and without mistakes.

With TableHop:

  1. Open the first page of results and click the TableHop icon.
  2. Select the table and click All pages.
  3. TableHop finds the site's Next button, clicks through each page and shows a running count. If it can't find the button, it asks you to click it once so it can learn it.
  4. When it reaches the last page, download the result as Excel or CSV, or copy it. Repeated rows are removed automatically.

For lists that load more rows as you scroll down (instead of having pages), use While scrolling. If each results page is a completely separate web page, use Add to collection on each one and export them together.

All pages and While scrolling are Pro features, and you can try them free three times. Captures stop at 50 pages or 2 minutes by default so they don't overload slow sites. You can change both in settings.

Be considerate

Only collect data you're allowed to use. Some websites' terms restrict automated browsing or reusing their data, so keep page limits sensible and check the terms for anything you plan to publish or resell.

Do this in one click with TableHop

A free extension for Chrome and Edge that copies any web table into Excel, CSV or Google Sheets – columns intact. It works on your computer and never sends your data anywhere. See how it works.