Convert Bank Statement PDF to Excel: A Step-by-Step Guide

Updated 3 November 2026

The quickest way to convert a bank statement PDF to Excel is to run it through a converter that rebuilds the transaction table as rows and columns, then check the result against the statement’s running balance. You can also try copy-paste, Excel’s own PDF import or retyping, but on real statements those methods tend to scramble the columns. This guide covers both routes and shows you how to tidy up the spreadsheet once it’s in Excel.

What you need before you start

• The original PDF from online banking. A statement downloaded from your bank’s website or app is usually a text-based PDF, which converts most accurately. A scan or phone photo also works but needs OCR (see our guide to converting a scanned bank statement).
• The password, if the file has one. Some banks password-protect statement PDFs.
• A spreadsheet app such as Excel or Google Sheets to open the result.

Method 1: Use a bank statement converter (recommended)

Our free bank statement converter is built for exactly this job. It runs entirely in your browser, so the PDF is never uploaded to a server; the privacy page explains how. It’s designed to work with statements from many banks (see the list of banks by country), though an unusual layout may need a small manual fix.

1. Add your statement. Drag the PDF onto the page or click to choose it. You can add several statements at once.
2. Enter the password if prompted. It’s used locally to open the file and isn’t sent anywhere.
3. Turn on OCR only for scans. For a normal downloaded statement, leave it off: text extraction is faster and more precise.
4. Review the preview. Transactions are laid out as Date, Description, Debit (money out), Credit (money in), a signed Amount column (money out negative, money in positive) and Balance. The converter detects whether dates are DD/MM or MM/DD and fills in missing years from the statement period.
5. Check the balance flags. The tool re-adds the running balance row by row and highlights any row that doesn’t reconcile. A flagged row usually means a transaction was missed or a figure was misread.
6. Fix anything that’s off. Click a cell to correct it, or delete rows you don’t need, such as a summary line that slipped in.
7. Choose a date format and export. Pick Excel (.xlsx). If you added several statements, you can combine them into one spreadsheet. Working in Google Sheets? Use copy to clipboard and paste straight in.

The bank statement to Excel page has more on the Excel output. If another program needs a plain file instead, the converter also exports CSV, JSON and OFX.

Method 2: Copy and paste from the PDF

Opening the statement in a PDF reader, selecting the transactions and pasting into Excel looks like the obvious shortcut. On a one-page statement with a very simple layout, it occasionally works. More often you’ll see:

• every line landing in column A, with date, description and amount run together;
• descriptions that wrap onto two lines turning into two separate rows;
• debits and credits ending up in the same column, so you can’t tell money in from money out;
• page headers, footers and “balance brought forward” lines mixed in with transactions.

You can rescue some of it with Data > Text to Columns, but statements rarely use consistent spacing, so you end up fixing rows one at a time.

Method 3: Excel’s Get Data > From PDF

Microsoft 365 versions of Excel for Windows include a PDF connector, usually under Data > Get Data > From File > From PDF. Menu labels can vary by version and region. It opens Power Query’s Navigator, which lists the tables and pages it found; you pick one, then load or transform it.

It’s a real improvement over copy-paste, but bank statements trip it up in predictable ways:

• Each page becomes a separate table, so a six-page statement needs appending and its repeated headers removing.
• Multi-line descriptions split into extra rows with blank dates and amounts.
• Columns shift between pages when the layout changes, for example when page one has a summary box.
• Amounts arrive as text, complete with currency symbols or CR/DR markers.

If you’re comfortable in Power Query you can build clean-up steps, but they tend to be specific to one bank’s layout and break when it changes.

Method 4: Retype the transactions

For a handful of transactions, typing them in is fine. For a month of business activity it’s slow, and typos are easy to make and hard to spot: 54.10 typed as 45.10 won’t look wrong at a glance. If you do retype, add the running balance check shown below so errors surface immediately.

Why PDFs are hard to turn into spreadsheets

A PDF is designed to look identical everywhere, not to store data. Inside, a statement is a collection of text fragments, each with coordinates on the page. There are no cells, rows or columns, just words that happen to line up visually. Every conversion method has to infer the table from those positions, which is why ruled lines, wrapped text and page breaks cause so much trouble. A dedicated converter can also use the running balance to confirm it has read each row correctly; generic tools only have the layout to go on.

Cleaning up the result in Excel

Whichever method you use, spend a few minutes on these checks before relying on the data.

Make sure dates are real dates

Change the date column’s format to a long date. If the values don’t change, Excel is treating them as text, which won’t sort or filter properly. A quick test is =ISNUMBER(A2), which returns TRUE for a real date. Also confirm that day and month haven’t swapped by comparing a few rows with the PDF.

Make sure amounts are numbers

Small green triangles in cell corners, or amounts aligned to the left, suggest numbers stored as text. Remove currency symbols and thousands separators, then convert with Data > Text to Columns > Finish or =VALUE(C2). Watch for formats like 120.00-, (120.00) or 120.00 DR, which all mean money out.

Remove rows that aren’t transactions

Delete opening and closing balance lines, brought forward and carried forward rows, page subtotals and repeated headers. Left in, they distort your totals.

Add a running balance check

Put the statement’s opening balance in cell J1. Then, assuming the signed amount is in column E, enter this in G2 and fill it down:

=$J$1+SUM($E$2:E2)

Compare it with the Balance column. Where the two first diverge, something on or just above that row is wrong. Our guide on how to reconcile a bank statement in Excel goes further, with monthly totals and ledger matching.

Format it as a table

Press Ctrl+T to turn the range into an Excel table. You get filter buttons, banded rows and formulas that extend automatically as you add data.

Key takeaways

• Start from the original downloaded PDF whenever you can; it converts far more accurately than a scan.
• Copy-paste and Excel’s PDF import cope with simple tables but usually break on multi-page statements with wrapped descriptions.
• A converter that checks the running balance shows you which rows need attention, so you don’t have to proofread every line.
• After exporting, confirm dates and amounts are true values, remove non-transaction rows and keep a running balance check.
• Heading into accounting software rather than Excel? Our guide to bank statement file formats explains when to pick CSV or OFX instead.

Frequently asked questions

Convert a bank statement →