> For the complete documentation index, see [llms.txt](https://integrations.drivetrain.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://integrations.drivetrain.ai/extending-drivetrain/microsoft-excel-add-in.md).

# Microsoft Excel add-in

Use Drivetrain’s Excel add-in to pull live plan data into Excel and stay synced with Drivetrain — work in the spreadsheet tool your whole team uses.

### Overview

The Drivetrain add-in for **Microsoft Excel** imports tables and lists from your Drivetrain boards into Excel worksheets, so you can analyze, format and present the data without exporting or copy-pasting. Each import is a **connection** between one board widget and one worksheet. Data refreshes when you sync; it does not update on its own.

You can import these widget types: **Table**, **Plan Table**, **List** and **Canvas** widgets that show a table.

* Import tables and lists from Drivetrain boards into Excel
* Refresh board data on demand
* Build charts and tables that update automatically as data changes
* Use live Drivetrain data in downstream workflows, including presentations in **PowerPoint**
* You need a Drivetrain account in the workspace you import from, and access to the board that holds the widget.
* Admins get the full widget, not limited by their own data access. Everyone else gets the rows their access allows, the same as when they open the board. See [Permissions and shared workbooks](#permissions-and-shared-workbooks).

### Installing the Drivetrain add-in

1. Open an **Excel workbook**
2. Go to **Add-ins → + More Add-ins**
3. Search for **Drivetrain**
4. Select the Drivetrain add-in and click **Add**
5. To open it, go to the **Home** tab and click **Open Drivetrain**

<figure><img src="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-399e4655241ec4e6b647bd699f4c843cedc11a3b%2Fmicrosoft-excel-add-in-01.gif?alt=media" alt=""><figcaption></figcaption></figure>

### Signing in

1. In **Your subdomain**, type your workspace subdomain. For `acme.drivetrain.ai`, type `acme`.
2. Click **Login**. A sign-in window opens your Drivetrain login page.
3. Sign in the way you normally do, with a password or your company's single sign-on. The window closes and the add-in opens.

<figure><img src="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-8765f55c6390e10848ce7caf14974bf2842dc1fa%2Fmicrosoft-excel-add-in-02.gif?alt=media" alt=""><figcaption></figcaption></figure>

To sign out, click the profile icon at the top right of the add-in. The menu shows your email; select **Logout**.

### Finding the chart ID

1. **Open the board** that contains the widget you want to import. The board must not be in edit mode.
2. Click the **vertical ellipsis (⋮)** on the widget
3. Select **Copy chart id**

**Copy chart id** appears only on Table, Plan Table, List and table-type Canvas widgets.

### Creating a connection

1. Open the add-in (**Home → Open Drivetrain**)
2. Click **Import** (or, if the workbook already has connections, the **+** button next to **All imports**)
3. In **Chart id**, paste the [chart ID](#finding-the-chart-id)
4. In **Import in sheet**, select the worksheet to import into
5. Click **Add**

<figure><img src="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-8611fca64e45830ad405945f0afcd0be5a0b469a%2Fmicrosoft-excel-add-in-03.gif?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
Each import first clears **all contents** of the selected worksheet, including your own values and formulas, then writes the widget data from cell A1. Fills, fonts and borders you applied are kept, but number formats in the imported range are replaced and merged cells in the old data and the import area are unmerged. Keep your own calculations on a different sheet and reference the imported one.
{% endhint %}

**Add** does nothing until both fields are filled. The data is written immediately and the worksheet becomes the active sheet. Allow up to a minute.

Each connection appears under **All imports** with the widget name (click it to open the board in Drivetrain), the worksheet name and when it last synced. Give each connection its own worksheet: two connections on the same sheet overwrite each other.

### What gets imported

The add-in imports the same file as the widget's **Download as Excel** option, generated on Drivetrain's side after checking your board access:

* **Board view:** the widget as the board opens by default, with its saved time range, filters, versions, scenarios and comparison series. Filters or a date range you change on the board in your browser, and unsaved changes to the widget, are not applied.
* **Values and formats:** the export's number formats are applied to the cells, and merged cells (such as column-group headers) stay merged.
* **Table and Plan Table widgets:**
  * Row labels are indented with four spaces per hierarchy level.
  * Every detail column is included, even inside a collapsed column group. The summary column a collapsed group shows in its place is left out.
  * The commentary column is included only when commentary is enabled on the widget.
  * Cells hold the underlying numbers, not rounded display values. Blank cells that the widget shows as zero come in as `0`.

### Syncing data

Data changes in Excel only when you sync. Scheduled sync isn't available in the Excel add-in: the **Schedule sync** option is greyed out.

* **One connection:** click the **refresh** icon on the connection.
* **All connections:** click **Sync all**. Connections sync one at a time, a couple of seconds apart.

The card shows **Syncing** while it runs, then **Synced** with the time. If you renamed the worksheet, the new name appears after the next sync. The list of connections also refreshes every minute, so changes made by others who use the same file show up.

### Editing and deleting connections

#### **Edit a connection**

1. Click the vertical ellipsis (⋮) on the connection and select **Edit**
2. Change the **Chart id** or choose a different worksheet in **Import in sheet**
3. Click **Save**

{% hint style="warning" %}
**Save** imports straight away and **clears all contents** of the selected worksheet. Data already on the previous worksheet stays there.
{% endhint %}

#### **Delete a connection**

Click the vertical ellipsis (⋮) on the connection and select **Delete**. The connection is removed straight away, with no confirmation step. Data already in the worksheet is not deleted.

**Edit**, **Delete** and the refresh icon are unavailable while that connection is syncing.

### Permissions and shared workbooks

* **Board access:** you must have access to the board that holds the widget, or the import fails.
* **Row-level access:** admins get the full widget, not limited by their own data access. Other users get the data their own access allows, the same as viewing the board.
* **Shared workbooks:** connections are saved in Drivetrain against the workbook, not against a user. Anyone in your workspace who opens the same file with the add-in sees the same connections, but each sync uses the access of the person who runs it. Two people can get different numbers in the same sheet.
* **Moved or copied workbooks:** if you rename or move the workbook, its connections follow it. A copy (for example with **Save As**) gets its own copy of the connections.

### Troubleshooting and FAQ

See [Excel add-in troubleshooting and FAQ](https://github.com/DrivetrainAi/gitbook-integrations/tree/main/en/extending-drivetrain/microsoft-excel-add-in-troubleshooting.md) for error messages, their causes and fixes.


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://integrations.drivetrain.ai/extending-drivetrain/microsoft-excel-add-in.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
