# Excel add-in functions

![](/files/-Mda1XpIQfR7SEbMb9gg)

### Create data clip(s) from an Excel table

**Settings**

Set an url and log in to the platform

**Create (or update) a data clip**

First you have to create an Excel table with one unique ID column. Then select the table by placing the cursor in the table. Press the button "Create" in the header bar. Follow the wizard steps en if necessary replace the value types of the data fields. 

Choose the unique ID column**,** enter a name for the data clip and finish creating the data clip.

**Send data**

By pressing the button "Send Data" all data from tables which are binded to a data clip will be send to the platform (collection).

### Create an Excel table from an (existing) data clip 

**Data clip**

Press the button "Data clip" and you can select one of the available data clips. Follow the wizard steps and you can insert a table in a worksheet. After you have created a new table in a worksheet you can update data by changing the cells in the table and press the button Send data in the toolbar of the Any2info tab. 

**Note:** Do not change the ID column by updating the data clip content!

**Note:** Be sure you have an active connection - See Settings in the toolbar of the Any2info tab.

### Create an Excel table from selectable data from a form

**Forms**

Press the button "Forms" and you can select one of the available forms in the collection you are connected to. The form content will appear on the screen and you can select fields or by selecting it in the checkbox on the left or by double clicking on the field in the form. Follow the wizard steps and the form data will be inserted in an Excel work sheet.

### Other functions

**Manage bindings**

Monitor or remove the actual bindings.

**Display text items**

Select text fields in a worksheet and send them to the platform for use as display texts.

**Export group items**

Specific function in relation to a master forms.

**Export forms**

Specific function in relation to subforms.


---

# Agent Instructions: 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:

```
GET https://academy.any2info.com/any2info-academy/quick-start/install-excel-add-in/excel-add-in.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.