How to convert a bank statement PDF to Excel (4 ways)

The quickest way to convert a bank statement PDF to Excel is a bank statement converter: upload the PDF, scan or photo, and download a spreadsheet with dates, descriptions, debits, credits and balances in separate columns. If you'd rather not upload anything, Excel can import text-based PDFs itself. Whichever you use, check the running balance afterwards so you know nothing is missing.

The four ways, compared

Times are rough estimates for a typical three-page statement.

1. Use Excel's Get Data from PDF

1. In Excel for Microsoft 365 (Windows), open a blank workbook.
2. Go to Data, then Get Data, then From File, then From PDF, and choose your statement.
3. In the Navigator, pick the table that holds the transactions. Statements usually have one table per page, so select each page's table.
4. Choose Transform Data to fix column types (dates as dates, amounts as numbers), then Close & Load.
5. Append the per-page tables into one list if your statement has several pages.

This only works when the PDF contains real text. If you can't select the words with your mouse, it's a scan and Excel will find nothing.

2. Copy and paste

Select the transaction rows in your PDF viewer, copy, and paste into Excel. Then use Data, Text to Columns to split dates, descriptions and amounts. It's free and needs nothing installed, but descriptions that wrap onto two lines and page headers make it slow, and it's easy to lose a row at a page break.

3. Google Docs, then Google Sheets

Upload the PDF to Google Drive, right-click it and choose Open with, then Google Docs. Google runs OCR on scanned PDFs. Copy the text into Google Sheets and split it into columns with Data, Split text to columns. It can rescue a scan in a pinch, but check every amount: OCR confuses 1 and 7, and 5 and 6.

4. Use a bank statement converter

A converter reads the statement for you, including scans and phone photos, and gives you a clean Excel or CSV file. With StatementPanda you drop the file in, the transactions are extracted, and every running balance is checked against the statement before you download. The first 5 pages are free without signing up.

How to check nothing is missing

However you converted the statement, prove the rows are complete by rebuilding the running balance. Put your data in columns A to E like this:

1. In F3, enter =E2+D3-C3: the previous row's printed balance, plus this row's credit, minus its debit.
2. In G3, enter =IF(ROUND(F3-E3,2)=0,"OK","CHECK") to compare the rebuilt balance with the printed one.
3. Fill both formulas down to the last row.
4. Filter column G for CHECK. Each one marks a row where an amount was misread, a row is missing just above, or a sign is flipped.

Because each row starts from the previous printed balance, one mistake only flags its own row instead of every row after it. If your statement has no running balance column, compare the opening balance plus all credits minus all debits with the closing balance instead: =E2+SUM(D:D)-SUM(C:C).

This is the same check StatementPanda runs automatically on every row, so you see the flagged row before you download.