How to convert a bank statement PDF to Excel (4 methods compared)

Every bank lets you download statements as PDF. Almost none let you download the older ones as CSV. So sooner or later — for a tax return, a loan application, a client's year-end, a visa — you need the transactions out of a PDF and into Excel.

There are four realistic ways to do it. Here is what each one actually produces, based on the statements we see every day, and how to check the result before you trust it.

Method 1: Copy and paste

Open the PDF, select the table, paste into Excel.

What happens: the text lands in one column, or the columns land in the wrong order, or the description of each transaction wraps onto a second line and pushes the next amount down a row. Negative amounts sometimes lose their sign. Dates paste as text, not dates, so you cannot sort them.

When it's fine: a single page with short descriptions and no multi-line rows. You then spend ten minutes with Text-to-Columns and Find & Replace.

When it fails: anything scanned (nothing to copy), anything with two-line descriptions, anything longer than a couple of pages.

Method 2: Excel's built-in PDF import

In Excel 365: Data → Get Data → From File → From PDF. Power Query lists the tables it detects on each page; you pick one and load it.

What happens: on clean, digitally generated statements this works surprisingly well for one page. But Power Query treats every page as a separate table, so a 12-page statement becomes 12 queries to append by hand. Column headers that repeat on each page become data rows. Multi-line descriptions are split into separate rows with blank amounts. Amounts with thousands separators sometimes import as text.

When it's fine: one or two pages from a bank with a rigid table layout (many US banks).

When it fails: scanned statements (Power Query reads no text from an image), statements where debit and credit share one column with a sign or a "CR" suffix, statements listed newest-first, most UK and European layouts with running text.

Method 3: Adobe Acrobat "Export to Excel"

Acrobat Pro can export a PDF to .xlsx, and Acrobat's OCR can read scanned pages first.

What happens: you get a workbook that looks like the statement — including the logo, the address block and the footer — with every visual line mapped to a row. The transactions are in there, but surrounded by everything else, often merged across cells. Clean-up is manual and takes longer than the export.

When it's fine: you have Acrobat Pro already and one short statement.

When it fails: anything you need to do more than once; anything you need to reconcile.

Method 4: A dedicated bank statement converter

Tools built only for statements — Rowvert is one — do three things the general tools don't:

1. Detect the column roles. Date, description, money out, money in, balance — whatever the bank calls them ("Withdrawals", "Paid out", "Debit", "DR") and whichever order they come in.
2. Rebuild rows from layout, not from lines. A description that wraps onto three lines stays one transaction. A statement printed newest-first is kept in that order.
3. Reconcile. Opening balance + credits − debits must equal the closing balance printed on the statement. If it doesn't, the rows that break the running balance are flagged instead of being silently imported.

Scanned statements go through OCR automatically; rows read from an image are marked so you know which ones to double-check.

What you get: one row per transaction, real Excel dates and numbers, a Summary sheet with the reconciliation result, and CSV variants for QuickBooks and Xero.

What it costs: with Rowvert, 1 page a day is free without an account and 5 a day with a free account; paid plans start at $15 a month. See the pricing page.

How to check any conversion (whatever method you used)

Do this once per statement and you will never import a wrong number:

1. Find the opening balance and closing balance printed on the statement.
2. In Excel, sum the money-in column and the money-out column.
3. Check: opening + money in − money out = closing.
4. If it doesn't match, the difference tells you what's missing: a missing row is usually one transaction amount; a doubled row is one amount too; a sign error is twice the amount.

A dedicated converter does this for you and points at the exact row. With the other methods, do it by hand — it takes a minute and it is the only way to know the file is right.

Which method should you use?

Whatever you choose, keep the original PDF: lenders, tax authorities and immigration offices want the bank's own document, and the spreadsheet is for your analysis.

Related: Convert a Chase statement to Excel · HSBC · Bank statement to QuickBooks · Bank statement to Xero.