How to convert a PDF bank statement
to Excel.
Banks hand out statements as PDFs, but budgeting, reconciling and bookkeeping happen in spreadsheets. Here are three ways to get your transactions into Excel, and when each one makes sense.
Before you start: check the PDF
Open the statement and try to select a line of text with your cursor. If you can highlight individual words, the PDF has a text layer and every method below will work. If the whole page highlights as one image, the statement is scanned or photographed and needs OCR (text recognition) first. Password-protected statements must be unlocked, usually by opening them and saving or printing a copy without the password.
Method 1: Copy and paste
Select the transaction table in your PDF viewer, copy it, and paste it into Excel. For a statement with a handful of rows this is quick.
The catch is that PDFs store text as positioned fragments, not as a table. Pasted rows often land in a single column, descriptions that wrap onto two lines split into separate rows, and amounts arrive as text instead of numbers. Expect to use Data → Text to Columns, fix dates, and convert amounts before you can total anything. Fine for one short statement; slow and error-prone for several pages.
Method 2: Excel’s built-in PDF import
Excel for Microsoft 365 on Windows can read tables straight from a PDF: go to Data → Get Data → From File → From PDF, choose the statement, and pick the detected table in the Navigator window. You can clean it in Power Query before loading it into the sheet.
This works well when the bank’s layout produces clean, consistently detected tables. Multi-page statements often appear as one table per page that you need to append, headers can repeat, and debit and credit columns may still need combining into a signed amount. The feature isn’t available in every version of Excel.
Method 3: Use a bank statement converter
A dedicated converter is built for this exact layout problem: it finds the transaction table on every page, joins wrapped descriptions, recognises debit/credit or single-amount columns and different number formats, and outputs one clean row per transaction with real dates and numbers.
With BankPDFExport you upload the PDF, review every transaction in an editable table, and download Excel (XLSX), CSV or QuickBooks (QBO). The PDF is deleted right after conversion. There are 10 free pages every month, so a typical monthly statement costs nothing to try.
Tips for clean, trustworthy data
Always compare the totals against the statement: the sum of amounts should equal the closing balance minus the opening balance. Check that dates were read in the right order (day/month or month/day). Keep one account and one currency per file. And keep the original PDF: the spreadsheet is a working copy, the statement is your record.