How to Convert a PDF Bank Statement to Excel (Free and Paid Ways)
PDF statements are made for reading, not for accounting. When you need the transactions in Excel — to reconcile, categorise or import into QuickBooks — retyping them is slow and error-prone. Here are the options, from free and fastest to paid and automatic, and a check you should run whatever method you choose.
Before you convert: can you skip the PDF?
The best PDF conversion is the one you don’t need. Most online banks let you download the same period as CSV, Excel, QFX or QBO, usually under Download transactions, Export or Activity. These files contain exactly the bank’s data, with no conversion errors.
- Got a CSV or Excel file? Use it directly, or convert CSV to QBO for QuickBooks.
- Got a QFX or QBO file? Open it as Excel.
PDF conversion is really for cases where the bank only keeps older months as PDF, the account is closed, or a client sent you PDFs.
Option 1: Excel’s built-in PDF import (free with Microsoft 365)
Excel for Microsoft 365 on Windows can read tables from PDFs:
- Data → Get Data → From File → From PDF, and select the statement.
- In the Navigator, preview the detected tables (each page is often a separate table) and pick the one with transactions.
- Click Transform Data to remove header rows, or Load to put it straight into a sheet.
It works well on clean, text-based statements with a simple table. Multi-line descriptions, running balances in odd places and statements that change layout between pages often need manual fixing. This feature is not available in Excel for Mac or Excel on the web.
Option 2: Adobe Acrobat (paid)
Acrobat Pro’s Export PDF → Spreadsheet → Microsoft Excel Workbook turns every page into a worksheet. It keeps the visual layout, so expect merged cells, headers and footers in the middle of your data. Good for one-off conversions you will clean by hand.
Option 3: copy and paste (free, small statements only)
For a statement with a dozen transactions, selecting the table in a PDF viewer and pasting into Excel can be enough. Use Data → Text to Columns to split pasted lines into date, description and amount. Beyond one page this becomes slower than the other options.
Option 4: a dedicated bank statement converter
Specialised converters read the statement layout, extract date, description and amount for every transaction, join multi-line descriptions and check that the numbers add up. They are the fastest route for bookkeepers who receive PDFs every month.
We are building this into ConvertQBO Pro: PDF statements to Excel, CSV or QBO with automatic balance reconciliation. Join the waitlist and tell us which bank you need first.
Always reconcile the result
Whatever method you use, check the conversion before you rely on it:
- Take the opening balance from the statement.
- Add all deposits and subtract all withdrawals from your spreadsheet.
- The result must equal the statement’s closing balance — to the cent.
If it doesn’t, look for a missed page, a duplicated header row turned into a “transaction”, or an amount that lost its minus sign. Also compare the number of transactions with the statement if it shows a count.
Getting the spreadsheet into QuickBooks
Once you have a clean table with Date, Description, Amount (money out negative), save it as CSV and either upload it to QuickBooks Online directly (guide) or convert it to a QBO file for QuickBooks Desktop. QBO files carry a unique ID per transaction, which protects you from duplicates if you import twice.