Getting MYOB or Xero data into Excel using OdataLink is extremely simple and easy.
This is because most versions of Excel (from Excel 2013 onwards) already includes a native OData connector. As such, you do not need to download any additional software to use your data (note if you are using Excel 2010, you will need to get the Power Query addin).
Once OdataLink is configured, accessing your data is as simple as copy and pasting a url.
You can see it in explained and in action in the following video.
To get data into Excel using OdataLink, follow these steps.
- Go to app.odatalink.com OData Feeds page.
- Find the OData feed you want to use and click Copy.
- Go to Excel.
- Using the Data ribbon, click New Data, then choose From Other Sources and OData Feed
- Paste the url copied and click OK.
If you are new to Power Query and Excel, we strongly recommend you check out this Introduction Tutorial to Power Query.
Additionally, if you have trouble finding specific the fields within Excel, we recommend you check out this article.