# Excel Connection

{% hint style="info" %}
Check out the given illustration on how to create an Excel connection and associate it to a charting component.
{% endhint %}

<figure><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FLzR4bexiaz9gQMdtB9UV%2FExcel%20connector.gif?alt=media&#x26;token=e6cb8831-e073-4bef-8653-d59aad913471" alt=""><figcaption></figcaption></figure>

* Click the ***Data Connectors*** icon to display all the available data sources.
* Click the ***Create New Connection*** icon  provided next to the ***Excel*** option.
* A new connection gets added under the Excel connection type.
* The connection-specific details get displayed on the right side of the page.     &#x20;

![Creating an Excel Data Connection](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FAjxIS1gr39D2IO0V9in3%2Fimage.png?alt=media\&token=37b3e023-0730-44e6-adf1-277240dbc8d4)

* Configure the following information:
* ***Name*****:** Name the connection.
* ***Browse:*** Click the ***Browse*** icon to browse an Excel file.
* ***Sheet Name*****:** Select a specific sheet using the drop-down menu.
* ***Load at Start*****:** Enable this option to get the updated data from the data source before loading it into charts.
* The ***Field Set*** tab displays all the fields after establishing the data connection.

![Configuring the connection and getting the data](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FmHs2gwStIcJraSCEt9Yt%2Fimage.png?alt=media\&token=3f9130c1-58ee-4196-8954-3b2920bee777)

Select the ***Condition*** tab and provide a condition to be applied as a filter on the selected data by putting checkmarks in the given boxes.&#x20;

E.g., The selected Conditions for the ***Category*** field is ***Catalog***.

![The Condition tab](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FrBoi3eLXjfdMcQATDEnA%2Fimage.png?alt=media\&token=c78764c9-8462-4891-86ee-b1e7c9365d89)

* Select the ***Script on Load***  icon to trigger a script to produce some action on the connection.