How to Convert PDF Tables to Excel: 5 Free Methods and When Each Works

A 12-page bank statement, a supplier price list, a sales report, a transcript. The table is right there in a PDF, and you need it in Excel to sort, sum and analyse. Direct copy-paste usually gives you one long column of jumbled numbers, and retyping can take hours.

The good news: there are effective free methods, some built into Excel itself. The less good news: which one works depends on the type of PDF. This guide shows how to identify your table type, which method fits, and how to clean the result.

Why are PDF tables hard to extract?

In Excel, a table is cells: this value is in row 3, column B. In most PDFs, there's no concept of a "table" at all — just text drawn at specific positions with lines drawn nearby. Your eyes see rows and columns; the file doesn't know that "1,250" belongs to the "Amount" column.

So conversion tools infer the table from text positions: words aligned horizontally form a row, words aligned vertically form a column. That works well for regular tables and struggles with:

• Merged cells and headers spanning several columns.
• Text wrapping onto two lines inside a cell.
• Tables without ruling lines.
• Very closely spaced columns.
• Tables spanning multiple pages with repeated headers.

Step one: what kind of table is it?

Open the file and try to select a number in the table:

Method 1: Excel's "From PDF" import

Recent Excel versions in Microsoft 365 for Windows include a PDF connector via Power Query:

1. Excel → Data → Get Data → From File → From PDF.
2. Choose the PDF.
3. The Navigator lists tables Excel detected — usually one per page, sometimes suggested tables spanning pages.
4. Click a table to preview, then Load to put it in a sheet, or Transform Data to clean it in Power Query.
5. In Power Query you can remove blank rows, promote the first row to headers, and append tables from several pages.

Strength: handles multi-page tables and remembers the steps. When next month's statement arrives in the same format, Refresh repeats everything.

Limits: not available in every Excel edition — you may not find it in Excel for Mac or older non-subscription versions — and it doesn't work on scans.

Multi-page bank statement, step by step

1. Data → Get Data → From File → From PDF → choose the statement.
2. In the Navigator, tick Select multiple items and pick every page's table (Table001, Table002…).
3. Click Transform Data.
4. Home → Append Queries → Append as New → select all tables.
5. Use First Row as Headers.
6. Filter the date column to drop repeated header rows and blanks.
7. Change data types: dates as Date, amounts as Decimal Number.
8. Close & Load.

Next month, save the new statement with the same name in the same folder and click Refresh All.

Method 2: Tabula (free and open source)

Tabula is a free tool built specifically to extract tables from PDFs, used by journalists and researchers for years:

1. Download Tabula from its official site and run it — it runs on your computer and opens its interface in the browser.
2. Click Import and choose the PDF.
3. Drag a box around the table, or click Autodetect Tables.
4. Choose the extraction method: Lattice for tables with ruling lines, Stream for tables without.
5. Preview & Export → export CSV, then open in Excel.

Strength: very accurate with regular text tables, runs locally with no upload, completely free.

Limits: doesn't work on scans and needs installing. Right-to-left tables may need column-order review.

Method 3: smart copy-paste

For small tables, this is fastest:

1. Select the table in your PDF reader and copy it.
2. Paste into Excel. Often each row lands in one cell, values separated by spaces.
3. Select the column → Data → Text to Columns.
4. Choose Delimited with "Space", or Fixed width if values contain internal spaces, and set column breaks manually.
5. Click Finish.

Tip: paste into Word first — it sometimes recognises the table as a table — then copy from Word into Excel.

Method 4: Google Sheets and Docs

1. Upload the PDF to Google Drive and open it with Google Docs.
2. If the table appears as a table, copy it into Google Sheets.
3. Or use Sheets functions like SPLIT to divide text.

Results vary, and the file goes to Google's servers — don't use it for sensitive financial data.

Method 5: scanned tables (OCR)

If the table is an image, OCR is unavoidable:

