Guide6 min read
How to convert a bank statement PDF to Excel
Banks usually send statements as PDF, but budgets, tax returns and loan applications need the numbers in a spreadsheet. Here are three ways to move them, from fastest to slowest, and how to make sure nothing was lost.
Before you start: does your PDF contain text?
Open the statement and try to select a word with the mouse. If you can, the PDF contains real text and all three ways below work. If the whole page selects like a picture, it is a scan or a photo, and the text has to be recognised first.
Way 1: use a statement converter
A statement converter understands what a statement is: dates, descriptions, money in, money out and the running balance. With Tidysheet:
- Open the bank statement to Excel converter.
- Drag your PDF onto the page. If it asks for a password, type it; it is used on your computer only.
- Look at the banner above the preview. Green means every running balance on the statement adds up.
- Press “Download Excel”.
Each transaction becomes one row with a real date and real numbers. The file also contains a Check column with a live formula and a Summary sheet with the totals. Nothing is uploaded, so it is safe for statements with salaries and account numbers.
Way 2: Excel's Get Data from PDF
Excel for Microsoft 365 on Windows can read tables from a PDF. It is not available in every version of Excel.
- In Excel, open Data → Get Data → From File → From PDF and choose the statement.
- In the Navigator, pick the tables that hold the transactions. Each page is usually a separate table.
- Choose Transform Data, append the page tables into one, remove the repeated headers and set the column types.
Expect some cleaning: descriptions that run over two lines become two rows, amounts may arrive as text, and dates can be read in the wrong day/month order. Excel does not check the balances for you.
Way 3: copy and paste
Select the transactions in your PDF viewer, copy them and paste into Excel. Then use Data → Text to Columns to split the lines. This works for a short statement but is slow for long ones: columns often merge, minus signs and brackets get lost, and every page needs the same work again.
Which way to choose
| Way | Speed | Numbers ready for formulas | Balances checked | File leaves your computer |
|---|---|---|---|---|
| Statement converter | Fastest | Yes | Yes | No |
| Get Data from PDF | Medium | After cleaning | No | No |
| Copy and paste | Slowest | Often not | No | No |
Check the result
Whichever way you use, check that nothing was lost. The quickest test: the opening balance plus all money in, minus all money out, must equal the closing balance. A row-by-row check is even better; see how to check that a bank statement adds up.
Common problems
- Dates like 01/02/2026. Is it 1 February or 2 January? Look for a date with a day above 12 to tell. In Tidysheet you can switch the order if it guessed wrong.
- Negative amounts in brackets, such as (45.10), and amounts marked Dr or Cr. A converter handles them; with copy and paste, fix them by hand.
- A password. See where to find the password of a bank statement PDF.
- Several accounts in one PDF. Tidysheet tells you when a file holds more than one statement. For an exact balance check, save each account's pages as a separate PDF (Print → Save as PDF, choosing the pages) and convert them one at a time.