> For the complete documentation index, see [llms.txt](https://docs.wem.io/platform/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.wem.io/platform/wemtipsandtricks/working-with-data/consuming-your-odata-source-with-excel-2016.md).
# Consuming your OData source with Excel 2016
In 2019 we added the feature to expose the data of your WEM application with OData. This allows other applications to easily access and modify the data of your application. In the article [Expose your data via OData](https://github.com/zoombim/Public-Documentation/tree/09466aea1b73d2e87a60fac4ae6557406b4c032f/public/documentation/tips-and-tricks.data.expose-data-odata) you can read how this works in WEM, and how you can load your data into Excel 2013.
In Microsoft Excel 2016, things have changed a little bit. To connect to an OData source, you still go to the **Data** tab, but then you choose **New Query** > **From Other Sources** > **From OData Feed**.
You now get a popup where you can specify the URL to the OData feed. For this example, I again use the demo application . Make sure you add that last slash at the end of the url!
After you click **Ok**, it will prompt you for the user credentials. Select **Basic** and enter the username and password. The username and password for the demo application are `demo` and `demo1234`.
After you click on **Connect**, you will get a popup where you can choose which tables you want to import into Excel. In my case I choose "*Select multiple items*", and select all tables. Next, click on **Load**.
The panel "Workbook Queries" will appear on the right side of excel. This panel will list all the tables you chose to import. When you hover over these tables, a popover will appear that will preview the data and allow you to edit the query. This allows you to apply filters, and to combine data from multiple tables. In my case I simply want to import all the data from the `Companies` table, so I click on the three dots (•••) and choose the option **Load To...**.
I can now choose to view this data as a Table and either load it into a new worksheet, or into an existing worksheet. In my case, I choose *Existing worksheet*. Finally, I click on the button **Load**, and the data will be imported into Excel.
Excel will store the connection to the OData feed in the excel document, so the next time you open this document, you can go back to the **Data** tab and click on the **Refresh** button to retrieve the updated data from the OData feed. If you want to see the workbook queries again, you can click on the button **Show Queries**.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.wem.io/platform/wemtipsandtricks/working-with-data/consuming-your-odata-source-with-excel-2016.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.