How to Export Your Santander Transactions to Excel
If you keep your finances in a spreadsheet or an app, sooner or later you'll need the same thing: your Santander account transactions in a file you can open in Excel. Banks and lenders ask for it too when you apply for a mortgage or a loan. The good news is Santander lets you download it in a couple of clicks. Here's how, from the website and from your phone, and which format to pick depending on what you want to do with it.
From the website (online banking)
This is the most convenient route, since it lets you download to Excel. Once you're logged into your online banking:
- Go to bancosantander.es and log in via Acceso clientes (your ID and password).
- Select the account you want.
- Open its Transactions. To narrow it down, use the magnifying glass icon to filter by date or amount.
- Click the download icon (the down arrow, above the list).
- Choose the format: Excel or PDF. To analyse the data, choose Excel. Confirm and save the file.
From the mobile app
- Open the Santander app and go to your Posición Global (overview).
- Select the account.
- Tap Filters and set the period you want.
- Tap Download and save or share the file.
Santander lets you view and download transactions from the last two years through these channels; for older statements, you'll need to request them at a branch. Menu names can change with updates.
Excel, CSV or PDF? Which to choose
- Excel: the most convenient for working with in a spreadsheet. This is what Santander's website offers.
- CSV: the universal format almost every finance app understands. If your download comes as Excel, you can convert it to CSV from the spreadsheet app itself (Save as → CSV).
- PDF: only for archiving or printing. Not usable for analysis or import: it's a picture of the statement, not data.
How many months to download
For a useful picture of where your money goes, download at least one full month. If it's for a mortgage application, banks usually ask for the last 3 to 6 months. And if you want to genuinely spot your patterns — and catch your small recurring expenses — the more history, the better. Keep in mind online banking gives you about two years of access; for anything older, you'll need to visit a branch.
Once you have the Excel file, then what?
Downloading it is only half the job. The other half — the part that actually tells you something — is categorising every transaction to see where your money goes. Doing that by hand in Excel works for month one and gets abandoned by month two.
In Inveriok, you upload that same Santander Excel file and it categorises itself: you see your income statement, your savings rate and your small recurring expenses without typing anything in. And if you'd rather not upload a file every month, you can log transactions by hand instead: that's how transaction import works, with no bank connection and no credentials shared with anyone.
Frequently asked questions
What format does Santander use to download transactions?
From the website you can download in Excel or PDF. To analyse the data in a spreadsheet or import it into a finance app, use Excel — the PDF is just an image of the statement. If you need CSV, save the Excel file as CSV from your spreadsheet app.
How much history can I download from Santander?
Through online banking and the app you can view and download transactions from the last two years. For older statements, you'll need to request them at a branch.
Do I need to connect my bank to an app for this?
No. Downloading the Excel file creates a file that's yours to analyse anywhere, without giving any third party access to your banking credentials.
Can I use the PDF statement to import my transactions?
No. The PDF is an image of the statement; to import or analyse the data you need the file in Excel (or CSV).
Sources
- Bank Customer Portal (Bank of Spain) — your bank must send you a monthly statement with every transaction on the account.
- Bank of Spain — fees for account information — asking the branch for a duplicate statement may carry a fee; downloading it yourself does not.
- Finanzas para Todos (CNMV and Bank of Spain) — free personal budgeting tools from Spain's national financial education plan.
- losbancos.es — third-party guides to Spanish online banking when the bank does not document a step.
- Banco Santander help — "How to view and download your account transactions." Steps verified in August 2026; menus may change with updates.
Disclaimer. This guide is informational and describes a general process; Santander's exact steps and menu names may vary. It is not financial advice. Inveriok is not affiliated with Banco Santander.