XERO TO EXCEL
How to export Xero to Excel.
And how to stop doing it every month.
Xero's own export is free and fine for a one-off; the steps are right below. If you rebuild the same report every month, keep it live in Excel instead.

Xero's own export, step by step.
Free, and fine for a one-off.
Xero exports most of its data without any add-in. Reports come out as Excel files; lists come out as CSV.
Reports
Profit and Loss, Balance Sheet, Trial Balance, aged reports
- 1Go to Reporting, then All reports, and open the report.
- 2Set the dates and click Update.
- 3Click Export and choose Microsoft Excel (or PDF, or Google Sheets).
Amounts showing 0.00 in Excel? Click Enable Editing and they fill in.
Invoices and bills
Sales invoices, purchase bills
- 1Go to Sales, then Invoices (or Purchases, then Bills).
- 2Pick a tab, and search by date if you need a period.
- 3Click Export. For bills it sits in the menu next to New Bill.
You get a CSV file, one row per line item, up to 500 transactions per export.
Bank and account transactions
Every transaction on a bank or other account
- 1Open the Account Transactions report under Reporting, All reports.
- 2Select the accounts and the date range, then click Update.
- 3Click Export, like any other report.
Contacts and chart of accounts
Customer and supplier lists, your accounts
- 1Contacts: go to Contacts, choose a group, click the three-dot menu at the top right and click Export.
- 2Accounts: go to Accounting, then Chart of accounts, and click Export.
Both download as CSV files.
What the files look like
Reports: totals at 0.00. Excel opens downloaded files in Protected View, and the totals stay at 0.00 until you click Enable Editing. Then come the title rows to delete.

Lists: a raw CSV. The invoices file has 44 columns, starting with 16 address columns; the invoice number, dates and amounts come after them. Dates arrive as text and amounts with four decimals, and contacts come with 72 columns.

Menu names can differ a little by region and Xero version; the linked Xero Central articles have the current steps. Xero's overview of exporting data lists everything else it can export.
The catch with exports.
Every change means a new one.
An export is a copy of the day you downloaded it. A late invoice, a corrected bill or a new month, and you start again.


More than one company? Xero exports one company at a time, so every change means one export per company.
Several versions in a folder. The 1 October file, the 6 October file, the 9 October file. Which one went in the pack?
See the difference in under 90 seconds.
Export once, then Refresh.
The usual export next to an XO Report table, an invoice list, and a new month brought in with Refresh.
Keep it live in Excel instead.
Three steps, once.
XO Report brings the same reports and lists into Excel as tables that stay linked to Xero.
STEP 1
Add XO Report from inside Excel
On the Home tab, click Add-ins, type "xo r" in the search box, then click Add next to XO Report. No search box? Choose More Add-ins and search the Store.


STEP 2
Sign in to Xero
Open XO Report from the Home tab, click Connect to Xero and pick a company; add more the same way. Access is read-only.

STEP 3
Insert what you used to export
Pick a report or a table, choose the dates and click Insert. It lands as an Excel table you can filter and pivot.


Want a single figure instead of a table? =XO.BALANCE returns an account's total for two date cells, and balance sheet accounts return the balance on the end date. =XO.PROFIT returns net profit for a period of up to a year. All the formulas →
Next month: Refresh, not export.
Same workbook, new figures.
Change the dates and click Refresh. Every XO Report table in the workbook updates from Xero, and your formatting and added columns stay.

Formulas recalculate for the new period when you change a date cell, and fetch it from Xero if it isn't loaded yet. Recalculating without changing inputs (F9) may reuse the figures XO Report already has; to pull the very latest straight from Xero, click Refresh in the XO Report pane.
What XO Report covers.
And what to keep exporting.
Live in Excel with XO Report
- Xero's standard reports →: Profit and Loss, Balance Sheet, Trial Balance, aged receivables and payables, Bank Summary, Executive Summary, Budget Summary
- Invoices, bills, credit notes, payments, quotes and purchase orders
- Manual journals →, one row per journal line
- Contacts, chart of accounts, items, tracking categories, tax rates and currencies
- Bank transactions → (Beta)
Keep using Xero's export
- Payroll and employee records
- The Account Transactions report, Xero's line-by-line general ledger for every transaction
Reports and tables work in Google Sheets too. The formulas are Excel only. XO Report for Google Sheets →
Five ways to get Xero into Excel.
Compared.
They differ in what happens after you close the file.
| Method | Updates itself? | Setup | Good for |
|---|---|---|---|
| Xero's own exportManual export vs XO Report | No. Export again after any change. | None | A one-off report or list |
| Copy and paste from Xero's screens | No | None | A few figures, once. Expect text-formatted numbers and dates to fix. |
| Power Query on the Xero API | Yes, once built | An API connection you build and maintain, with token renewal and a query per company | Teams with a developer |
| A data connectorXO Report vs data connectors | On its sync schedule | A separate service that copies Xero into a sheet or database | Data that also feeds Power BI or a warehouse |
| An Excel add-in such as XO Report | Yes, when you click Refresh in Excel | Add it from inside Excel and sign in to Xero | A workbook you open again next month |
Questions people ask.
- Can I export Xero to Excel for free?
- Yes. Xero exports its reports to Excel and its invoices, bills, contacts and chart of accounts to CSV at no cost. The steps are at the top of this page. What it can't do is update the file afterwards: after any change in Xero, you export again.
- What is the easiest way to export a revenue report from Xero?
- Use the Profit and Loss: its income section shows revenue by account. In Xero, go to Reporting, then All reports, open the Profit and Loss, set the dates and click Update, then Export and Microsoft Excel. If you need it every month, insert the Profit and Loss with XO Report and click Refresh next month, or put XO.BALANCE on your sales account codes with two date cells, filtered by a tracking category if you report revenue by region or department.
- How is XO Report different from exporting?
- An export is a copy of the figures on the day you downloaded it. XO Report inserts the same reports and lists as Excel tables that stay linked to Xero, so next month you change the dates and click Refresh instead of exporting and cleaning up again.
- Can XO Report export payroll or employee details?
- No. XO Report reads Xero accounting data and does not read payroll or employee records. For those, use the payroll reports and exports in Xero or in your payroll provider.
- Can I export several Xero companies at once?
- Not with Xero's own export, which works one company at a time. In XO Report you tick several companies and get one table, each row naming its company. Plans go by the number of companies: Solo 1, Lite 3, Pro 10, Business 25, Max 50.
- Does it follow an Australian or New Zealand financial year?
- Yes. Presets such as This financial year, Last financial year and Year to date read the company's year end from Xero, so a 30 June or 31 March year end works without typing dates (in a table with several companies, the first company's year end sets the dates). With Xero's own export you pick the dates by hand every time.
- Does XO Report change anything in Xero?
- No. It only reads. Every report, table and formula is a read from Xero, and the access you approve when you sign in has no write permission.
- Does it work on a Mac, in Excel for the web, or in Google Sheets?
- Yes. The same add-in runs in Excel on Windows, Mac and the web. In Google Sheets you get the reports and tables from a sidebar; the formulas, such as XO.BALANCE, are Excel only.