How to Export Openbank Transactions to Excel

Openbank is 100% digital, so everything happens on the website or app — and downloading your transactions to view in Excel is no exception. Sooner or later you'll want the same thing: your transactions in a file you can open in a spreadsheet to see where your money is going, or to justify expenses or prepare a tax return. Here's how to download them in Excel or CSV, from both the website and the app, and what to keep in mind.

From the website (openbank.es)

The most convenient option if you're downloading several months:

1. Log in at openbank.es with your credentials.
2. Go to Accounts and select your current account.
3. Open Transactions.
4. Apply the date filter for the period you need.
5. Click download / export and choose the format (Excel or CSV for analysis).

From the mobile app

If you manage everything from your phone:

1. Open the Openbank app and log in.
2. Go to your current account and tap Transactions.
3. Select the period you want to export.
4. Look for the share / export option (usually a download or share icon).
5. Choose the format and save the file or email it to yourself.

Openbank lets you generate a transaction certificate covering up to 24 months of history. If you need more, download it in stages. Menus may change with website and app updates.

Excel, CSV or PDF — which to choose

• Excel / CSV: what you want for analysis. CSV is lighter and more universal (almost every app understands it); Excel includes visual formatting. Both work.
• PDF: only for filing or proof. Not usable for analysis or import: it's a snapshot of the statement, not data.

How many months to download

To see where your money is going, download at least one full month. If it's to review your finances for the year, pull the last 3 to 12 months. And while you're at it, reviewing the statement is the best time to catch small recurring expenses: the subscriptions and small purchases that add up without you noticing.

And once you have the Excel file, what next?

Downloading it is only half the job. The other half — the part that actually tells you something — is categorising each transaction to see where your money goes. Doing it by hand in Excel works the first month and gets abandoned the second.

In Inveriok you upload that same Openbank Excel or CSV file and it self-categorises: you see your income statement, your savings rate and your small recurring expenses without typing anything. And if you'd rather not upload a file every month, you can log transactions manually: here's how transaction import works, without connecting your bank or handing your credentials to anyone.

Frequently asked questions

What formats does Openbank offer for downloading transactions?

Openbank lets you download your statement or certificate in Excel, CSV or PDF. To analyse your spending or import it into an app, choose Excel or CSV; PDF is only for filing, not for working with the data.

How much history can I export from Openbank?

Openbank lets you generate a transaction certificate covering up to 24 months of history. To review your spending, downloading 3 to 12 months is more than enough.

Excel or CSV for Openbank?

Both work for analysis. CSV is lighter and more universal; Excel includes visual formatting. If your tool supports both, CSV usually causes fewer issues.

Do I need to connect my bank to an app for this?

No. Generating the statement creates a file of your own that you can analyse wherever you like, without giving your Openbank credentials to any third party.

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.
• Official help centre and channels of Openbank — downloading transactions and account certificate (up to 24 months of history). Steps verified in August 2026; may change with updates.

---

Notice. This guide is informational and describes a general process; Openbank's steps and menus may vary. This is not financial advice. Inveriok is not affiliated with Openbank.