DataDear is a wonderful Excel Add-In designed for

DataDear takes the Xero Accounting experience to the next level by allowing you to work on Excel and retrieve and push data from Xero

DataDear is beyond a mere data download tool – it LINKS your Xero organisations to your spreadsheet


Extend Xero’s reach on your Excel.

Get the transactions you need from Xero tables. Work with your data however you deem best.


Download and build your reports.

Download Xero reports or create your own reports and charts using Ms Excel native functionality.


Upload data created in Excel.

You now can post data (such as journals & invoices) from Ms Excel into Xero with workings as attachments.


Add as many organisations as required.

Easily add multiple organisations directly from Excel or from YOUR Dashboard.

Powerful Toolbar

Native Excel toolbar designed for Xero.

Connect Excel and Xero via a dedicated toolbar to manage & transform your data.

Central Dashboard

Cloud-based dashboard to manage add-on.

Manage your account, backup data, multiple organisations & template library.

Consolidated Reporting

Report against a group of companies.

Generate a consolidated Balance Sheet, Trial Balance or Profit & Loss over multiple periods for your group.

DataDear Experts

A directory of gurus at your service.

Need to build a complex report or connect to your reporting pack? Engage with a DataDear Expert!

Collaborative Tool

Collaborate with your staff & clients.

Share the Xero organisations with your staff & clients so they can refresh data and reports you create.


Xero Add-on Logo

DataDear can be easily connected to single or multiple Xero organisations

DataDear app connects to Xero


You are a click away from connecting your Xero organisations to DataDear Excel Add-in.


You can create a data feed and push data back in Xero directly from your Excel.


DataDear fully utlizes the Xero integration giving you access to all tables & reports.


Your data remains securely stored on Xero’s servers.

DataDear is trusted by thousands of accountants and firms across various industries worldwide

Accountants and firms using DataDear

We value your privacy and data security!
With DataDear you have full control over which data gets accessed and by whom. All information temporarily passing on our server uses bank-level SSL technology for secure data transmission.

Free 30 day trial • No credit card required • No obligations