Export Invoices From Xero to Excel and CSV

Last updated June 2026.

Xero exports invoices to a CSV file rather than a native Excel file, and that CSV opens straight in Excel. Open the Business menu, select Invoices, pick the tab you want, use Search to filter by date or status, then click Export. Each line item lands on its own row, Xero caps every export at 500 transactions, and for a fuller, cleaner spreadsheet you run the Receivable Invoice Detail report and export that instead.

Most people expect a one-click button to send a single invoice to Excel. Xero works a little differently. It exports a CSV of the whole invoice list, and reports give you the more detailed spreadsheet. Below are the exact steps for sales invoices and bills, how to keep your line items, the 500-row limit and how to work around it, and what to do when an export fails or comes back missing data.

Xero export methods at a glance

How to export sales invoices from Xero to Excel

The CSV that Xero produces opens directly in Excel, so this is the route most bookkeepers use for sales invoices.

1. In the Business menu, select Invoices.
2. Select the invoice tab you want to export, for example All, Awaiting Payment, or Paid.
3. (Optional) Click Search and set a Start date, End date or date type to narrow the list, or filter by status.
4. Click Export. Xero downloads a CSV file containing those invoices.
5. Open the CSV in Excel. If commas or accented names break the columns, use Data > From Text/CSV and set the delimiter and encoding by hand.

Each transaction line item shows on its own row, so a three-line invoice produces three rows that share the same invoice number, contact and date. That is deliberate: the layout matches Xero's own import template, so the file can be reimported later. One caveat on permissions: a user with an invoice-only role can run the export, but some fields such as contact address details come back blank.

How to export bills (purchase invoices) from Xero

Exporting the bills you owe to suppliers follows almost the same path, just from the payables side.

1. In the Business menu, select Bills to pay.
2. Next to New Bill, click the menu icon (the three dots).
3. Select Export bills.
4. Check that the details are correct, then click Export. Xero downloads the CSV to your computer.

The same 500-transaction limit applies, so if you are pulling a busy quarter of vendor bills, filter by date first or export in batches.

How to export Xero invoices with line items

The plain invoice export already puts each line on its own row, but it leaves out account codes and some customer detail. For a complete line-by-line spreadsheet you use a report instead.

1. In the Reporting menu, select All reports.
2. Open the Receivable Invoice Detail report for sales, or the Payable Invoice Detail report for bills.
3. Set a date range, or click the arrow next to the date to choose a set reporting period.
4. Click Export and choose the spreadsheet format.

You need the advisor, standard plus reports, or read-only user role to open these reports. The Receivable Invoice Detail report shows every sales invoice, credit note and overpayment line by line, which is the format you want for analysis or for moving the data into another system. Reports also sidestep the hard 500-row cap, so a date-bounded report export is usually faster for a full year of history.

Can you export a single invoice from Xero to Excel?

No. Xero has no button to send one invoice straight to Excel. To get a single invoice out, open it and print or save it as a PDF, or export the full list as a CSV and delete the rows you do not need. If you specifically need that one invoice as structured spreadsheet data, the fastest path is to run the PDF through an OCR converter, which reads the fields back into clean columns.

How do I export all invoices from Xero at once?

Go to Business > Invoices, leave the tab on All (or filter by date), and click Export to download every matching invoice as one CSV, up to 500 at a time. For a complete history with more columns, run the Receivable Invoice Detail report over the full date range and export that to a spreadsheet, since reports are not held to the 500-row limit.

Does the Xero invoice export include line items?

Yes. The CSV export lists each line item of an invoice as its own row, repeating the invoice number, contact and date on every line. That layout matches Xero's own import template, so the same file can be reimported without reformatting. If you also need account codes and tax detail on each line, the Receivable Invoice Detail report is the cleaner source.

How many invoices can you export from Xero at one time?

Xero exports up to 500 transactions per file. If your date range holds more than 500 invoices or bills, split the job into batches by narrowing the dates or filtering by status, then export each batch. Because the detail reports are not capped the same way, a single date-bounded report export is often the simpler route for large histories.

Why won't my Xero invoices export?

The most common cause is special characters sitting in an invoice, a contact record, or your organization details. Remove any unusual symbols from those records and try the export again. Also confirm your user role allows it: an invoice-only role can export, but it will leave some fields, such as contact addresses, blank, which can look like a broken file.

The other direction: getting vendor invoices into Excel and Xero

Exporting your own sales invoices is the easy half. The harder half for most accounts payable teams is the invoices that arrive from suppliers as PDFs or scans, because those have no export button at all. That is where an invoice OCR tool earns its place. Upload the PDF and it reads the vendor, dates, totals and every line, then hands back a clean spreadsheet. You can convert PDF invoices to an Excel file for review, pull out each line item for matching, or push the captured data into Xero instead of retyping it. For teams processing a high volume of supplier documents, that same automated capture removes the manual data entry that the export side never had to deal with. The same export-then-capture workflow applies if your books live in QuickBooks; the steps to export QuickBooks invoices to Excel follow the same logic.

A few adjacent jobs land on the same desk during a Xero close. If you are reconciling accounts, you can convert PDF bank statements to Excel the same way you handle invoices. Expense claims that come in as photos can be turned into rows with a receipt to spreadsheet converter. And when approvals and payments are the real bottleneck rather than data entry, a full accounts payable automation workflow takes over once the data is captured. Each one starts with getting messy documents into structured data, which is the same problem the Xero export solves on the outbound side.

Exporting from Xero is straightforward once you know it produces a CSV rather than a per-invoice Excel file: filter the list, click Export, and reach for the Receivable Invoice Detail report when you need richer, uncapped detail. For everything coming the other way, let OCR do the typing.