To import an Excel bank statement, download it from net banking as an .xlsx file, choose the account in your tracker, upload the file and review the rows before saving. An Excel file works much like a CSV, but it can bring extra baggage: several sheets, merged heading cells and amounts stored as text.
How an Excel statement differs from CSV
| Point | CSV | Excel (.xlsx) |
|---|---|---|
| Structure | One plain table | One or more sheets |
| Formatting | None | Merged cells, colours, header blocks |
| Amounts | Plain numbers | Sometimes stored as text with commas |
| Dates | Plain text | May be real dates or text |
SpendixAI accepts PDF, CSV or Excel statements and shows the rows for review before saving. Both CSV and Excel are usually cleaner than a PDF, because they are already tables.
The steps
- Add or choose the account the statement belongs to.
- Download the statement for a clear period as .xlsx from your bank.
- Open it once to check it is the right period, then close it.
- Upload the file and wait for the rows to appear.
- Review the preview before saving.
Closing the file matters. Some computers lock a file that is open in Excel, which can stop an upload.
Which snags come up with Excel files?
Several sheets
A workbook may hold a summary sheet and a transactions sheet. If the wrong sheet is read, you see a handful of strange rows or nothing at all. Look at the workbook yourself and see which sheet holds the data.
Merged header cells
Banks often put the account name and period in merged cells above the table. These can arrive as junk rows at the top, so check the first rows of the preview.
Amounts stored as text
An amount such as 1,25,000.00 can be saved as text rather than a number. If the preview shows amounts as zero or blank, this is the likely cause.
When should I tidy the file in Excel?
Only when the preview looks wrong. A few light fixes in a copy of the file can be enough.
- Delete the sheets you do not need, keeping the transactions sheet.
- Remove the heading lines above the column titles.
- Delete any total or footer line at the bottom.
- Save as a new file and keep the original untouched.
A worked example
Say a workbook has two sheets. The first, Summary, lists opening balance ₹12,000 and closing balance ₹14,500. The second, Transactions, has 30 rows. If the first sheet gets read, you will see two rows, not 30, and the amounts will look nothing like spending. Deleting the Summary sheet in a copy solves it: 30 rows come in, and 12,000 plus credits minus debits should equal 14,500.
Keep the original download in its own folder and never overwrite it. If something goes wrong with a cleaned copy, you can always start again from the untouched original, and you have the bank's own file to point to if a number is ever questioned later.
Excel or CSV: which should I pick?
If your bank offers both, either is fine, and CSV is slightly simpler since it has no sheets or merged cells. Choose Excel when the CSV drops leading zeros, mangles special characters in narrations, or strips formatting you rely on. Whichever you pick, stay consistent for an account so the layout does not change from month to month. If you edit the file at all, save it back in the same format, and avoid renaming column headings.
Excel also does one unhelpful thing, which is guessing the type of a cell. If a long reference number is shown in scientific notation, do not worry about it, since it is not part of the amount. Focus on date, narration, amount and direction.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

