> For the complete documentation index, see [llms.txt](https://help.tillit.cloud/tillit/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.tillit.cloud/tillit/tools/excel-addin-v2/timeseries.md).

# Timeseries

### Overview

The **Timeseries** button lets you export process variable readings from TilliT into Excel. You select an asset, a process variable, and a time range — the data is then loaded into a new Excel sheet.

For data to be available, Process Variables must first be configured in TilliT and must be actively capturing data.

### Opening Timeseries

In the **TilliT V2** ribbon tab, click the **Timeseries** button.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FN3YCeVVrC1ajqkQ0ikfu%2Fimage.png?alt=media&amp;token=711de6f8-817f-4942-8642-48409b3b6f8f" alt=""><figcaption></figcaption></figure>

The task pane will open showing the Timeseries view. Click **Add** (or the **+** button in the header) to start loading data.

### Loading Timeseries Data

#### Step 1: Select Asset

Select the asset whose process variable data you want to export. All active assets in your TilliT configuration are listed.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FnH41q3uLDWWDCPi2qJxd%2Fimage.png?alt=media&amp;token=7b678cb7-48c2-4119-acd4-fb9fc00d46b9" alt=""><figcaption></figcaption></figure>

#### Step 2: Select Process Variable

Select the process variable you want to export from the list of variables configured for the selected asset.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FgVsvxV2ULm29pX3QOl2S%2Fimage.png?alt=media&amp;token=8839dd79-98ee-4383-955d-48e9b13f92b0" alt=""><figcaption></figcaption></figure>

#### Step 3: Time Selection

Choose how to define the time range for the export:

* **Today** — all data from the current day
* **Yesterday** — all data from the previous day
* **Pick a date** — all data from a single specified day
* **Pick a start and end time** — data within a specific time window (within 24 hours)

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FEqZpN6xIrhGBptsbz6QT%2Fimage.png?alt=media&amp;token=9561e0f1-129f-41ab-bbbf-0e3299f04d02" alt=""><figcaption></figcaption></figure>

**If you choose "Pick a date":**

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2FP3OzmmOuhI1sg3irYezJ%2Fimage.png?alt=media&amp;token=4bcdf7a0-6fc1-400f-89de-11f49473be8a" alt=""><figcaption></figcaption></figure>

A date picker appears. Select your date, then click **Next**.

**If you choose "Pick a start and end time":**

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2Fx5YfcEluqOS0pn5thTcA%2Fimage.png?alt=media&amp;token=31fc98d5-c49a-4cb2-a82b-5380968941cf" alt=""><figcaption></figcaption></figure>

Two date-time pickers appear — one for the start and one for the end. The window cannot span more than 24 hours. If the selection is invalid, an error message will appear. Click **Next** when ready.

#### Step 4: Configure & Load

Before loading, you can optionally customise the **Sheet name** — this is the name of the Excel sheet the data will be placed in. By default it uses the process variable name.

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2Fh50ZlsDUkUeyRz39gXwh%2Fimage.png?alt=media&amp;token=ef32cb35-0d3f-4b82-8b16-e947abd360d1" alt=""><figcaption></figcaption></figure>

Click **Load Data** to export the readings into Excel.

### Viewing the Data

The timeseries data is loaded into a new sheet. The sheet contains columns for the timestamp and reading value, and is named after the process variable (or the custom sheet name you provided).

<figure><img src="https://352909507-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrNT40XJFAFlAhUX8CcQS%2Fuploads%2F2l7NdTPs4BFKc4K8kj0o%2Fimage.png?alt=media&amp;token=f6ae9025-f5e1-4995-acf3-930bb0268e38" alt=""><figcaption></figcaption></figure>

The task pane will show a card for the loaded timeseries source.