Statement to Excel

How to convert a bank statement PDF to Excel (including scans)

Updated November 18, 2026 · Ruslan Vorobev, founder of Statement to Excel

Bank statement PDFs are made to be read, not edited. To work with the transactions in Excel, every row needs its date, description and amount in separate cells, withdrawals need to be negative, and nothing can be missing. Here are four ways to get there, from least to most work.

1. Download a CSV or Excel file from online banking

Most banks let you export recent transactions as CSV, and some as Excel. If the months you need are available, this is the cleanest source. The catch: downloads often cover only a limited history, and old or closed accounts, or statements a client sends you, usually exist only as PDFs.

2. Copy and paste from the PDF

Fine for a handful of rows. On a full statement you will usually get columns collapsed into one cell, amounts pasted as text, withdrawals without a minus sign, and descriptions that wrap onto a second line turning into extra rows. Budget time to clean it up.

3. Excel's Get Data from PDF

Excel for Microsoft 365 on Windows can import tables from a PDF: Data, Get Data, From File, From PDF. It works on PDFs with selectable text and simple tables. Limits worth knowing:

  • It doesn't read scanned statements (images of paper pages).
  • Each page often comes in as a separate table, so a multi-page statement has to be combined and cleaned.
  • It doesn't know what a statement is: no debit and credit signs, and no check against the balance.
  • On Excel for Mac the From PDF option is often not available.

4. Use a bank statement converter

A converter built for statements reads the transaction table on every page, including scans, and gives you a ready file. Statement to Excel produces an Excel workbook with one sheet per statement (Date, Description, Amount, Debit, Credit, Balance) plus a Summary sheet, and highlights rows that need a second look. It also checks every statement against its opening and closing balance, and exports CSV for QuickBooks Online and Xero. The first 10 pages are free, without signup.

Scanned paper statements

Scan at 300 dpi, keep the page straight, and include the whole page so the opening and closing balance are on it. Flat, evenly lit scans read better than phone photos taken at an angle. Whatever tool you use, check the totals afterwards: a misread digit is the typical scan error.

Always check the result

Whichever route you take, confirm that the opening balance plus deposits minus withdrawals equals the closing balance. Here is how to check it and find the row that's off.

Have a PDF statement to convert?

Excel, QuickBooks or Xero CSV in about 30 seconds, checked against the statement's balances. The first 10 pages are free, no signup.

Convert a statement

Sources

More guides