How to convert a PDF to Excel on Windows
Get an .xlsx with real numbers from Edge or Chrome, open it in Excel or LibreOffice, and know when Excel's own PDF import is enough
By Metin Ersoy · Updated November 17, 2026
What Windows can and cannot do
Windows 10 and 11 open PDFs in Microsoft Edge, which shows the page and lets you select text, but copying a table out of it gives you one long column of lines. Some Microsoft 365 versions of Excel can import a PDF directly (see below); if yours cannot, or you do not have Excel, convert the PDF into an .xlsx file first and open that.
Convert it in your browser with PDFVela
- Open PDF to Excel in Edge or Chrome.
- Click Choose a PDF file and pick the PDF, or drag it from File Explorer onto the page.
- Choose the options. Put each page on its own sheet keeps pages apart; untick it to get one long table, which is easier to sort and total. Tables only leaves out headings, addresses and notes around the tables.
- Click Convert to Excel. The pages are read on your PC, and the result tells you how many tables were found.
- Download the .xlsx file. Press Ctrl + J in Edge to find it in your downloads.
Values in aligned columns become separate cells, and amounts, quantities and percentages become real numbers you can add up straight away. The file never leaves your PC, which matters for bank statements, invoices and payroll lists.
Excel's own PDF import
If your Excel has it, Data → Get Data → From File → From PDF lists the tables Excel found in the file. Pick one and click Load. It works well on clean, digital PDFs; it cannot read scans, and tables that run across several pages often arrive as separate pieces you have to join. When the menu item is missing or the result is messy, use the browser tool above.
Open and check the result
Double-click the .xlsx to open it in Excel, or in LibreOffice Calc if you use that. Select the table and press Ctrl + T in Excel to add filters to every column. To check a total, select the column and read the Sum in the status bar at the bottom of the window, then compare it with the total printed in the PDF.
When you only need a few numbers
For two or three values, a spreadsheet file is not needed. Select them in Edge, press Ctrl + C and paste them into a cell with Ctrl + V. If you need the text rather than the table, use PDF to text.
Scanned PDFs
A PDF made with a scanner or a phone camera contains pictures of pages and no text. The converter then has nothing to put into cells and tells you so. Make the file searchable with OCR PDF first, convert the new copy, and compare the totals with the original, since OCR can misread a digit.
Common problems
A column is split in two or two columns are merged. The PDF's columns are very close together or not lined up.
Join two cells with =A2&" "&B2, or split one column with Data → Text to Columns in Excel.
Amounts stay as text. Values with a unit or a code next to them, such as 12 pcs or 125.00 DR, are kept as
text. Remove the extra letters with Ctrl + H (Find and Replace), and they become numbers.
The PDF asks for a password. Unlock it first with Unlock PDF if you know the password, then convert the unlocked copy.
For other ways to get a table into a spreadsheet, see how to copy a table from a PDF to Excel. Bank statements and invoices have their own guides: bank statement PDF to Excel and invoice PDF to Excel. On a Mac instead? Follow how to convert a PDF to Excel on a Mac.
Ready to try it? It is free and your file stays on your device.
Open PDF to Excel