Back to Functions
XO.ORG
Get a list of all connected Xero organizations with their IDs and names. This is typically the first function you'll use to get the Org ID needed by other functions.
Syntax
=XO.ORG()
Parameters
No parameters required.
Returns
A spilling table with the following columns:
| Column | Description |
|---|---|
| OrgID | Organization identifier (e.g., "!abc123") |
| OrgName | Organization full name |
How to Use
- Type
=XO.ORG()in a cell (e.g., A1) - The function will spill into a table showing all connected organizations
- Reference specific cells in other formulas (e.g., use
A2for the first org's Org ID)
Examples
Get organization list:
=XO.ORG()Returns a table of all connected Xero organizations.
Use Org ID in another function:
=XO.BALANCE(A2, "4000", C1, D1)Where A2 contains the Org ID from XO.ORG().
Lock to first organization:
=XO.BALANCE($A$2, "6200", C1, D1)Use absolute reference to always reference the first org.
Tip
Click the "Insert into Active Cell" button in the task pane to quickly add =XO.ORG() to a cell. The function will automatically create a spilling table.