How to Convert a Bank Statement PDF to Excel (3 Ways)

6 min read · Updated October 29, 2026 · By the StatementCheap team

You have a bank statement as a PDF and you need the transactions in a spreadsheet. Maybe it's for a budget, a tax return, a loan file, or a client's books. There are three realistic ways to do it. One is free and slow. One is free if you have the right version of Excel. One costs a little and saves the most time. This guide covers all three, including the problems you'll run into with each.

First: do you need the PDF at all?

Before you convert anything, sign in to your online banking and look for a transaction download. Many banks let you export recent activity as CSV or Excel, and some also offer QFX or QBO files for Quicken and QuickBooks. If the export covers the dates you need, use it. It comes straight from the bank's system, so there's nothing to misread.

Working from the PDF makes sense when:

• The export only goes back a limited number of months, but your PDF statements go back years.
• Someone sent you PDFs (a client, a borrower, the other side in a legal case) and you don't have access to the account.
• The account is closed and PDFs are all you have. See how to get statements from a closed account.
• You need data that matches the official statement exactly, page for page.

Check what kind of PDF you have

Open the PDF and try to select a line of text with your cursor. If the words highlight one by one, it's a digital PDF, the kind you download from online banking. If you can only draw a box around the page, it's a scanned image.

This matters. Copy and paste and Excel's PDF import both rely on the text stored inside the file. A scanned page that's only a picture usually gives you nothing useful. Scans need OCR (optical character recognition) first. See scanned bank statement to Excel for that case.

Also check for a password. If the PDF asks for one when it opens, remove the password first. Most PDF tools let you save an unprotected copy once you've entered it.

Method 1: Copy and paste

This works in any version of Excel, on Windows or Mac, and costs nothing.

1. Open the statement in a PDF viewer such as Adobe Acrobat Reader, Preview on a Mac, or your web browser.
2. Select the transaction rows on the first page. Start at the first date and drag to the last amount.
3. Copy, then paste into cell A1 of a blank sheet.
4. If everything lands in one column, select that column and use Data > Text to Columns. Try Delimited with space or tab first. If the columns still don't line up, try Fixed width.
5. Repeat for every page. Delete the page headers, footers and "continued on next page" lines that come along.
6. Make sure dates and amounts are real values, not text. A quick test: =ISNUMBER(C2) should return TRUE for an amount cell.

What goes wrong: descriptions that wrap onto two lines become two rows. Spaces inside descriptions split them into extra columns. Withdrawals and deposits may sit in separate columns, or carry a minus sign, or use "CR" and "DR" suffixes you'll have to handle. Some PDFs paste in a scrambled order because of how the file was built.

Good for: one or two pages with a handful of transactions. Bad for: long statements, or work you repeat every month.

Method 2: Excel's Get Data from PDF (Power Query)

Excel has a PDF connector built into Power Query. It finds tables in a PDF and loads them into a sheet. It's useful, but it isn't in every copy of Excel.

Who has it

Microsoft's own table of Power Query data sources lists the PDF connector for Microsoft 365 subscriptions on Windows. It is not listed for the standalone Office 2016 or Office 2019 versions, and it needs .NET Framework 4.5 or later. The connector list for Excel for Mac does not include PDF, so Mac users won't find this option. In Excel for the web, PDF appears only as a file type from SharePoint or OneDrive for work or school, not as a general "From PDF" import.

Steps

1. Go to Data > Get Data > From File > From PDF.
2. Pick the statement and click Open.
3. The Navigator lists what it found: tables (named like Table001) and whole pages (Page001). Click each one to preview it. The transaction tables are usually the largest.
4. If the transactions are split across several tables, tick Select multiple items, choose them, and click Transform Data.
5. In the Power Query Editor, use Append Queries to stack the tables, Use First Row as Headers, filter out junk rows, and set the Date and Amount columns to the right data types.
6. Click Close & Load.

By default, the connector tries to join similar tables that continue across consecutive pages, which helps with long statements. Microsoft's documentation also says rows that span several lines aren't always identified correctly, and suggests cleaning them up in Power Query with steps like Fill Down or Group By.

Pros: free if you already pay for Microsoft 365. Much faster than copy and paste. You can keep the query and point it at next month's statement from the same bank.

Cons: Windows and Microsoft 365 only. Each bank's layout needs its own cleanup. Multi-line descriptions and running balances often need manual fixing. Scanned PDFs don't work well. Nothing tells you whether you captured every transaction.

Method 3: A bank statement converter

A converter does one job. It reads the statement, pulls out the transactions, and gives you a clean file. A good one handles layouts from any bank, multi-line descriptions, and separate debit and credit columns without setup.

What to look for:

• A balance check. The statement prints an opening and a closing balance. A good converter adds up the extracted transactions and confirms they get from one to the other. If they don't, it should show you where the break is.
• The formats you need. Excel and CSV are standard. If the data is headed into accounting software, look for QBO for QuickBooks or a Xero-ready CSV.
• A clear privacy policy. You're uploading financial documents. Find out whether files are stored and who processes them.
• Simple pricing. Per-page pricing is the easiest to compare.

Pros: fastest by far. Works on Windows, Mac or a phone browser. No per-bank setup. Cons: costs money beyond a free tier. You're trusting a third party with the file. AI and OCR can still misread a digit, so you need to review the result. That's why the balance check matters.

Side-by-side comparison

Checks to run after any method

1. Totals match the summary. Most statements print total deposits and total withdrawals. Compare them with =SUMIFS(C:C,C:C,">0") and =SUMIFS(C:C,C:C,"<0").
2. The balance rolls forward. Opening balance plus the sum of all amounts should equal the closing balance, to the cent.
3. Dates have the right year. Many statements print dates without a year. A statement that runs from December into January is an easy place to get this wrong.
4. Signs are consistent. Money out negative and money in positive, or two separate columns, but not a mix.
5. No leftovers. Page headers, "balance forward" lines and subtotals shouldn't be in the data.

Our guide to reconciling a bank statement in Excel has the exact formulas, including one that finds the first row where the balance breaks.

Which method should you use?

If your bank offers a CSV export for the period you need, use that and skip the PDF. If you have one short statement, copy and paste is fine. If you're on Windows with Microsoft 365 and you process the same bank's statements every month, Power Query is worth learning. For anything else, especially many statements from different banks, a converter will save hours.

Try it on your own statement

StatementCheap converts PDF bank and credit card statements to Excel, CSV, QBO, Xero CSV and OFX. Every conversion is checked against the statement's own opening and closing balances, so you know right away if something is off. You get 5 free pages a day with a free account: just an email, no card. After that, a 150-page pack is $6 and monthly plans start at $9. Files are processed in memory and not stored. Convert a statement now, read more about bank statement to Excel, or see pricing.