Get MYOB AccountRight Live or MYOB Essentials data into Excel the easy way, using OdataLink.
MYOB OData feed provider for Excel
OdataLink is an OData feed provider that shapes the data from MYOB AccountRight Live or MYOB Essentials into a format that can readily be used by Excel. It does this without the need for any external software, additional setup or complex programming.
OdataLink is compatible with most versions of Excel:
- Excel 2010 and 2013 (with the Microsoft Power Query addin)
- Excel 2016 and 2019
- Office 365
With OdataLink, accessing your data is as simple as copying a URL and selecting the endpoints to retrieve. This approach completely bypasses the need for databases and data warehouses. Your data can be directly manipulated within Excel using Power Query.
In fact, OdataLink provides a live link to your data. In addition, any filtering or sorting is sent directly to MYOB for processing.
Over 90+ MYOB endpoints available
OdataLink provides over 90+ endpoints ranging from:
- Profit and Loss and Balance Sheet data
- Sales, Sales Orders and Quotes
- Purchases and Purchase Orders
- Payroll
- Other transactions such as Spend Money, Receive Money, etc.
- And above all, meta data such as Accounts, Jobs, Items, etc.
Why use OdataLink instead of ‘MYOB for Excel’ addin?
While simple to use, the ‘MYOB for Excel’ addin has many limitations. This simple guide lists all the benefits OdataLink has to start getting MYOB data into Excel.
Get Started with OdataLink
Register for your 30-day trial.