How to convert a bank statement PDF to Excel

Why copy-paste and "Save as Excel" usually go wrong

A PDF stores words at positions on a page, not cells in a table. When you paste it into Excel, dates end up glued to descriptions, long descriptions split into two rows, and the page header repeats on every page.

Excel's own PDF import (Data › Get Data › From PDF in Microsoft 365 for Windows) can handle a simple one-page table, but a statement usually comes out as one table per page, with wrapped lines and running balances in the wrong place. You then spend longer fixing the sheet than typing it.

Before you start: get the right file

• Download the statement from your online banking (usually under Statements or Documents) instead of scanning paper. A downloaded PDF has real text and gives the cleanest result.
• Only have paper? A scan or a clear phone photo works too — it is read from the image, so check the amounts afterwards.
• Password-protected PDF? Open it with the password, choose Print, then Save as PDF. The new copy has no password.
• One account per file. If your PDF holds a checking and a savings account, split it first.
• Longer than 100 pages or over 20 MB? Split it into smaller PDFs.

Convert it, step by step

1. On the home page, choose Excel (.xlsx) as the export format and upload the PDF — or drop several files if you have more than one month.
2. Check the page count. Nothing is charged yet, and 5 pages a day are free.
3. Choose the pages to convert and start. Progress is shown page by page; you can leave the page while it runs.
4. Open the review and look at the balance check first, then any flagged rows.
5. Fix or exclude rows if needed — the original value is always kept.
6. Export and download the .xlsx file. Exporting again, or in another format, doesn't use more pages.

Putting several months in one spreadsheet

For a tax year or a loan application you usually need many statements. Use Convert and combine multiple files: upload up to 20 statements, review each one on its own, then export them together. The combined file has one Transactions sheet with every row, a Source file column so you can tell the statements apart, and a flag on rows that appear in more than one file.

How to check the spreadsheet is complete

The balance check adds every transaction to the opening balance and compares the result with the closing balance printed on the statement. Passed means the money in and money out add up exactly. Difference found shows the gap and highlights the rows where the running balance stops matching — usually a missed line or an amount read with the wrong sign.

• Compare each flagged amount with the source page shown next to it.
• Confirm or exclude possible duplicates — real repeat payments are common, so nothing is removed automatically.
• Check dates marked as outside the statement period.
• If the statement has no printed balances, the check shows Not available; skim the rows against the PDF instead.

Working with the data in Excel

• Money out, Money in and Balance are number cells, so SUM, SUMIFS and pivot tables work straight away.
• Dates are written as YYYY-MM-DD text so they never swap day and month. To turn them into Excel dates, select the Date column and use Data › Text to Columns › Finish.
• Need one signed amount column instead of two? Choose Amount in the export options — money out becomes negative.
• The Summary sheet records which pages were converted and the result of the balance check.

When nothing converts

• "No transactions were found" on a page usually means it is a cover, summary or notice page. Those pages are free.
• A single transfer receipt, an invoice or a letter from the bank isn't a statement, so there are no rows to extract.
• Very blurry, cropped or handwritten pages may not be readable. Try a clearer scan or the downloaded PDF.
• Still wrong? Send us the request ID from the result — we look at it and return the pages if the result was unusable.

Is it safe to upload a bank statement?

You never share a bank login. Files are processed automatically, support staff can't open them without your permission, and they are deleted 1 hour after upload for guests or 24 hours for account users. The Security page lists exactly what is kept and for how long.