# Maintaining Master Data in Bulk

### Overview

To help maintain your configuration, you can bring your TilliT data into Excel via Add-in.

While everything in the add-in is available via the UI, using Excel allows you to edit, copy, paste, backup, etc. all your Master Data.

The video below shows an example of how to use this feature effectively.

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

### Accessing the Master Data

Depending on which environment you're accessing, click the ***TilliT DO Stage*** tab (Stage) or ***TilliT*** tab (Production), then click the ***Data*** button.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b537840b51ec1ae83fa040/file-BMpRbsLIUa.png)

A menu will pop up on the right, providing the following options:

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b5385c03382e4311cee222/file-RoTVi7QaAO.png)

There are two (2) types of data you can access. Config data (data defining behaviour of TilliT) and Instance data (data submitted during an order).

* **Asset hierarchy** - manage Site, Asset and Shift config data.
* **Material definition** - manage Material config data.
* **Activity Template** - manage Activity and Option Group config data.
* **Edge** - manage Edge config data.
* **Orders** - manage Order instance data.
* **Activity Results** - manage Activity instance data.
* **Events** - manage Event instance data.
* **Shifts** - manage Shift instance data.
* **Integration** - manage Integration config data.
* **Configuration**:
  * **Attributes** - manage Attribute config data.
  * **Dashboard Groups** - manage Dashboard Group config data.
  * **Event Types** - manage Custom Event config data.
  * **Process Variable** - manage Process Variable config data.
  * **Unit of measure** - manage Unit of Measure config data.
  * **Order Template** - manage Order Template config data.
  * **Attribute Groups** - manage Attribute Group config data.
* **Scheduler Settings** - manage Scheduler config data, if you are using the TilliT Scheduler solution.
* **Scheduler Orders** - manage Scheduler Order instance data, if you are using the TilliT Scheduler solution.

When you select once of the above ***Groups***, you'll be asked to select an entity. To understand the various entities, you will need to understand the data you're accessing. This is best done by reading through the various articles in Setting up TilliT.For this following example, we'll use one of the most commonly used groups, Activity Template, and click on the ***Activity Template Item*** entity.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b53eedc74a080359c836da/file-bA9NqbgFpu.png)

Once you've selected an entity, you will be asked to define the ***Page size*** (how many results should be given per page/excel sheet) and which ***Page*** number you wish to load. For example, if there are 20,000 entries in TilliT, setting the Page size to 2,000 will divide the data into 10 pages. Only one (1) page can be loaded at a time, so you would need to choose which page using any number between 1-10.This helps when dealing with a large number of entries.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b5411fc74a080359c836e2/file-1fkNcRD15f.png)

This will load all Activity Template Items in our data.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b54468c393f271f28b454c/file-gO55EQEuhw.png)

You can also refine what is loaded by filtering by a field from the data. In our example, we will look for a specific Item Key.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b541090b51ec1ae83fa055/file-5MoukT9fMd.png)

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b54234360964399e46a709/file-bcKWUqUmUX.png)

Now we have only loaded the precise data we wish to work with.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/60208fd212248b2c96d50eeb/images/62b5449703382e4311cee238/file-BSc5DZou5v.png)


---

# 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://help.tillit.cloud/tillit/tools/excel-add-in/maintaining-master-data-in-bulk.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.