Banks

Convert Santander Bank Statements to Excel

Convert Santander statement PDFs to Excel and CSV. We keep Santander's own columns and dates, and check every balance. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your Santander statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way.

What a Santander statement looks like

  • A Santander statement has five columns: Date, Description, Money in, Money out and Balance, with a £ sign in the Balance heading.
  • Dates are ordinal and leave out the year, like 3rd Nov. Your spreadsheet keeps them as printed, so Excel reads them as text, not as dates.
  • Each description starts with the kind of transaction, such as DIRECT DEBIT, BILL PAYMENT, BANK GIRO CREDIT or STANDING ORDER.
  • BALANCE BROUGHT FORWARD and BALANCE CARRIED FORWARD lines come through as rows of their own.
  • Every row has its own balance.

What your spreadsheet looks like

Date Description Money in Money out £ Balance Ledger
1st Nov BALANCE BROUGHT FORWARD 1,020.00 ok
2nd Nov BANK GIRO CREDIT REF EMPLOYER LTD 1,640.00 2,660.00 ok
3rd Nov DIRECT DEBIT PAYMENT TO ENERGY CO 88.00 2,572.00 ok
5th Nov STANDING ORDER TO LANDLORD 700.00 1,872.00 ok

The rows above are an example, not a real statement.

How we test it

We test against two Santander statements: 44 transactions in all, and the Ledger column flags none of them. Of the 44, 41 balance against the row before. The other 3 have figures we cannot read, so we fill them in from the balances around them.

Convert a Santander statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.