Resources
Import an Excel bank statement: three banks directly, every other bank through CSV
If your bank gave you an .xls or .xlsx file, Home Budget Analytics reads it directly only when it comes from Santander (Spain), Monobank or PrivatBank (Ukraine). An Excel file from any other bank is not supported as Excel. The fix takes a minute: open it in a spreadsheet program, save it as CSV, and use the CSV mapping flow.
Where Excel files are read
Excel import exists for three banks: Santander in Spain, and Monobank and PrivatBank in Ukraine. For these, upload the spreadsheet as you downloaded it. Do not edit it first, because the reader expects the bank's own layout. Bank-specific details are on the pages for [Santander](/es/santander), [Monobank](/uk/monobank) and [PrivatBank](/uk/privatbank).
Spreadsheets are free-form: a bank can put a logo, account details, merged cells or several tables on one sheet, and none of that is labeled. A reader has to be written for each bank's exact layout, which is why the list is short and why Excel from other banks is not guessed at.
Which route to take
| Your file | What to do |
|---|---|
| Excel from Santander, Monobank or PrivatBank | Upload the .xls or .xlsx as downloaded |
| Excel from any other bank | Save as CSV, then map the columns on upload |
| Your bank also offers OFX/QFX or CAMT.053 | Download that instead - it is recognized without a mapping step |
Convert any other bank's Excel file to CSV
These steps are generic because every spreadsheet program words them a little differently.
-
1
Open the file in a spreadsheet program
Use Excel, LibreOffice Calc or Google Sheets. Look at the sheet and note which column is the date, the description and the amount.
-
2
Tidy the top of the sheet
Delete any rows above the column names, such as a bank title or account summary, so the header is the first row. Remove totals rows at the bottom if there are any.
-
3
Save or export as CSV
Use Save As (or Download / Export) and choose CSV as the file type. If the file has several sheets, save the one with the transactions.
-
4
Upload the CSV and map the columns
Upload the new file. On the mapping screen choose the date, description, amount (one signed column, or separate debit and credit) and currency, then save the mapping under a name. On the next upload you pick it from a list.
What you get after the import
Whichever route you take, the result is the same: transactions are categorized with rules you confirm once per merchant, and then shown as spending by category, monthly trends, budgets and recurring payments. Overlapping uploads are safe, because duplicates are matched on date, merchant, amount and currency and skipped.
One caution for the CSV route: a date such as 03/04/2026 can mean two different days, so set the date format explicitly if Auto gets it wrong. The full mapping walkthrough is in [the CSV import guide](/csv-import).
Common questions about Excel statements
Can I upload an .xlsx from any bank?
No. Excel files are read only from Santander, Monobank and PrivatBank. For any other bank, save the file as CSV and use the column mapping.
Does the column mapping work on Excel files?
No. Column mapping works for CSV and TXT files only. That is the reason to convert an unsupported Excel file to CSV first.
Will saving as CSV lose any data?
Formatting, colors and formulas are not kept, but the transactions are. CSV holds plain values, which is all the import needs. Check that you saved the sheet that contains the transactions.
Is there a better option than Excel?
If your bank offers OFX/QFX or CAMT.053, use that. They are recognized without any mapping. CSV is the fallback when only a spreadsheet is on offer.
Bring your spreadsheet statement in
Upload the file, or convert it to CSV and map it once. 14-day free trial, no card required.
Start your free trial