> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/documentation/guides/integrations-and-connectivity/xxxxxxxconnecting_excel_to_bevica_-web_services_and_odata.md).

# Connecting Excel to Bevica (Web Services & OData)

Connect Excel to live Bevica data in Business Central using Web Services and OData V4. Publish a page, copy the OData URL, then use Excel Get Data and Refresh.

Business Central offers users the ability to query page data in Excel using Web Services. This allows users to have real-time Business Central data available in Excel sheets that can be queried and saved for future use.

{% hint style="warning" %}
**Prerequisites**

Bevica Setup.

Excel query knowledge.

Bevica and Excel under the same Microsoft organisational account.
{% endhint %}

{% hint style="info" %}
**Note**

Performance may be impacted if you are linking to large data sets.
{% endhint %}

{% embed url="<https://youtu.be/P1ZYnFQ1E9Y>" %}

The video takes you through the **Reporting Data Setup** wizard, the article shows you how to do the same thing manually.

### Bevica Web Service Setup

In Bevica navigate to the **Web Services** page. Here you will create a new record for the Page you want to make available externally.

* Click **New**
* Set the **Object Type** field to **Page**
* Enter the Page number in **Object ID** field
* Give the record a unique **Service Name**
* Tick **Publish**

Once this has been done, copy the **OData V4 URL** value for your new record.

Page numbers can be found by navigating to the specific page and opening the **Page Inspection** side bar (Ctrl + Alt + F1).

### Excel 'Get Data'

In Excel, you will set up an OData Feed to the newly created Web Service.

* Select the Data tab in Excel, Get Data, From Other Sources, **From OData Feed**.
* In the dialogue box that appears, select **Basic** and paste the **OData V4 URL** into the URL field below.
* Click OK.
* You may be prompted to sign in, if so, click **Organisational Account** and sign in.
* If successful, you will see the Bevica data from the web service page. Click **Load**.

Once the link has been established and data imported for the first time, the data can be refreshed in Excel, from the Query tab, **Refresh**.

You can link additional Bevica pages on new tabs and use Excel reporting (Pivot Tables, Charts) to provide enhanced reporting.

{% hint style="info" %}
**Note**

The data in Excel is a copy of Bevica, updating it in Excel will not update Bevica.
{% endhint %}


---

# 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://kb.bevica.com/documentation/guides/integrations-and-connectivity/xxxxxxxconnecting_excel_to_bevica_-web_services_and_odata.md?ask=<question>&goal=<endgoal>
```

`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.