Santander Bank Statement to Excel: Convert and Verify

TL;DR To get a Santander statement into Excel, download each monthly statement PDF, convert it so every transaction sits on its own row with a real date and a numeric amount, and confirm that the opening balance plus all activity equals the closing balance. Use the online transaction download only for quick checks on recent activity. For lenders, accountants, tax work or catch-up bookkeeping, work from the statements, flag transfers between your own accounts, and keep the original PDFs next to the workbook.

Santander is a large international bank, and people bank with it in the United States, the United Kingdom and several other countries. That matters for one reason in a spreadsheet: statement layouts, date formats and number formats differ between regions. A US statement will usually print dates month first and amounts with a comma as the thousands separator. A UK statement will usually print dates day first. Excel will happily misread either one if your computer's regional settings disagree with the file.

This guide walks through the full workflow: picking the right source file, converting it, checking it balances, fixing the problems that show up most often, and organizing the result for the job you actually need it for. We describe online banking in general terms, because bank websites and apps change their menus regularly and the exact path differs by country.

Statement PDF or transaction download?

Most online banking services give you two ways to get your data out, and they're not interchangeable.

A transaction download is a file of recent activity, often CSV or a format your accounting software can read. It's quick, it opens straight in Excel, and it's handy for "how much did we spend on fuel last month?" The downsides are that the window it covers can be limited, it may include pending items that later change or drop off, and it doesn't carry the official opening and closing balances.

A statement PDF is the official record of the period. It shows the balance brought forward, every posted transaction, fees and interest, and the closing balance. Statements usually go back further than downloads, and they're what a mortgage lender, landlord, accountant or court will ask for.

A simple rule: if anyone other than you will rely on the numbers, or you need to reconcile, use statements. If you just want a rough look at last month, the download is fine.

Before converting anything, gather every month you need for every account and name the files consistently, for example santander-current-2026-04.pdf and santander-credit-2026-04.pdf. Sorting by name then sorts by date. If you're missing months, our guide on how to get old bank statements covers the usual ways to request them.

What a Santander statement contains

Layouts vary by country and account type, but the building blocks are familiar:

• Account details and statement period. The start and end dates matter later, because transaction lines often omit the year.
• A summary block. Opening or previous balance, total money in, total money out, closing or new balance. This is your control total.
• The transaction list. Date, description and amount, sometimes with separate paid-in and paid-out columns and sometimes with a running balance.
• Fees and interest. Often listed near the end, and easy to miss when copying by hand.
• Extra pages. Notices, rate information and legal text that you don't want in your spreadsheet.

Credit card statements follow a different logic. They start with what you owed, add purchases, fees and interest, and subtract payments and refunds. Keep that in mind for the balance check below.

Converting the PDF to Excel

You have three realistic options.

Copy and paste. Select the transaction rows in the PDF and paste into Excel. This works for a short statement. On a full month you'll usually get descriptions wrapped onto two lines, amounts pasted as text, money-in and money-out columns collapsed into one, and dates without a year. Text to Columns, TEXTSPLIT and NUMBERVALUE can rescue it, but it's slow and error-prone.

Power Query. In desktop Excel, Data, Get Data, From File, From PDF will try to detect tables on each page. On clean, grid-like layouts it can work well. On statements where columns aren't true tables, it tends to merge or split rows unpredictably. Our Power Query bank statement guide explains how to clean up what it produces.

A converter built for bank statements. SheetStatement reads the statement layout, puts each transaction on one row, adds the year from the statement period, and runs a balance check against the summary before you export. You can download Excel, CSV, or files for QuickBooks and Xero. The free plan includes 3 pages a month, and the Starter ($9), Pro ($19) and Business ($39) monthly plans cover larger volumes.

Whatever method you use, aim for this shape:

One row per transaction, a real date, a single signed amount, and an account column so you can combine statements later.

Watch out for regional date and number formats

This is the most Santander-specific trap, because the same bank name covers statements printed in different regional styles.

Dates. A date like 04/05/2026 means 5 April in US style and 4 May in UK style. If Excel's regional setting doesn't match the statement, it will either convert the date to the wrong month or leave it as text. Signs of trouble: dates that won't sort correctly, or a month that seems to contain transactions from two different months.

