How to Export Invoices From Xero to Excel or CSV
There are actually two different problems hiding behind "getting Xero invoices into Excel." The first is exporting invoices or bills that are already sitting in Xero. The second, which trips up more small businesses, is what to do with invoices that never made it into Xero in the first place, because they're still sitting in an inbox as email attachments.
Exporting invoices and bills that are already in Xero
For invoices and bills you've already entered, Xero's own list views have an export option. Open Business > Invoices (for sales invoices) or Business > Bills to pay(for purchase bills), select the records you want, and use the export control on that screen. Most of Xero's reports, things like Aged Receivables or a Sales report, also have their own Export option that can produce a CSV, Excel, or PDF file, which is often the more flexible route if you want a specific date range or set of columns rather than a raw list of every invoice.
Xero updates its interface fairly often, so the exact button labels and menu wording can shift between versions. Rather than guess at screenshots that might already be outdated by the time you read this, the most reliable source is Xero's own help article, "Export invoices and bills" on Xero Central, which is kept up to date with whatever the current UI looks like.
What you actually get in the export
A standard invoice or bill export typically gives you one row per invoice (or per line item, depending on the report), with fields like contact name, invoice number, date, due date, and total amount. Tax is usually included in the total rather than broken out as its own column by default, though several of Xero's reports let you add a tax column if you need it split out. If the built-in export doesn't include a field you need, a report with customizable columns is usually a better starting point than the plain invoice list.
What's worth exporting versus what isn't
Not every invoice export is worth doing through the raw invoice or bill list. If you just need a one-off summary for a specific date range, a report like Aged Receivables, Aged Payables, or a general Sales report is usually faster than filtering the full list down to what you need, and most of Xero's reports let you pick a date range before exporting rather than exporting everything and trimming it afterwards.
One thing worth checking if an export looks incomplete: repeating invoice or bill templates (the ones Xero generates automatically on a schedule) are templates, not individual transactions, until an actual invoice has been generated from them. A standard export of your invoice or bill list reflects generated transactions, so a repeating template with nothing generated yet for the period you're exporting won't show up as a line of its own, look at the generated invoices themselves rather than the template.
The bigger problem: invoices that aren't in Xero yet
None of the above helps with the invoice sitting in your inbox right now that nobody has entered into Xero yet. For a lot of small businesses, that's actually the more time-consuming part of the whole process: someone has to open the email, open the PDF, and manually key the vendor, amount, and date into Xero (or straight into a spreadsheet) before an export is even possible. The export itself is the easy five minutes at the end, the real cost is everything that happens before that.
Why the inbox, not Xero, is usually the actual bottleneck
A mailbox used for business correspondence gets more than invoices, quotes, delivery notes, newsletters, and plenty of attachments that have nothing to do with bookkeeping all land in the same place. Anything that automatically processes incoming mail needs to tell invoices apart from everything else, rather than treating every PDF attachment as a transaction to enter. That works more reliably when it's based on what's actually in the document, an invoice number, a total, a tax line, rather than keywords in the subject line, which vary wildly from one vendor to the next.
Duplicates are the other recurring headache: some vendors resend the same invoice by accident, or a payment reminder includes the original attachment a second time. Without a duplicate check, the same invoice ends up entered twice, something that usually isn't obvious until it's thrown off a bank reconciliation and someone has to go hunting for why the numbers don't match.
Three things worth checking before you change your process
Before changing how you handle invoices, it's worth answering three questions: how many different senders and mailboxes your invoices actually come through right now (a single inbox is far easier to automate than five scattered ones), whether your invoices mostly arrive as PDF attachments or embedded directly in the email body (the latter is rarer, but a genuinely different case to handle), and what shape you actually need the data in at the end, a plain spreadsheet, or inside Xero itself. The answers to those three questions determine how much of the process you can realistically automate and where manual review still makes sense.
Getting email invoice data into Excel without typing it in first
If what you actually want is clean, structured invoice data in a spreadsheet, and the invoices arrive by email, there's a more direct route than entering everything into Xero and exporting it back out again. InboxDoc connects to your Gmail or Outlook inbox, recognizes incoming invoice emails automatically, and extracts vendor, amount, tax, invoice number, and date straight from the attachment, whether it's a plain PDF or a structured e-invoice. The result exports directly to Excel, which means you can skip the round trip through Xero entirely for invoices you just need recorded somewhere, not reconciled against a bank feed.
This isn't a replacement for Xero if you're already using it for full double-entry bookkeeping, it's a faster path to the data when what you need is a clean export, not a complete accounting record. If you're weighing that trade-off, our guide to handling invoices without accounting software and the InboxDoc pricing page cover how the two approaches compare in practice.
A reasonable way to phase it in
You don't have to change everything at once. A common starting point is automating the invoices that come through a single, highest-volume inbox first, while less frequently used secondary mailboxes stay on the old manual process for now. That keeps the risk low while you get comfortable with a new workflow, and it's easy to extend to additional mailboxes once the first one has proven itself.
Start a free trial and process your first 5 invoices at no cost, no credit card required. Try InboxDoc.