Multi-page PDF to Google Sheets

How to extract tables from several PDF pages at once and combine them in one sheet

Answer in brief

Most real documents, like bank statements, reports and price lists, spread their tables over several pages. Converting a multi-page PDF to Google Sheets means extracting each page's table and, where a table continues across pages, joining the pieces back together.

The Convert PDF to Google Sheets™ add-on by Easy Image to Text extracts up to 5 pages in one run, writes each page to its own sheet, and lets you download everything as a single CSV file.

Why multi-page PDFs are harder to convert

  • Tables break across pages. A 3-page PDF bank statement is really one long table cut into three pieces.
  • Headers repeat. Many documents print the column headers again at the top of every page, which creates duplicate header rows when you combine them.
  • Pages differ. The first page often has an account summary or invoice header, while later pages contain only line items.
  • Manual copying multiplies. Fixing columns by hand is tedious on one page, and on ten pages it becomes the whole afternoon.

If your PDF is a scan rather than a digital file, read about scanned PDF to Google Sheets as well, since scans add a recognition step to every page.

To see how other methods cope with long documents, read PDF to Google Sheets methods compared.

How to extract several PDF pages into Google Sheets

  1. Install the Convert PDF to Google Sheets™ add-on from the Google Workspace Marketplace.
  2. Open a Google Sheet and launch the add-on from the Extensions menu.
  3. Upload the PDF. A thumbnail of every page appears in the sidebar.
  4. Pick up to 5 pages, either by ticking thumbnails or by typing pages and ranges such as 1-3, 5.
  5. Click Extract Data. The pages are processed at the same time, and the sidebar shows the status of each one.
  6. Each page lands in its own new sheet, named after the page number and the file name, for example Page 2_statement.

Each successfully extracted page uses 1 credit. Pages that fail don't use any credits.

Watch: a multi-page PDF converted in one run

This short video shows the Convert PDF to Google Sheets™ add-on extracting a 3-page PDF in one run, with each page written to its own sheet.

What happens to each page

Every selected page is read independently, so a page with a summary block and a page with a long transaction list are each handled on their own terms. Every table found on a page is written to that page's sheet, with a blank row between separate tables.

Values are written as plain text, so account numbers keep their leading zeros and negative amounts keep their minus signs. This matters on long statements, where a single reformatted value is easy to miss.

When all pages are done, Download CSV gives you one CSV file containing the tables from every page that was extracted, ready to import into accounting software or Excel.

Converting PDFs longer than 5 pages

For longer documents, work in batches of up to 5 pages:

  1. Extract pages 1-5.
  2. Type the next range, such as 6-10, and click Extract Data again.
  3. Repeat until you reach the last page.

You only need to pick pages that actually contain tables. Skipping cover pages, terms and conditions, or blank pages saves both time and credits.

If a page fails, the add-on puts the failed page numbers back in the page box, so you can retry just those pages with one click.

Combining pages into one table

When a single table runs across several pages, you'll usually want it in one place. There are two easy ways to do this.

Copy and paste

Copy the rows from each page's sheet, without the repeated header row, and paste them under the first page's data. This is quickest for 2 or 3 pages.

Use a formula

In a new sheet, type the column headers in row 1, then put this in cell A2, changing the sheet names and the last column to match your data:

=QUERY(VSTACK('Page 1_statement'!A2:F, 'Page 2_statement'!A2:F, 'Page 3_statement'!A2:F), "where Col1 is not null", 0)

VSTACK stacks the pages on top of each other, starting from row 2 so the repeated headers are skipped, and QUERY removes the empty rows in between. The combined table updates automatically if you correct a value on one of the page sheets. In some regions, Google Sheets uses semicolons instead of commas between formula arguments.

The formula works best when every page has the same columns in the same order. If the first page has an extra summary table, start that page's range below it.

Frequently asked questions

How many PDF pages can I convert at once?

Up to 5 pages per run. For longer PDFs, extract the next range of pages in another run.

Will each page go into a separate sheet?

Yes. Each page is written to its own new sheet, named after the page number and the file name.

Can I get all the pages in one file?

Yes. After extraction, Download CSV gives you one CSV file containing the tables from every successfully extracted page.

How are credits counted for a multi-page PDF?

Each successfully extracted page uses 1 credit, so 5 pages use 5 credits. Pages that fail don't use any credits.

What if one of the pages fails?

The other pages are still extracted. The failed page numbers are put back in the page box so you can retry just those pages.

Do I have to extract every page of the PDF?

No. Choose only the pages you need, such as 2-4 or 1, 3, 6, and skip cover pages or terms and conditions.

Got a long statement or report to convert? Try the Convert PDF to Google Sheets™ add-on by Easy Image to Text: install it free from the Google Workspace Marketplace, or learn more about PDF to Google Sheets conversion.

Last updated: 2026-11-10