Guides

How to Extract Tables From a PDF

By PDFConvertly 4 min read

Illustration of a table being lifted out of a PDF page into a spreadsheet grid

A table in a PDF looks tidy, but try copying it and you'll often get a jumble of numbers on one line. Getting tabular data out of a PDF cleanly depends on how the PDF was made and which method you use.

This article compares three practical methods and explains when each one works best.

First, check what kind of PDF you have

Everything below assumes a text-based PDF – one where you can select individual words and numbers. Statements, invoices and reports exported from software are usually text-based.

If the PDF is a scan (you can only select the whole page as an image), the table has to be recognised with OCR software first. None of the methods below can read text from an image.

Method 1: Copy and paste

Best for: a small, simple table you need once.

  1. Open the PDF in your PDF reader.
  2. Select the table with the text tool and copy it.
  3. Paste it into Excel or Google Sheets.
  4. If everything lands in one column, use Data › Text to Columns (Excel) or Data › Split text to columns (Google Sheets).

Pros: no extra tools. Cons: cell boundaries are often lost, numbers may stay as text, and multi-page tables mean repeating the process for each page.

Method 2: Excel's built-in PDF import

Best for: Microsoft 365 users on Windows who regularly import the same kind of report.

Recent versions of Excel for Windows can import tables directly: Data › Get Data › From File › From PDF. Excel shows the tables it finds; you pick one and load it, optionally cleaning it up in Power Query first.

Pros: repeatable – you can refresh the query when a new PDF arrives. Cons: not available in every Excel version or on every platform, and borderless layouts are sometimes detected as one wide column.

Method 3: A PDF to Excel converter

Best for: whole documents, multi-page tables, statements and anyone without a recent Excel version.

  1. Upload the PDF to the PDF to Excel converter.
  2. Download the XLSX file.
  3. Each PDF page becomes its own worksheet; delete the sheets and rows you don't need.

Pros: works in any browser; ruled tables are copied cell by cell with merged cells; borderless columns, such as on bank statements, are separated by alignment; numbers become real numbers (currency, thousand separators, percentages and negative numbers in brackets are recognised). Cons: text outside the tables is included as well, and irregular layouts may put some values in the wrong column, so the result needs a quick check.

For a full walkthrough of the converter, see how to convert PDF to Excel online.

Which method should you choose?

Situation Recommended method
One small table, needed once Copy and paste
The same monthly report, Microsoft 365 on Windows Excel's PDF import
Multi-page statement or several tables PDF to Excel converter
Table without border lines (aligned columns) PDF to Excel converter
Scanned PDF OCR software first – none of these methods read images

Cleaning up the extracted table

Whichever method you use, a few checks save trouble later:

  • Compare totals with the figures printed in the PDF.
  • Remove repeated header rows that appear at the top of every page.
  • Convert dates – they often arrive as text. Excel's Text to Columns wizard lets you choose the date format of each column.
  • Watch for merged text. Long descriptions that wrapped onto two lines in the PDF can become two rows; join them where necessary.
  • Keep leading zeros. Product codes such as 00451 should stay as text. The converter keeps them as text; when pasting, format the column as text first.

Frequently asked questions

Can I extract only one table from a long PDF?

With the converter you get all pages, one worksheet per page – simply keep the sheet with your table. With Excel's import you choose the table before loading.

Why do my numbers not add up after copying?

Pasted numbers are often stored as text, especially with currency symbols or thousand separators. A converter that recognises number formats avoids this; otherwise use Data › Text to Columns to convert them.

Can formulas be extracted?

No. A PDF only contains the calculated results. The values arrive as numbers, and you can add formulas again.

Summary

For a quick, small table, copy and paste is enough. For recurring reports in Microsoft 365, Excel's own PDF import is convenient. For statements, multi-page tables and borderless columns, a PDF to Excel converter is usually the fastest route to clean, calculable data. Whatever you choose, check the totals before trusting the numbers.

← All articles