Wheelbarrowreport tools

How to convert a PDF bank statement to Excel

The bookkeeper, the accountant or the loan officer wants the transactions in a spreadsheet, and the bank gave you a PDF. Here's the shortcut most people miss, the manual methods, and how to check nothing went missing.

Updated October 29, 2026 ยท 7-minute read

Before anything: check for a download

Most banks and card issuers let you download transactions as a spreadsheet from online banking, even when the statement itself is a PDF. Look in the account's activity or transactions page for Download or Export, and pick CSV or Excel. Choose the statement's date range.

A CSV opens in Excel with every transaction already in columns, so if your bank offers it, use it. Some banks only keep a limited history online, which is where the PDFs come in: older statements, or statements a customer or lender sent you.

Is the statement real text or a scan?

Try to highlight a transaction with your mouse. Statements downloaded from online banking almost always have real text. A paper statement that was scanned or photographed is a picture, and needs text recognition (OCR) first. With money, check every total afterward: OCR misreads 8s and 3s, and 1s and 7s.

1. Copy and paste

Good for: one or two pages, once.

  1. Select the transactions on one page and copy them.
  2. Paste into Excel. If each line lands in one cell, select the column and use Data > Text to Columns. See how to split a PDF paste into columns for the details.
  3. Repeat for each page, skipping the page headers, the account summary and the running "balance forward" lines.

Where it breaks: descriptions. A card purchase often takes two or three lines on the statement (merchant, city, reference number), and each line pastes as its own row. Those have to be joined back by hand.

2. Excel's Get Data from PDF

Good for: several pages, when the transactions are laid out as a clear table.

  1. In Excel for Microsoft 365 on Windows, go to Data > Get Data > From File > From PDF and pick the statement.
  2. In the Navigator, click through the Table items until you find the transactions, then click Transform Data.
  3. Promote the headers, filter out the repeated header rows and the summary lines, and Close & Load.

Statements are harder than most reports for Power Query: deposits and withdrawals are often in separate sections or separate columns, and the multi-line descriptions come through as extra rows. The Power Query cleanup guide covers joining wrapped rows back together.

Fix the negative numbers

Statements show money going out in different ways, and Excel won't treat any of them as a negative number until you convert them:

  • Trailing minus (45.20-): select the column, use Data > Text to Columns, click Next to the last step, choose Advanced and tick Trailing minus for negative numbers.
  • Parentheses ((45.20)): Excel usually converts these on its own when you paste. If they stay as text, use this in a helper column:
=IF(LEFT(A2)="(", -VALUE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")), VALUE(A2))
  • Separate Withdrawals and Deposits columns: add an Amount column with =[@Deposits]-[@Withdrawals], with blanks counted as zero.
  • "CR" and "DR" after the amount: on credit card statements CR usually means a payment or refund. Strip the letters with SUBSTITUTE and flip the sign of one kind.

Check that it balances

This step catches the row that didn't paste or the amount that came in as text:

Opening balance + SUM(Amount) = Closing balance

Take the opening and closing balances from the statement's summary box. If they don't match, compare the total of deposits and the total of withdrawals with the summary box separately: whichever one is off tells you where to look. Also check the transaction count if the statement prints one.

A word on online converters

A bank statement has your account number, balances and every place you spent money. Before uploading one to a converter site, check who runs it and what it keeps. The methods above all run in Excel on your own computer.

Doing it every month, or for many accounts

If you convert statements regularly, for several accounts, for clients or for every month of a loan application, the cleanup above is the same every time: join the wrapped descriptions, fix the signs, check the balance.

Wheelbarrow can learn that once. Drop in a statement, describe what you want, for example "one row per transaction, one amount column with money out negative, a tab per month, totals by payee", and see it built from your own file before you pay. The tool you keep runs on your PC, even offline, and turns next month's statement into the finished workbook in seconds.

Converting the same kind of statement every month? See it built from your own file first. Try it with my files

Questions

Can I download my bank statement as Excel instead of PDF?

Usually, yes. Most online banking sites let you download transactions as CSV or Excel from the account activity page, even if the statement itself is a PDF. Older history may only be available as PDF statements.

How do I convert a PDF bank statement to Excel?

For a page or two, copy and paste, then use Data > Text to Columns. For longer statements, Excel for Microsoft 365 on Windows can import tables with Data > Get Data > From File > From PDF. Then fix the negative numbers and check the totals against the statement.

How do I make trailing minus numbers negative in Excel?

Select the column, choose Data > Text to Columns, go to the last step, click Advanced and tick Trailing minus for negative numbers.

How do I check my converted statement is complete?

Add the opening balance to the sum of all amounts and compare it with the closing balance on the statement. If it's off, compare total deposits and total withdrawals with the statement's summary separately to find the gap.

More from Wheelbarrow