To move a UK bank statement from PDF to Excel, try Excel's own PDF import first, then copy and paste as a fallback, and finish by fixing the dates and amounts and checking the totals against the printed balance. Expect to spend some time on tidy-up: PDF statements are laid out for reading, not for sorting. The example below is in pounds.
Which import route should you try first?
- In a current Windows version of Microsoft 365 Excel, look under Data, Get Data, From File, From PDF. It lists the tables it finds on each page; pick the one that looks like the transactions and load it.
- If your Excel version has no PDF option, open the PDF in a viewer, select the transaction table and paste into Excel, then use Text to Columns.
- If the PDF is a scanned image, neither route will see the text. Ask for a digital copy of the statement instead.
- If it asks for a password to open, use the one you were given for that file; do not paste it anywhere else.
Google Sheets cannot read PDFs directly, so you would copy and paste, or convert elsewhere first. we do not describe any particular bank's statement layout, because it varies; look at yours.
How do you fix day-first dates?
A UK statement shows dates as day, month, year. If your computer is set to a month-first region, Excel may read 03/04/2026 as 4 March, not 3 April, or leave it as text. Check a date such as 25/04/2026: if it stays as text, Excel is expecting month first. Fix it by setting the column format to Date with a UK locale, or rebuild the date with a formula:
- If text is in A2 as 03/04/2026: =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))
- If amounts arrive as text with commas: =VALUE(SUBSTITUTE(C2,",",""))
- If a pound sign is attached: =VALUE(SUBSTITUTE(SUBSTITUTE(C2,"£",""),",",""))
A worked check in pounds
Say the opening balance is £1,120.50, and after tidying you have three rows:
| Date | Description | Paid out | Paid in |
|---|---|---|---|
| 03/04 | Supermarket | £61.40 | - |
| 04/04 | Salary | - | £2,450.00 |
| 06/04 | Phone bill | £32.99 | - |
| Totals | - | £94.39 | £2,450.00 |
£61.40 + £32.99 is £94.39 paid out. £1,120.50 + £2,450.00 − £94.39 gives £3,476.11. If your statement's closing balance reads £3,476.11, every row came across. If not, look for a row that was split over two lines or an amount that has become text, and fix it before moving on.
What if the columns come across shifted?
Power Query and paste both sometimes put the date, description and amounts into one cell. Use Text to Columns with the delimiter set to a space or a fixed width, then rebuild the description by joining the middle pieces. If the amounts end up in the wrong column, add a column check: =IF(AND(D2<>"",E2<>""),"Check",""), which flags any row where both paid out and paid in are filled. Rows flagged this way are almost always a broken line from the PDF.
What next once the data is in?
- Add a Category column and fill it for the biggest merchants first.
- Add a month column with =TEXT(A2,"mmm yyyy") if the dates are real dates.
- Build a pivot table with Category in rows and the paid-out total in values.
- Save a copy of the original PDF with the workbook.
This guide covers method only; I make no claims about bank fees, features or rules in the UK, so check those with your bank. If you tire of repeating the clean-up every month, ask whether a CSV download is available on your account, which skips most of these steps.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