1. Extract text with OCR, choosing the right language.
2. Paste into Excel and use Text to Columns.
3. Check every number against the original — OCR can confuse 1 and 7, 3 and 8, or drop decimal points.

Accuracy trick: for large tables, crop each column into its own image and OCR it separately, then place columns side by side in Excel. That prevents cells getting jumbled. Best results come from 300 DPI scans — see Extract text from images and scanned PDFs.

Methods compared

Cleaning the data after conversion

Whatever the method, expect some clean-up:

1. Remove repeated header rows that appear on every page — filter them out and delete.
2. Convert text to numbers: left-aligned figures or green triangles mean text. Select → "Convert to Number".
3. Thousands and decimal separators: "1.250,50" means one thousand two hundred fifty and fifty cents in many European locales. Check your regional settings.
4. Dates: "03/04" can be March or April depending on settings. Verify.
5. Merged cells: a value that spanned several rows appears only once. Fill blanks with Go To Special → Blanks.
6. Reconcile totals: sum the amount column and compare with the printed total. If they match, the data is probably sound.

Right-to-left and non-Latin tables

• Column order: tools usually read left to right, so the last column of an Arabic or Hebrew table may appear first. Reverse the order in Excel, or set the sheet to right-to-left (Page Layout → Sheet Right-to-Left).
• Arabic-Indic digits (٠١٢٣): Excel may treat them as text, breaking sums. Replace them with Western digits via Find and Replace or nested SUBSTITUTE.
• Garbled characters: an encoding problem in the PDF itself — use OCR. See Convert Arabic PDF to Word without broken letters.

Tips for better extraction

• Start from the best copy: the original digital file beats a printed-and-scanned one.
• Narrow the range: extract just the table pages with Split PDF before importing, to reduce phantom tables.
• Rotate landscape pages: wide tables are sometimes on rotated pages; fix with Rotate PDF first.
• For scans: scan at 300 DPI grayscale — OCR accuracy on digits depends on it.
• Keep the PDF alongside the Excel file to check against when in doubt.

Before all of that: ask for the original

Many PDF tables were exported from Excel in the first place. Banks often let you download statements as CSV or Excel from online banking; suppliers have their original price list; organisations hold their data in editable formats. Ask for the source file first — it's faster and more accurate than any conversion.

Practical scenarios

Monthly bank statement

Look for CSV download in online banking first. Otherwise use Excel "From PDF", append the page tables in Power Query, and save the query to refresh monthly.

Supplier price list

A regular, ruled table: Tabula in Lattice mode gives excellent results. Check prices with decimals.

Scanned transcript

OCR, arrange columns, then check every grade. For small transcripts, typing may be faster and more accurate.

FAQ

Is there a free PDF-to-Excel converter that keeps tables perfectly?

No tool is perfect for every table. Excel "From PDF" and Tabula are excellent with regular text tables; complex or scanned tables always need manual review.

Why does the table paste into one column?

PDFs don't store cell boundaries. Use Excel's Text to Columns to split it.

Can a scanned table be converted to Excel?

Yes — OCR first, then arrange columns, with careful checking of numbers.

Does WPPR convert to Excel?

There's no direct converter yet. Use PDF to text for text PDFs and OCR for scans, then arrange the data in Excel.

How do I make sure numbers are correct?

Sum columns and compare with printed totals, and spot-check random rows.

Is my data safe?

WPPR tools process files in your browser with no upload. Excel and Tabula run on your computer. Google Docs is cloud-based.

Bottom line

Moving a PDF table into Excel starts with knowing the file type: text PDFs import with Excel "From PDF", Tabula, or copy-paste with Text to Columns; scans need OCR. Always clean the data and reconcile totals — and ask for the original file whenever you can.

For scanned tables, start with OCR — free, and nothing is uploaded.

Sources

• Tabula: extract tables from PDFs
• Power Query (Wikipedia)
• Comma-separated values (Wikipedia)
• Optical character recognition (Wikipedia)