If you are applying for a mortgage or remortgaging, your broker will ask for three months of bank statements, and they will want them clean, complete, and easy to read. That is where converting your Santander bank statement PDF to Excel earns its keep. The snag: Santander emails and online-banking downloads often arrive as password-protected PDFs, and you cannot convert a file you cannot open. This guide walks through the whole chain — finding the password, unlocking the file safely, converting it to a spreadsheet you can actually use, and checking the numbers before they land on your broker's desk.
Why Santander locks its statements in the first place
The password is not there to annoy you. Santander adds an owner password to emailed statements so that a message intercepted in transit cannot be opened by whoever grabs it. It is a sensible precaution for a document that shows your salary, your spending, and your account number. The catch is that Santander also applies passwords to statements downloaded from online banking in some flows, so even a file you pulled yourself can refuse to open. Treat the password as a door lock, not a dead end: once you are through, the conversion work is straightforward.
Step 1: Find the password for your Santander PDF
Start with the email the statement arrived in. Banks usually state the password format in the same message or in a covering letter — something like the first four letters of your surname plus your date of birth, or your date of birth in DDMMYYYY format. If the statement came from online banking, check Santander's help pages for the current format, because formats change and third-party blog posts go stale. A few practical tips that save real time: passwords are case-sensitive, so copy the surname letters exactly as they appear on your account; leading zeros in dates matter (so July 4 becomes 0407, not 47); and if you recently changed your name, the password usually follows the name Santander has on file right now, not the one from three years ago. If two or three sensible guesses fail, stop guessing — too many wrong attempts can lock the file on some readers, and Santander's customer support can confirm the current format in a couple of minutes. Whatever you do, do not paste the locked file into a random free unlocking website; you would be handing your full financial history to strangers, as our bank statement data-security guide explains.
Step 2: Unlock the statement without sketchy tools
The cleanest method needs no new software at all. Open the PDF in your browser — Chrome and Edge both prompt for the password — enter it, then press Ctrl+P (or Cmd+P on a Mac), choose "Save as PDF" as the destination, and save. The new file has no password, and you never installed anything. If you have Adobe Acrobat, you can also open the file, enter the password, go to File, then Properties, then Security, set the security method to "No Security," and save. Either way, do this on your own computer, on a file you own, and save the unlocked copy somewhere sensible — a locked filing cabinet folder, not your downloads folder where it sits next to installers and screenshots. Name it clearly, like santander-current-2026-07.pdf, so you can find it again when your broker asks for "the July one." For the general playbook on all of this, see our bank statement password-removal guide.
Step 3: Convert the unlocked PDF to a clean Excel sheet
With the password gone, upload the PDF to ConvertStatement's Santander converter, which is tuned for UK bank statement layouts, and download the result as an Excel or CSV file. Generic PDF-to-Excel tools often mangle Santander statements: running balances drift into the wrong columns, multi-line shop descriptions get split across rows, and debit and credit signs flip. A converter built for bank statements keeps dates in one column, amounts with correct signs, and descriptions intact. Once you have the spreadsheet, do a quick pass: sort by date and check that the sequence is continuous, scan the amounts column for anything that looks wildly off, and confirm the opening balance matches the first page of the PDF. This five-minute review is the difference between a broker-ready file and an embarrassing follow-up call.
Step 4: Sanity-check the numbers before your broker sees them
Mortgage underwriters do not just look at the total — they look for patterns. Large unexplained deposits, gambling transactions, or payday-loan repayments can trigger questions, so it is worth knowing what is in your own file before you send it. In Excel, add a simple filter and sort by amount, largest first. If a big deposit was a gift from a parent for the down payment, flag it now and have the gift letter ready. Check that your salary lands on roughly the same date each month — irregular pay patterns are fine if you can explain them. And confirm the three months are truly consecutive with no missing weeks; a gap makes an underwriter ask what you are hiding, even when the answer is just a bad download. This prep takes twenty minutes and can shave days off the back-and-forth. If statements are only one part of a bigger mortgage paperwork pile, our home-loan statement guide covers the rest of what lenders ask for.
Frequently asked questions
What is the default password for a Santander statement PDF?
There is no single permanent default — Santander states the format in the covering email or its help pages, and it commonly combines part of your surname with your date of birth. Check the email the statement arrived in first, then Santander's official help pages.
Can I convert the PDF to Excel without removing the password first?
Most converters, including ConvertStatement, need an unlocked file. Unlock it with the browser print-to-PDF trick above, then convert the unlocked copy.
Is it legal to remove the password from my own statement?
Yes — removing password protection from a file you own, for your own use, is fine. Just keep the unlocked copy somewhere secure and do not forward it around by email.
My broker wants CSV, not Excel. Does this still work?
Absolutely. Convert once, then in Excel use Save As and choose CSV. Our PDF-to-Excel conversion guide covers both output formats.
Three months of Santander statements, unlocked and converted, is an afternoon's work the first time and a twenty-minute job once you know the routine. Start with your most recent statement, convert it with ConvertStatement — free for your first files — and hand your broker a spreadsheet that answers questions before they are asked.