How to Convert PDF to Excel – Methods That Keep Your Numbers Intact

A supplier sends the new price list as a PDF. The bank statement, the quarterly report, the research table – all of them arrive in a format built for reading, not for calculating. Learning how to convert PDF to Excel well is less about finding the right button and more about what happens after it: columns that drift, rows that split in two, numbers that arrive as text, and figures nobody checked against the original. This guide explains why PDF tables break, compares five ways to get the data into a spreadsheet – from Excel’s own PDF import to Acrobat, Word and picture recognition – and shows how to verify that every number still matches the source.

Why PDF Tables Break on the Way to Excel

Most PDFs have no cells. They store text as characters placed at fixed positions on a page, and table borders and shading as drawn lines and shapes. Any converter has to look at those positions and decide where the columns and rows were. Most of the trouble comes from that guesswork:

• Columns drift or merge when values sit close together or do not line up exactly.
• Rows split. A cell with wrapped text can come out as two or three rows. Microsoft’s own documentation for the PDF connector notes that multi-line rows are not always identified correctly.
• Tables break at page ends. A table that runs across pages can arrive as separate pieces, often with the header repeated on each one.
• Numbers arrive as text. Spaces, currency symbols, footnote marks or an unexpected decimal separator stop Excel from treating a figure as a number – and a total that ignores it looks perfectly normal.
• Merged headers and subtotals do not fit a simple grid and need restructuring.

The same problems appear when tables go into Word – our guide to why tables break in conversion covers them in detail.

First, Check What Kind of PDF You Have

Before you decide how to convert PDF to Excel, check whether the PDF contains real text. Open it and try to select a word, or search for a number you can see on the page:

• Digital PDF. The text is selectable and searchable, because the file was exported from a program such as Excel, Word or an accounting system. Every method below can work with it, although Data from Picture needs an image of the page rather than the PDF itself.
• Scanned PDF. Nothing can be selected: each page is a picture. The data has to be recognized first with OCR (optical character recognition) – our guide to how OCR works explains the process.
• Mixed PDF. Some pages are digital, others scanned, or a scan already carries a text layer from earlier recognition – in that case, check that layer for errors before you trust it.

If the PDF needs a password to open, you need that password – and the right to use the file – before any method can read it.

Method 1: Excel’s Get Data from PDF

Excel for Microsoft 365 on Windows can import tables straight from a PDF through Power Query, without a separate converter. Microsoft’s instructions for importing data from a PDF are short:

1. Select Data > Get Data > From File > From PDF.
2. Select the PDF file and click Open. The Navigator shows the tables Excel found in the file.
3. Select the tables you need, then choose Load to put them on a worksheet, or Transform Data to clean them in Power Query first.

Two practical strengths make this method worth learning. The data lands as a query, so when next month’s PDF arrives with the same layout, you can point the query at the new file instead of starting again. And Transform Data lets you remove repeated headers, fill down split rows and set column types before anything reaches the worksheet. For a folder of PDFs with the same layout, Microsoft points to the Folder connector, which combines the files in one query.

The limits are just as practical. The connector reads text, so an image-only scan gives it nothing to work with. If Excel reports that the connector needs additional components, Microsoft notes that it requires .NET Framework 4.5 or later. Microsoft’s table of Power Query data sources by Excel version marks the PDF connector as included in Microsoft 365, not in the older one-time-purchase versions it lists – so if Get Data shows no From PDF, check which Excel you have. And on a Mac, Microsoft’s list of Power Query data sources for Excel for Mac does not include PDF – Mac users need one of the other methods.

Method 2: Export from Acrobat

If you work in Adobe Acrobat, it can convert a PDF straight into an Excel workbook. Following Adobe’s steps: select Convert in the global bar, choose Microsoft Excel and XLSX, then Convert to XLSX and save the file.

Open Settings before you convert – the options there matter more than the button:

• Excel Workbook Settings: one worksheet for each table, for each page, or for the entire document. One worksheet for the entire document puts a long table on a single sheet instead of spreading it across several.
• Numeric Settings: the decimal and thousands separators. Set them to match the document, so a figure written as 1.234,56 is read the way it is written.
• Text Recognition Settings: recognize text in images – needed for scanned pages – and the language of the document.

Method 3: Open the PDF in Word, Then Move the Tables

Word can open a PDF and convert it into an editable document: it makes a copy of the PDF and attempts to match the original layout. Microsoft is open about the limits in its note on opening PDFs in Word: the result might not look exactly like the PDF, the conversion works best with files that are mostly text, and tables with cell spacing are among the elements that do not convert well. A page that is mostly charts or graphics may come through as a single image.

