How to convert a bank statement PDF to Excel

Which method should you use?

It depends on how many statements you have and whether you need the numbers to be exactly right.

Method 1: Copy and paste from the PDF

Copy and paste is fine for five or ten transactions. Beyond that, it creates more cleanup than it saves, because a PDF doesn't store a table: it stores text placed at positions on the page. When you copy it, you get lines of text, not cells.

Here is what copying gives you from a statement with separate Withdrawals and Deposits columns:

Date Description Withdrawals Deposits
09/01/2026 ATM WITHDRAWAL 1200 MAIN ST 8.01
09/03/2026 PAYROLL ACME CORP DIR DEP 2,517.28
09/05/2026 AMAZON MKTPLACE PMTS AMZN.COM/BILL WA 167.52

The $8.01 ATM withdrawal and the $2,517.28 payroll deposit look the same. The column they came from is lost, so you would have to check every row against the PDF to put the minus signs back. On a statement where descriptions wrap, it gets worse:

Sep 01 CHECK # ($79.77) $3,505.72
1043
Sep 02 COMCAST CABLE ($129.59) $3,376.13
COMM 800-COMCAST

Each transaction becomes two lines, so 35 transactions turned into 70 lines in our test. After pasting you would still need Excel's Text to Columns, a formula to rejoin the second lines, and a find-and-replace for the parentheses and dollar signs.

Method 2: Excel's built-in PDF import (Power Query)

Excel for Microsoft 365 on Windows can read tables straight from a PDF. It isn't available in Excel for Mac, and Microsoft support threads confirm the PDF connector is missing there.

1. Open Excel and go to Data → Get Data → From File → From PDF.
2. Pick your statement. The Navigator lists every table and page it found.
3. Select the transaction table on each page and choose Load, or Transform Data to clean it in Power Query first.
4. If the statement has several pages, append the page tables together in Power Query (Home → Append Queries).

What to watch for afterwards:

• Descriptions that wrap onto a second line arrive as separate rows with an empty date and amount.
• Separate withdrawal and deposit columns stay separate. Add a column like =[Deposits]-[Withdrawals] to get one signed amount.
• Amounts such as ($79.77) or 1.234,56 may load as text and need converting before you can sum them.
• Nothing tells you if a row was skipped. Compare your total with the statement summary before you rely on it.

Method 3: Use a bank statement converter

A converter reads the layout of the statement rather than copying its text, so it can tell which column a number sits in, join wrapped descriptions and keep a multi-page table in one sheet. With StatementToSheet:

1. Download the statement as a PDF from your online banking.
2. Drop it on the converter. Within seconds you see every transaction in a table.
3. Check the balance result. If the statement prints a running balance, we recompute it for every row and tell you whether all of them match.
4. Download the Excel file. Withdrawals are already negative and deposits positive, so SUM works straight away.

The balance check is the part that saves you from silent mistakes. On the 70-transaction sample statement on our home page, all 69 balance checks match. If even one row were missing or had the wrong sign, the check would fail at that row.

Can I convert a PDF bank statement to Excel for free?

Yes. Copy and paste is free, Excel's PDF import is included in Microsoft 365, and StatementToSheet converts 5 pages a day for free without an account. For a typical 2–4 page monthly statement that covers one or two statements a day.

Can I get my bank statement in Excel format directly from the bank?

Often only partly. Many banks let you export recent account activity as a CSV or spreadsheet from online banking, but older months and official monthly statements are usually only available as PDFs. That is when you need one of the methods above.

Can I convert a PDF bank statement to CSV instead?

Yes. Every conversion on StatementToSheet can be downloaded as CSV as well as Excel, with the columns Date, Description, Amount and Balance. CSV is the better choice if you are importing into accounting software such as Xero, Wave or FreshBooks. For QuickBooks there is a dedicated format; see how to convert a PDF statement to QBO.

What about scanned statements?

All three methods above need a text PDF, the kind you download from online banking. A scanned or photographed statement is an image, so copy and paste returns nothing and Excel finds no tables. StatementToSheet tells you straight away when a PDF is a scan instead of returning an empty file.