Manually copying rows from a PDF into Excel can take ages, especially when a report contains hundreds of entries. Even a small mistake can put a number in the wrong column or change an important value.

The good news is that you can convert a PDF table to Excel without retyping the data. Microsoft Excel, free extraction tools, and PDF editors offer ways to move tables into a spreadsheet. The best method depends on whether your PDF contains selectable text or scanned page images.

Before You Start: Check Your PDF

Open the PDF and try selecting a word or number with your mouse. If you can select individual characters, the document probably contains a text layer. If you can only select the entire page as an image, it may be a scanned PDF that needs optical character recognition (OCR) first.

This distinction matters because table extraction tools can often identify rows and columns in text-based PDFs more reliably than in scanned images.

Method 1: Convert a PDF Table Using Microsoft Excel

Excel’s Power Query PDF connector can import tables directly from supported PDF files. This is a useful option if you already have a version of Excel that includes the connector.

1. Open Excel and create a blank workbook.
2. Go to Data → Get Data → From File → From PDF.
3. Select your PDF and click Open.
4. Wait for the Navigator window to display the tables Excel detects.
5. Select a table and preview its contents.
6. Choose Load to import the data directly, or select Transform Data to clean it first.

Power Query lets you clean the extracted data before placing it in the worksheet. You can remove unwanted rows, correct column names, and adjust data types when necessary.

The exact menu options depend on your Excel version and platform. If you cannot find the PDF connector, use one of the alternative methods below. Microsoft explains the process in its official Power Query import guide.

Method 2: Use Tabula to Extract Tables for Free

Tabula is a free, open-source tool designed specifically for extracting tables from PDFs. It runs locally on your computer and supports Windows, macOS, and Linux.

Unlike a general PDF editor, Tabula lets you select the exact table you want to extract.

1. Download Tabula from its official website and follow the installation instructions for your operating system.
2. Open Tabula and upload your PDF.
3. Navigate to the page containing the table.
4. Drag a selection box around the table you want to extract.
5. Preview the extracted data and adjust the selection if any rows or columns are missing.
6. Export the result as a CSV file and open it in Excel.

This method is particularly useful when a PDF contains multiple tables or when you only need data from a few specific pages. Tabula works with text-based PDFs, not scanned documents, so you may need OCR first.

Download it from the official Tabula website rather than an unfamiliar download site.

Method 3: Export a PDF to Excel Using Adobe Acrobat

If you already use an eligible version of Adobe Acrobat, its export feature provides another straightforward option.

1. Open the PDF in Adobe Acrobat.
2. Select Convert.
3. Choose Microsoft Excel and select XLSX as the output format.
4. Click the option to convert the file.
5. Choose where to save the resulting workbook.
6. Open the workbook in Excel and inspect the extracted tables.

Acrobat also provides conversion settings that can help control how tables are exported. Depending on the document and available features, these include options for worksheet organization, number formatting, and text recognition.

PDF export and OCR capabilities depend on your Acrobat version and subscription. Check the current product features before paying for a plan solely for occasional conversions. See Adobe’s PDF-to-Excel instructions for the supported workflow.

What If Your PDF Is Scanned?

If the PDF contains photographs or scans of printed pages, extractable text may not be available. You will need OCR to recognize the characters before converting the table.

Use a PDF tool with text recognition, check whether your document’s language is supported, and then attempt the conversion again. Some OCR tools can produce a searchable PDF or editable document, but the results may not preserve complex tables perfectly.

Pay particular attention to decimal points, negative values, dates, and column boundaries. A recognized number can look correct while still being placed in the wrong row. For confidential documents, consider an offline tool instead of uploading the file to an online converter.

How to Fix Messy Tables After Conversion

A converted spreadsheet is not necessarily a correct spreadsheet. Before using the data, review the following details:

• Column alignment: Check that every value appears under the correct heading.
• Repeated headers: Remove extra header rows that were inserted between pages.
• Numbers and dates: Check decimal separators, thousands separators, negative values, and date formats.
• Missing rows: Compare the first and last entries with the source PDF, then inspect the middle of the table.
• Totals: Compare row counts and important totals with the original document where possible.

Be careful with identifiers such as invoice numbers, postal codes, and account references. Excel may interpret them as numbers and remove leading zeros. Set those columns to text if the original values must be preserved exactly.

Which PDF-to-Excel Method Should You Choose?

Final Thoughts

You do not have to retype a PDF table row by row. Start with Excel’s PDF connector if your version supports it, use Tabula for a free and targeted extraction workflow, or export directly through Adobe Acrobat if you already have access to the necessary features.

Whichever method you choose, review the resulting spreadsheet against the original PDF before relying on the numbers. A few minutes spent checking column alignment, missing rows, and number formats can prevent much bigger errors later.