When Word rebuilds a table as a real Word table, you can copy it into Excel in one step. When it does not, this route turns into retyping. It is a reasonable first try for a short, text-heavy document with a few simple tables – and a poor choice for a statement full of columns.

Method 4: Data from Picture for Scans and Screenshots

For a scanned page, or a table you can see but not select, Excel can recognize data in an image. On Windows, select Data > From Picture > Picture From File, or take a screenshot of the table and select Picture From Clipboard; on a Mac, the path is Data > Data From Picture > Picture From File (or Picture From Clipboard). Excel analyzes the image and shows the result for review – Microsoft’s instruction is to review the results, make any corrections and only then select Insert Data.

A few conditions from Microsoft’s page on inserting data from a picture:

• It reads pictures, not PDFs – export or capture each page you need as an image.
• It is a Microsoft 365 feature – Microsoft’s page applies to Excel for Microsoft 365.
• Only the character sets Microsoft lists are supported: English and a group of European languages, including French, German, Polish, Spanish and Turkish. Greek, Russian, Ukrainian, Arabic and Chinese are not on the list, so check it before you rely on the feature.
• Crop the image to the data you need, and use a picture taken head-on and in focus.
• On Windows, it needs Windows 11 or Windows 10 version 1903 or later, with Microsoft Edge WebView2 Runtime installed.
• If From Picture is missing or grayed out on the Data tab, check these requirements and your privacy settings for connected experiences – on a work or school account, your IT team manages them.

Method 5: Online Converters and OCR Software

Online PDF-to-Excel converters and desktop OCR applications can cover what the built-in tools do not: batches of files, difficult scans, many languages. Quality varies between tools and between documents, so two checks come before any of them:

• Where your file goes. An online converter uploads the PDF to someone else’s server. Read the provider’s terms before you upload bank statements, payroll, contracts or client data.
• How it handles your hardest page. Test the page with merged headers, wrapped cells and a table that runs across a page break – not the clean first page.

Our comparison of OCR software covers the main desktop tools and what each is good at.

How to Convert PDF to Excel: The Methods Side by Side

Each method fits a different kind of PDF and a different risk, so how to convert PDF to Excel depends on the file in front of you. The table sums up the five methods above:

After the Conversion: Clean and Verify

Getting the table out is the easy half. Before anyone sorts, sums or sends the spreadsheet, check it against the PDF:

1. Count rows and columns. Compare them with the PDF, and look closely at the first and last rows of every page – that is where tables split and rows go missing.
2. Find numbers stored as text. They usually sit left-aligned, and Excel often flags them with a small error indicator; the indicator’s menu offers to convert them to numbers. A SUM over text values quietly ignores them.
3. Fix the separators. If the PDF writes 1.234,56 and your Excel expects 1,234.56, the NUMBERVALUE function converts text to a number with the separators you specify – for example, =NUMBERVALUE("2.500,27", ",", ".") returns 2500.27.
4. Clean symbols and marks. Currency signs, footnote markers and spaces inside figures keep them as text; remove them before converting.
5. Check negative numbers and dates. Figures in brackets or with a trailing minus should come out negative, and dates should keep the right day and month order.
6. Recalculate the totals. Add up every column and subtotal in Excel and compare the results with the totals printed in the PDF. It is the quickest way to catch a figure that was lost, duplicated or misread.
7. For scans, check digit by digit. Recognition errors look like real numbers – a misread 8 or 5 changes a value without breaking anything. Our guide to why OCR makes mistakes explains which characters get confused and why.

When DIY Stops Making Sense

Most guides on how to convert PDF to Excel stop at the export button. For a one-page price list, that is enough. The work outgrows a do-it-yourself job when:

• The PDFs are scans of financial documents. One misread digit in a statement or an invoice can cost more than the conversion itself.
• There are many files with different layouts. A Power Query set-up pays off for one repeating layout, not for dozens of different ones.
• The tables are complex. Merged headers, wrapped cells, subtotals and tables that break across pages multiply the clean-up.
• The files mix number formats. Documents from several countries bring different separators, date formats and currencies into one spreadsheet.
• The deadline is fixed. Verification takes time, and it is the step people skip when they are late.

None of these makes DIY wrong. They mark the point where checking the numbers, not extracting them, becomes the real job. When the PDF holds text rather than tables, our guide on how to convert PDF to Word follows the same logic.

Frequently Asked Questions

Knowing how to convert PDF to Excel comes down to two decisions: which method fits the PDF you have, and how carefully you check the result. The tools have improved – Excel can read PDF tables, Acrobat lets you set separators, and recognition works on pictures. What none of them can do is guarantee that every figure matches the original. That check is yours, or ours.