Add an OData interface to query live transaction data directly from Microsoft Excel
Microsoft Excel is an essential tool for all accountants. It can be easily configured to consume an OData data source. OData is a standardized protocol for creating restful data APIs. This XML-based protocol supports the ability to create filtered data streams. By exposing live transaction data through a secured, well-engineered OData API, you will be adding massive value to your customers accounting data. OData combined with Excel Pivot Tables and PowerPivot creates an incredibly potent analysis and reporting tool. All your customers already own Excel. PowerPivot is a free add-in from Microsoft. All that's needed is an OData API and a bit of instruction. More info: http://www.odata.org/ http://www.microsoft.com/en-us/bi/powerpivot.aspx
Martin Danner
shared this idea
We have no plans to support OData, preferring to stick with our technology agnostic web services API with OAuth authentication.
There are however, a number of commercial add-ons available using our API, providing Excel integration:
http://www.businessbackbone.co.uk/xero-excel-reporting
http://www.quickwindevelopment.com/addons/excel-integration-tools/
-
Peter Black
commented
OData is an Oasis standard, and is completely technology agnostic. Is your API and open standard?
-
Altin
commented
I would like to add one more Excel Add-in for Xero, developed by Cdata Software.The Xero Excel Add-In is a powerful tool that allows you to connect with live Xero accounting data, directly from Microsoft Excel. Use Excel to read, write, and update Xero Customers, Transactions, Invoices, Sales Receipts, etc. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
For more info go to: https://www.cdata.com/drivers/xero/excel/