The safest fix is to tell Excel how to read the column at import time. In the Text Import Wizard or Power Query, set the column type to Date and choose the locale that matches the statement. If the data is already in the sheet as text, you can rebuild the date with DATE, LEFT, MID and RIGHT. Our guide to fixing bank statement dates in Excel covers this in detail, including statements that print dates without a year.

Numbers. Statements from some countries use a period as the thousands separator and a comma for decimals, so 1.234,56 means one thousand two hundred thirty-four and fifty-six. NUMBERVALUE handles this cleanly:

=NUMBERVALUE(C2, ",", ".")

The second argument is the decimal separator, the third is the thousands separator.

Currency symbols and "CR" or "DR" suffixes. Strip the symbol and turn suffixes into signs. If a column shows 125.00 CR for money in, a formula like this gives you a signed number:

=IF(RIGHT(TRIM(C2),2)="CR", 1, -1) * NUMBERVALUE(SUBSTITUTE(SUBSTITUTE(C2,"CR",""),"DR",""))

Adjust it to whatever suffixes your statement uses.

Merge money-in and money-out columns

Many statements print separate columns for money paid in and paid out. For analysis and for most imports, one signed amount column is easier. With paid in in column D and paid out in column E:

=N(D2) - N(E2)

N treats blanks as zero, so empty cells don't cause errors. Keep the original two columns hidden rather than deleting them, in case you need to check a row against the PDF. Our guide to separating debit and credit columns in Excel covers the reverse direction too, for software that wants two columns.

Check that every statement balances

This step is what separates a trustworthy spreadsheet from one that only looks complete.

For current, checking and savings accounts:

=ROUND(OpeningBalance + SUM(Amounts) - ClosingBalance, 2)

For credit cards, where purchases are positive and payments negative:

=ROUND(PreviousBalance + SUM(Amounts) - NewBalance, 2)

Both should return 0. If they don't, the size of the difference is a clue:

• Equal to one transaction: a row is missing or duplicated, often at a page break.
• Equal to twice one transaction: a sign is wrong, such as a refund recorded as a purchase.
• Equal to the fee or interest total: that section was skipped.
• A round number like 100 or 1,000: a digit was misread, or a thousands separator was misinterpreted.

If the statement prints a running balance, add your own running balance column and compare row by row. The first row where they differ points to the problem. Our article on the running balance formula in Excel shows how to set that up, and the free balance checker does the arithmetic for you.

Organize the data for the job

Once each statement balances, combine them into one table with an Account column and a Month column, then shape it for the task.

Household budgeting

1. Flag transfers. Moves between your current account and savings, and payments to your Santander credit card, are not spending. Flag them and exclude them from summaries. Counting both the card payment and the card purchases is the most common reason a budget shows spending far higher than reality.
2. Categorize. A rules table with XLOOKUP or SEARCH can assign most rows automatically. Our guide to Excel formulas for categorizing bank transactions has ready-made patterns.
3. Summarize. A pivot table with Category in rows and Month in columns shows trends quickly. See the bank statement pivot table guide.

Bookkeeping for a small business

If you run a business account with Santander, you'll usually want the converted statement in your accounting software rather than a standalone sheet. Export a CSV or a QuickBooks or Xero file, import it, and reconcile against the statement's closing balance. Our guides to importing into QuickBooks Online and the Xero CSV import format explain the column requirements.

Loans, rentals and visas

Lenders, landlords and immigration authorities generally want the original statements, not your spreadsheet. The spreadsheet helps you prepare: filter for large deposits and note where each came from, confirm the closing balances meet any stated requirement, and check that there are no gaps in the months. See our guides on bank statements for a mortgage application and bank statements for a visa application.

A worked example

Someone has a Santander current account, a savings account and a credit card. They want twelve months in one workbook to plan a budget and to answer questions from a mortgage broker.

