Skip to content

Convert a bank statement PDF to Excel

A statement PDF is a picture of a table, not a table. Getting it into Excel means turning those printed rows back into columns — which takes one upload, not a retyping session.

The four steps

  1. Download the statement from your bank

    Open your bank account, pick the statement period, and download it as a PDF. Most banks also offer CSV, which converts just as well.

  2. Open the converter

    Go to the bank statement to Excel converter and drop the file in.

  3. Leave the format on Excel

    Excel is preselected on that page — nothing else to choose.

  4. Open the workbook

    Download the .xlsx and open it in Excel, Numbers, or Google Sheets. One row per transaction.

The converter itself is on bank statement to Excel.

Where it usually goes wrong

  • A description that wraps. The second line of a payee is still part of the same transaction. Tools that read by page position split it into two rows, or push the amount onto the next line.
  • A scanned statement. A photo or a scan is read with OCR, which is noticeably less reliable than a PDF your bank generated. Review those rows before you rely on them.
  • A locked PDF. A statement that asks for a password has to be unlocked before anything can read it — unlock bank statement PDF.
  • Totals rows. A statement usually ends with totals that are not transactions. Check the last rows of the sheet before you sum a column.

Frequently asked questions

Can Excel open a bank statement PDF directly?

No. Excel can import data from a PDF, but it reads the page by layout, so wrapped descriptions become extra rows and amounts land in the wrong column. Converting first gives a file with real columns.

How long does it take?

One file, one conversion. The work is in finding the statement, not in converting it.

The amounts came out as text, not numbers

Check the column formatting: a leading currency symbol makes some spreadsheets treat a value as text. Format the column as a number and the totals will calculate.

My statement is password-protected

Unlock it first, then convert the unlocked PDF.

Related