SpareBank 1 hands you a CSV in one click

SpareBank 1 is an alliance of several regional banks, and their online banks are not quite identical. The basic setup is the same, but a button might be labelled slightly differently at SpareBank 1 SR-Bank than at SpareBank 1 Nord-Norge. This guide is built around the standard interface for private customers.

What you need

You need the online bank in a regular browser on a computer. Exporting transactions is not available in the SpareBank 1 mobile app (SmartBank), and you do not need any extra software.

How to export

1. Sign in through your SpareBank 1 bank's website (for example sr-bank.no, smn.no or sparebank1.no) and go to Kontoer (Accounts).
2. Pick the account you want to export from.
3. Set the date range. Fill in Fra dato (From date) and Til dato (To date).
4. Click "Eksporter til Excel" (Export to Excel) or the equivalent button. A CSV file is downloaded to your computer, not an actual Excel format.
5. Repeat for other accounts if you need to.

Last verified: March 2026. SpareBank 1 updates the online bank interface regularly. See your SpareBank 1 bank's help pages if the steps look different.

The button says "Excel", but the file is CSV

This is an easy thing to get tripped up by. The button is labelled "Export to Excel", but the file you get is a text file with CSV content, not .xlsx. That actually works in your favour: it slots straight into budgeting tools that read CSV directly.

Open the same file in Excel and it can look strange, with everything ending up in a single column. SpareBank 1's file uses a semicolon (;) as the field separator and a comma as the decimal mark, which is the Norwegian standard. To open it correctly in Excel, use the text import wizard and pick semicolon by hand, or go via Data, then Get and Transform Data, and set the separator there.

If the file is heading into a budgeting tool with Norwegian CSV support, you do not have to worry about any of this. If you are unsure whether the file looks right, open it in Notepad (Windows) or TextEdit (Mac) and check that the columns are separated by semicolons.

Which date applies?

Pick the booked date when you set the period, not the value date. The booked date is the date the bank registers the transaction and matches your account statement. The value date is used for interest calculation and can give confusing results if you compare it against monthly totals.

Account statements and annual statements

If you would rather have a PDF account statement or annual statement, you can find them under Mine dokumenter (My Documents) in the online bank. There you can search by period and document type. PDFs are readable, but not machine-readable in the same way as a CSV, and so they are less suited to categorisation and ongoing budget tracking.

Next step

Take the file into your budgeting tool, upload it and approve the suggested categories. If you have only used the app so far and have just pulled out your first CSV, you will probably spot one or two categories that cost more than you remembered from last month.

If you use Luma, the app supports importing SpareBank 1 files and handles the Norwegian semicolon format with no extra setup.