# Import Excel Bank Statement into Xero via CSV

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Xero imports
- Canonical: https://simplebankconvert.com/blog/import-excel-bank-statement-into-xero

> How to import an Excel bank statement into Xero: fix the sheet's dates and amounts, save it as CSV in the right format and upload it to the bank account.
To import an Excel bank statement into Xero, first clean the sheet: one header row, real dates in a single format, and one amount column with withdrawals as negatives. Then save the sheet as a CSV file and upload that CSV through the bank account's Import a statement option. Xero's statement import does not take the Excel workbook directly.

## Can Xero take the Excel workbook itself?

No. Xero's statement import reads text files such as CSV, not Excel workbooks, so an .xlsx or .xls file has to be saved as CSV first. Saving is the easy part. The work is making sure the sheet holds clean rows before you save, because CSV keeps only the values you see.

### Why the workbook needs work first

Bank spreadsheets are made for people to read. They often have a logo row, the account name, a blank line, column titles, the transactions, and then a total. Xero only wants the column titles and the transactions. Everything else becomes junk rows or errors.

### What to delete

- Rows above the column titles.
- Summary rows at the bottom, such as totals or closing balance.
- Running balance columns, which are not transactions.
- Extra sheets. A CSV saves only the sheet that is open.

## Fixing Excel bank statement dates before the Xero upload

Every date in the column should be a real date in one format. Excel sometimes stores some dates as text and others as dates, especially after copying from a PDF or a web page. When the CSV is saved, those two kinds come out differently, and Xero may read some days as months.

### How to spot the problem

Text dates usually sit on the left of the cell, real dates on the right. Click a cell: if the formula bar shows something like an apostrophe or an odd spacing, it is text. Sort the column; if March 4 lands far from March 5, some of them are text.

### How to fix it

Select the date column and set one date format, such as day, month and year in the order Xero will be told to expect. Retype or convert any cell that does not change. Then pick two dates you know, such as the first and last transactions on the statement, and confirm both read correctly.

## One signed amount column for the Xero import

Xero needs each transaction's amount in one column, with money coming in positive and money going out negative. Many bank spreadsheets use two columns instead, one for withdrawals and one for deposits. Combine them into a single signed column before saving.

### A before and after row

These rows are examples.

| Date | Description | Withdrawals | Deposits |
| --- | --- | --- | --- |
| 04/03/2026 | Pinecrest Office Supply | 86.42 | |

becomes

| Date | Payee | Amount |
| --- | --- | --- |
| 04/03/2026 | Pinecrest Office Supply | -86.42 |

### The formula

Add an Amount column with the deposit minus the withdrawal for each row, for example `=D2-C2`. Fill it down. Copy the column and paste it as values, then delete the two old columns. Remove currency symbols and thousands separators so each amount is a plain number. The full set of columns Xero looks for is in [importing a bank statement into Xero](/blog/import-bank-statement-into-xero).

## Exporting the Excel sheet to a Xero-ready CSV

Use Save As, or Export, and choose the CSV format. Excel will warn that only the active sheet is saved and some formatting is lost; that is what you want. Then reopen the CSV in a plain text editor, not in Excel, to see what Xero will actually read.

### What to check in the text editor

- The first line is the header, such as `Date,Amount,Payee,Description,Reference`.
- Dates look the same on every line.
- Amounts have no currency symbols and use a minus for money out.
- A payee containing a comma is wrapped in quotes.

### Then upload

In Xero, open the right bank account, open its menu, choose Import a Statement and pick the CSV. Match each column to Xero's field on the mapping screen and check the preview before saving. Card spreadsheets follow the same steps, though their signs are often reversed; [importing an Amex statement into Xero](/blog/import-amex-statement-into-xero) shows how to deal with that.

## What if Xero rejects the CSV from Excel?

When Xero refuses the file or brings in strange rows, the cause is almost always something Excel kept or changed: leftover summary rows, mixed date formats, amounts still split across two columns, or a different separator. Open the CSV in a text editor, find the bad line, fix the sheet, and save again.

### Common causes

- **Semicolons instead of commas.** Some regional settings save "CSV" with semicolons. Change the list separator or choose a comma-separated option.
- **Blank rows.** An empty line in the middle can stop the import or create an empty transaction.
- **Dates read in the wrong order.** Tell Xero the date format on the mapping screen that matches the file.

### When the fix is not worth it

If only two or three transactions are missing, typing them in may be quicker than repairing a sheet. [Manually adding bank statement lines in Xero](/blog/manually-add-bank-statement-lines-in-xero) covers that. If your bank offers a ready-made download for accounting software, use it; [downloading bank transactions for QuickBooks Desktop](/blog/how-to-download-bank-transactions-into-quickbooks-desktop) shows what those bank menus look like. And if all you have is a PDF, SimpleBankConvert is being built to produce the Xero CSV straight from it, without a spreadsheet step; join the list on the [get started page](/get-started).