Live Xero reporting in Excel.
x0 securely connects Excel to Xero.
Authorise once with Xero, then refresh live business data directly into Power Query for Excel
No CSV or PDF exports, no manual imports, no copy-and-paste.
Data Flow
Your data lives in Xero. x0 transforms Xero's complex API into clean Excel-ready tables.
Xero
Your data
x0
cache tables
Excel Desktop
one-click refresh
Steps
- Sign up here.
- Authorise x0-connector in Xero for your data
- Open the Excel add-in (or paste your x0 API key into Power Query)
- Access clean, flat tables for accounts, invoices and much more
Enables
Your own sheets, driven by refreshable Xero data sheets for your take on
- Monthly Management Report
- Cashflow Forecast
- Budget Analysis
- Custom Dashboards
Built for more than Excel
The technology that enables Excel also works for
- Power Query
- Power Automate
- Power BI
- Microsoft Fabric
- OData
- REST API
For developers
Need a fake Xero Accounting API? The
Xero API simulator
is a hosted, read-only drop-in for api.xero.com —
OAuth2, pagination, rate limits, attachments.
Extra feature of Professional.
Connections
We also offer these features on advanced plans
- PostgreSQL access
- Xero API simulator
- Data zip bundles