How to convert a bank statement PDF to Excel: 3 methods compared
Updated October 2026
Bank statements are made to be read, not analyzed. Getting one into Excel sounds simple, but statements break spreadsheets in predictable ways: descriptions wrap onto a second line, debits and credits sit in separate columns, the date is printed only once per day, and every page repeats its header. Here are the three practical methods and where each one falls down.
Method 1: copy and paste
Open the PDF, select the transaction table, copy it and paste it into Excel.
- Works for: a single page with a handful of transactions.
- Problems: everything often lands in one column, numbers paste as text (so SUM returns 0), wrapped descriptions become extra rows, and page headers and footers get mixed in.
- Fixing it: Data, then Text to Columns, then convert text to numbers, then delete the junk rows. It's manageable for one page but slow for a year of statements.
Method 2: Excel's "Get Data from PDF"
Excel for Microsoft 365 on Windows can import tables from a PDF: Data, then Get Data, then From File, then From PDF. Power Query lists the tables it found on each page.
- Works for: statements with clear table borders.
- Problems: each page usually comes in as a separate table that you have to append, wrapped descriptions still split into rows, and many statements aren't detected as tables at all. It isn't available in every Excel edition.
Method 3: a bank statement converter
A converter built for statements understands their structure: it joins wrapped descriptions, carries the date down to same-day rows, merges pages and outputs real numbers.
- Works for: multi-page statements, batches, and anything going into accounting software.
- What to check: whether the tool verifies its output. A converter that misreads one amount gives you a tidy spreadsheet that's quietly wrong.
Side by side
| Copy and paste | Excel Get Data | Converter | |
|---|---|---|---|
| Multi-page statements | Manual | Append each page | Automatic |
| Wrapped descriptions | Split into rows | Split into rows | Joined |
| Amounts as numbers | Often text | Usually | Yes |
| Checks the result | No | No | Unclip: every row against the printed balance |
| Time for a 5-page statement | 20–40 min | 10–20 min | Under a minute |
Always check against the balance
Whichever method you use, add a running-balance column in Excel (previous balance plus amount) and compare it with the balance printed on the statement. Where they first disagree is where a row was missed or misread. Unclip does this check for you on every row and flags the exact line if something doesn't add up.