How to Convert a Bank Statement to Excel (Step-by-Step)

Most banks hand you a PDF, but accounting, budgeting, and reconciliation all happen in a spreadsheet. This guide covers three ways to get the transactions out of a PDF statement and into Excel, and when each one makes sense.

Option 1: Type it in by hand

For a single short statement, manual entry is the lowest-tech option: open the PDF beside a blank workbook and key in each row. It needs no tools, but it is slow and error-prone — a transposed digit in a balance column is easy to make and hard to find later.

Option 2: Copy and paste from the PDF

If the PDF has a real text layer (not a scan), you can sometimes select the transaction table and paste it into Excel. Results vary: columns often collapse into a single cell, dates and amounts merge, and multi-line descriptions break the row alignment. Use Data → Text to Columns to split the pasted text, then fix the rows by hand.

When copy-paste fails

Scanned or image-only statements have no selectable text, so copy-paste returns nothing. Those need optical character recognition (OCR) to read the numbers off the page.

Option 3: Automated extraction

A dedicated converter reads the statement — including scanned pages — detects the transaction table, and exports clean rows to Excel or CSV. This is the fastest route for multiple statements or for any workflow you repeat monthly, because the column mapping is handled for you. Try it with the free bank statement converter.

Pick a format: XLSX vs CSV

Export to XLSX when you want formatting, formulas, or multiple sheets. Export to CSV when you need to import into accounting software. Either way, once the data is structured you can move on to bank reconciliation.

Before you start: get the PDF

You will need the statement PDF first. If you bank with Chase, see how to download your Chase statement.