1. Download. Thirty-six statement PDFs, named by account and month.
2. Convert. Each statement goes through the converter, and the export lands in one folder.
3. Fix the regional issue. The first attempt at a manual paste on one month had read 03/04 as 4 March instead of 3 April. Re-importing with the correct locale fixed it. Everything from the converter already had ISO dates.
4. Balance check. Thirty-five statements balance at once. One credit card month is off by exactly twice a single refund, which had been recorded as a purchase. Flipping the sign fixes it.
5. Combine and flag. All rows go into one table. Savings transfers and card payments are flagged as transfers.
6. Categorize and summarize. A rules table covers most rows. A pivot table shows monthly spending by category and the average over the year.
7. Answer the broker. A filter on deposits over a set amount lists every unusual credit with its date and description, ready to explain.

The whole thing is reproducible: anyone can pick any figure in the summary and trace it to a row, then to a page in the original PDF.

Keep a simple monthly routine

The first conversion is the slow one. After that, a short routine keeps the workbook current without much effort:

1. Download the new statement for each account as soon as it's available and save it with the same naming pattern.
2. Convert and check the balance before you touch anything else. A statement that doesn't balance shouldn't go into the combined table.
3. Append the rows to the bottom of your table. If you've formatted it as an Excel table, formulas, pivot sources and charts extend automatically.
4. Categorize new payees. Filter for rows without a category, add the new merchants to your rules table, and the formulas fill the rest.
5. Refresh and review. Refresh the pivot table and compare the month with the previous few. Anything unusual is worth a second look while you still remember what it was.

Done this way, the monthly update usually takes a few minutes, and you always have a balanced, complete record you can hand to someone else.

Troubleshooting

Dates sort in the wrong order. They're text, or they were read in the wrong regional format. Re-import with the right locale or rebuild them with DATE.

Amounts won't sum. They're stored as text, often because of a currency symbol, a non-breaking space or a "CR" suffix. Clean them with NUMBERVALUE and SUBSTITUTE.

Descriptions are split across two rows. Long merchant names sometimes wrap in the PDF. Join the continuation line to the row above and delete the extra row, then rerun the balance check.

A page is missing. If the balance is off by the total of a whole page, check that every page converted. Multi-page statements sometimes have a page that's an image rather than text; see converting scanned bank statements.

Transfers double count. Flag both sides of every internal transfer and card payment.

The download and statement disagree. Downloads can include pending items and cut off on a different date. Compare the date range and rely on the statement for anything official.

Convert a Santander statement now

Upload a Santander statement PDF to SheetStatement, review the extracted rows, confirm the balance check passes, and download Excel or CSV. The free plan covers 3 pages a month, which is enough to try it on a real statement before you decide on a paid plan.

FAQ

Can I download Santander transactions straight to Excel?

Online banking usually offers a download of recent transactions in a spreadsheet-friendly format. That's fine for a quick look. For full statement periods, older months, official balances, or documents someone else will rely on, convert the PDF statements instead.

Why are my Santander dates wrong in Excel?

Usually because the statement's date format (month first or day first) doesn't match your computer's regional settings. Import the column as a date with the correct locale, or rebuild the date from its parts with the DATE function.

Does this work for Santander UK and Santander US statements?

The workflow is the same. The differences are mostly date and number formats and terminology, such as "current account" versus "checking account". Check the format before importing and the rest of the process doesn't change.

How do I handle a Santander credit card statement?

Treat purchases, fees and interest as increasing what you owe and payments and refunds as reducing it, then check that previous balance plus activity equals the new balance. When you combine it with your bank account for budgeting, flag card payments as transfers.

Can I import the converted file into QuickBooks or Xero?

Yes. Export a CSV in the column layout your software expects, or a QuickBooks or Xero format, then import and reconcile against the statement's closing balance.

What if my statement is a scanned image?

Scanned statements need OCR before the text can be extracted. Results depend on scan quality, so always run the balance check afterward. See our guide to OCR accuracy on scanned statements.

Is it safe to upload bank statements?

Read the security page to see how SheetStatement processes and stores files, and check any service's policy before uploading financial documents.

How many pages can I convert for free?

The free plan includes 3 pages a month. Paid plans start at $9 a month for Starter, with Pro at $19 and Business at $39 for higher volumes.