If you do your real work in Excel but your data lives in Xero, you've got a gap to bridge. There are a few ways to close it, and they're not equal.

Most firms weigh the options on the wrong thing first. They compare on price or on whether a setup is technically possible. Both matter. Neither is the question that actually decides it.

The question that decides it is simpler: how many people need this data, and how often does it change? Answer that honestly, and the choice mostly makes itself.

There are three ways to connect Xero to Excel: manual export, a custom-built connector, or a purpose-built two-way add-in. Manual export is free but always out of date. Custom connectors are technically possible, but Xero's API costs and setup make them tough to justify, and they're one-way and tied to one login.

If you do your real work in Excel but your data lives in Xero, you've got a gap to bridge. There are a few ways to connect Xero to Excel, and they're not equal.

Can you connect Xero to Excel for free?

Yes. Manual export is free and built into Xero. Run a report, export to CSV or Excel, then format it and drop it into your workbook. For a single number, or a quick check you'll never touch again, it does the job and costs nothing.

The trouble starts when the export becomes part of a workflow. A CSV comes out raw: columns in an order you didn't ask for, dates read as text, totals you have to rebuild. So the "free" pull carries a formatting tax every time, and that tax lands on every file, every period.

Then there's the bigger issue. An export is a snapshot. The moment a client posts a transaction, recodes an account, or reconciles a new batch, your workbook is showing yesterday's Xero. Nothing in Excel tells you. You find out at review, when the figures no longer tie.

And it only runs one way. Anything you adjust in Excel stays in Excel. To get it back into Xero you key it in again by hand, which is a second pass and a second chance to make a mistake.

Best for occasional, one-off pulls where the number won't change and nobody else needs it.

Can you connect Xero to Excel with Power Query or a connector?

Not in a way that holds up. It's technically possible to pull Xero data through a custom-built connector, but Xero’s API access comes with security requirements and costs that make a proper build hard to justify for most firms. On top of that, setup takes real technical know-how, the connection is usually one-way (read-only), and it's often tied to one person's login. When they're out, someone has to rebuild it. For most firms it isn't worth the setup or the cost.

Is there a Xero add-in for Excel?

Yes. RadiusCore is an Excel add-in that connects Microsoft Excel directly to Xero, with two-way data sync. You pull a report into your workbook, refresh it with a click when the data moves, and push changes back to Xero from the same place. No exporting, no reformatting, no switching apps.

The part that matters for a firm is how the connection is shared. You connect each client once, and that connection is available across the firm, so anyone on the team can open the file and refresh current data. Nobody's rebuilding a setup or hunting for whose login it sits under.

It also handles multiple organisations, so a client with several entities isn't a special case or a separate build. You work them the same way you work everyone else.

More than 450 accountants and 10,000+ Xero entities run on it, so this isn't a prototype. It's a daily tool for firms already working the way you do.

Which way is right for you?

It comes down to how you actually work, not which option looks cheapest on the surface.

• If you only pull Xero data now and then, and it's just you, manual export is fine. Don't pay for a tool you'd use twice a year.

• If one person runs repeat reports and never needs to push anything back, a custom connector can give you read-only reporting, but Xero's API cost and upkeep mean it rarely pays off.

• If your firm lives in both tools and you want the data current, shared across the team, and flowing both directions, a purpose-built add-in is the one that holds up.

The line most firms cross is the team line. On your own, pulling a figure once in a while, almost anything works. The moment two people need the same client's data, or that data changes after you've pulled it, the free and the technical options start costing you in ways that don't show up on an invoice: the re-pulls, the rebuilds, the review notes when a workbook doesn't tie.

How much does it cost?

Manual export is free and built into Xero. Custom connectors are prohibitively expensive once you add up the development and Xero API costs. RadiusCore's Excel add-in starts at $75/month, with a 30-day free trial and no credit card required.

FAQ

• Can Excel connect to Xero directly? Yes, with an Excel add-in like RadiusCore, so you can pull reports, refresh, and push changes back without exporting files by hand.

• Can you push data from Excel back to Xero? With manual export and most connectors, no. A two-way add-in like RadiusCore lets you push changes back.

• Do you need to be technical to connect Xero to Excel? Manual export takes manual work. Connectors take real technical setup, plus Xero's API hurdles. A purpose-built add-in is built for accountants and doesn't need IT.