How to Convert a Bank Statement PDF to Excel

The short answer

Check online banking for a CSV or Excel download on the same screen as the statements. Most banks offer one for recent months, and it opens in Excel with no conversion at all.

If you only have the PDF, there are three routes: Excel's own Get Data from PDF, which handles some statements well; a PDF editor's export to spreadsheet; or a converter built for bank statements. Whichever you use, finish by checking that the opening balance plus every row equals the closing balance printed on the statement.

A scanned statement is a picture of a page with no text inside it. Only a method that reads the page as an image can do anything with it, and copy and paste cannot.

Why a PDF statement is hard to get into Excel

A PDF does not contain a table. It contains pieces of text placed at positions on a page, and the columns you see are only a result of where those pieces happen to sit. Anything that turns a PDF into rows has to guess which pieces belong together.

Bank statements make that guess harder than most documents:

• Descriptions wrap onto a second line, which a naive reader turns into a second transaction with no amount.
• Every page repeats its headers, and often a "balance carried forward" line that is not a transaction at all.
• Debits and credits sit in separate columns, sometimes with no minus signs, so a misplaced column turns money in into money out.
• Dates often have no year, because the year is printed once at the top.
• Amounts carry thousands separators and currency symbols, which turn them into text that will not add up.

Route one: download the export instead

Before converting anything, look under Statements, Documents or Download transactions in online banking. Many banks offer CSV, Excel or a format for accounting software for at least the last few months. That file holds the same transactions as the PDF, already split into columns.

The limits are history and availability. Exports often stop at 90 days or a year, small banks may offer none, and a closed account offers nothing at all. That is when the PDF becomes the only source.

Route two: Excel's Get Data from PDF

Microsoft 365 Excel on Windows can read tables out of a PDF directly. If you are on a Mac or an older version, look in the same menu: if the option is missing, your version does not have it.

1. 1Go to the Data tab, then Get Data, then From File, then From PDF.
2. 2Pick the statement. Excel lists every table and page it found.
3. 3Select a table to preview it. Statements often show one table per page, so you may need several.
4. 4Select Transform Data to tidy columns, or Load to put it straight into a sheet.

It works best on statements with ruled tables and one line per transaction. It struggles with wrapped descriptions and split debit and credit columns, and it cannot read scans. Combining several pages into one list takes some Power Query work, which is quick once you know it and slow the first time.

Route three: export from a PDF editor

Adobe Acrobat's paid version can export a PDF to an Excel workbook, and some other PDF editors offer the same. Word can also open a PDF and turn it into an editable document, from which a table can be copied into Excel.

These keep the look of the page rather than the logic of a statement. Expect merged cells, page headers in the middle of the data, and amounts stored as text. On a statement of a page or two, ten minutes of cleanup fixes that. On a year of statements, it is a day.

Copy and paste is the version of this route everyone tries first. It works on some statements and puts every transaction into a single column on others. It is worth one attempt and not worth fighting.

Route four: a converter built for statements

A bank-statement converter reads the page knowing what a statement looks like: that a wrapped line belongs to the transaction above it, that a carried-forward balance is not a payment, that the year at the top applies to every date below. Good ones read scans as well, and check the result against the balances.

Two questions are worth asking of any of them. Where does the file go, since you are handing over a full record of somebody's finances? And does it check its own output against the statement's balances, or leave that to you?

Fix the columns before you use them

Whichever route you took, check three things in Excel before you sort, total or send anything:

• Dates are dates. Click one: if the formula bar shows text, or the cell is left-aligned, Excel is not treating it as a date, and sorting will order it alphabetically. Watch for day and month swapped in UK and European statements.
• Amounts are numbers. A total of zero, or a cell that is left-aligned, means text. Remove currency symbols and thousands separators, and turn amounts shown in brackets into negatives.
• Money out is negative. If the statement has separate debit and credit columns, combine them into one amount column with money out as a minus, so a single sum gives the net movement.

The check that proves nothing went missing

Every method above can drop a row, double one, or misread an amount, and the result looks just as tidy either way. The statement gives you the means to check, because it prints the answer: the opening balance and the closing balance.

1. 1Sum the amount column, with money out as negative.
2. 2Add that sum to the opening balance printed on the statement.
3. 3Compare the result to the closing balance printed on the statement.

If they match to the cent, every transaction came across. If they differ, the size of the difference is the clue: an amount that matches one transaction means it was dropped or doubled, and a difference that is a multiple of nine often means two digits were swapped. If the statement has a running balance column, the first row where the running balance stops following from the amounts is where to look.

Do it for every statement, not once for the batch. A batch total can match while one month is missing a payment and another has it twice.

Many statements at once

A year of monthly statements is twelve conversions, twelve checks and one combined list. Keep a column for the statement period so any row can be traced back to its page, and keep the original PDFs: the converted sheet is a working copy, and the statement is the record. If the statements are for a backlog of books, catch-up bookkeeping covers the order to work in, and how to reconcile a bank statement covers what comes next.

Frequently asked questions

Can Excel open a bank statement PDF directly? Microsoft 365 Excel on Windows can, through Data, Get Data, From File, From PDF. It works on many text-based statements, struggles with wrapped descriptions and split debit and credit columns, and cannot read scans.

How do I convert a scanned bank statement to Excel? It needs a method that reads the page as an image, because a scan has no text inside it. Copy and paste and Excel's PDF import will not work. A converter that reads scans will, and its result is worth checking against the statement's balances.

Is it safe to upload bank statements to an online converter? Ask where the file goes and whether it is kept. A statement holds your name, account number and every payment you made. Prefer a service that says plainly how long it holds the file, and avoid one that keeps it without saying so.

Why are the amounts not adding up in Excel? They are probably stored as text, because of currency symbols, thousands separators or brackets for negatives. Remove those and convert the column to numbers, and the totals will work.

How do I know the conversion did not miss a transaction? Add the sum of all amounts to the opening balance and compare it to the closing balance on the statement. A match to the cent means everything came across. Any difference is the size of what is missing or doubled.

Can I convert a bank statement PDF to CSV instead of Excel? Yes. CSV is the better choice if the next step is accounting software, because upload screens take it more readily than a workbook. The PDF to CSV converter does that, with the same balance check.