> 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/integration-guide/readme/spreadsheets.md).

# Spreadsheets

Integrate Drivetrain with Google Sheets, Airtable, SharePoint, and OneDrive. Automate data imports and remove manual copy-paste from your workflows.

Drivetrain seamlessly integrates with Google Sheets. Right now, you can also integrate the following tools directly by following the instructions provided below:

* [Airtable](/integration-guide/readme/spreadsheets/integrating-with-airtable.md)
* [Google Drive](/integration-guide/readme/spreadsheets/integrating-with-google-drive.md)
* [Google Sheets](/integration-guide/readme/spreadsheets/integrating-with-google-sheets.md)
* [Microsoft OneDrive](/integration-guide/readme/spreadsheets/integrating-with-microsoft-onedrive.md)
* [SharePoint](/integration-guide/readme/spreadsheets/integrating-with-sharepoint.md)

To connect other spreadsheet applications with Drivetrain, please contact your onboarding partner to help you get set up.

<table data-view="cards"><thead><tr><th align="center"></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td align="center">Airtable</td><td><a href="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-8c2fe408a95270469dea3ee80e4ae622f6b0f85d%2FAirtable.avif?alt=media">airtable-card.avif</a></td><td><a href="/integration-guide/readme/spreadsheets/integrating-with-airtable.md">Integrating with Airtable</a></td></tr><tr><td align="center">Google Drive</td><td><a href="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-98855866c09e16228162a5a6c6f709f0947c0730%2FGdrive.avif?alt=media">google-drive-card.avif</a></td><td><a href="/integration-guide/readme/spreadsheets/integrating-with-google-drive.md">Integrating with Google Drive</a></td></tr><tr><td align="center">Google Sheets</td><td><a href="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-60c4089f4aa9b3744648b2f50b1c032d9cab4bf5%2FGsheet.avif?alt=media">google-sheets-card.avif</a></td><td><a href="/integration-guide/readme/spreadsheets/integrating-with-google-sheets.md">Integrating with Google Sheets</a></td></tr><tr><td align="center">Microsoft OneDrive</td><td><a href="https://4220329029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmBZR0D9lq6jrI895OuOU%2Fuploads%2Fgit-blob-7a43ce74af9c1a86b6d1b49af537f3f14efd7c91%2FOnedrive.avif?alt=media">microsoft-onedrive-card.avif</a></td><td><a href="/integration-guide/readme/spreadsheets/integrating-with-microsoft-onedrive.md">Integrating with Microsoft OneDrive</a></td></tr></tbody></table>

<details>

<summary>How do I upload a CSV to Drivetrain?</summary>

You can upload a CSV to Drivetrain in a few different ways depending on what you want to do.

There are three main ways to import CSVs:

#### **1. Upload to a List** (for model-specific planning data)

Use this when you want to import planning data that evolves over time—such as headcount, hiring plans, or vendor lists—directly into a model.

In Drivetrain, a **list** is a lightweight dataset that lives inside a model and is versioned along with it. Unlike datasets that remain static across versions, lists adapt as your model changes. This makes them ideal for planning scenarios where values differ between model versions.

**To upload:**

1. Open your model and go to the **Lists** page.
2. Create or open a list.
3. Click **Upload CSV**.
4. Choose your file, then click **Validate and Save**.

**Notes:**

* The column names in the CSV must exactly match the list’s column names.
* Uploading a CSV overwrites existing rows unless you append data with the same structure.

👉 Learn more: Lists

***

#### **2. Upload via a spreadsheet or storage connector (recommended for recurring imports)**

Use this when you want Drivetrain to automatically fetch data from an external file—such as from Google Sheets, OneDrive, or cloud storage—on a recurring basis.

**To upload:**

1. Go to the **Data** page.
2. Click **+ New data source**.
3. Select a connector such as **Google Sheets**, **OneDrive**, **Google Cloud Storage (GCS)**, **SFTP**, etc.
4. Connect your account and provide the file URL or path.
5. Save the connection.

For OneDrive, GCS, or SFTP, you can place CSVs in the configured folder or bucket for scheduled ingestion.

👉 Learn more:

* [Spreadsheets & connectors overview](/integration-guide/readme/spreadsheets.md)

***

#### **3. Upload to update plan or forecast values for a variable**

Use this when you want to modify plan or forecast data directly in a model variable.

**To upload:**

1. Open your model and locate the variable you want to update.
2. Hover over it, click the vertical ellipsis (⋮), and select **Import/Export → Export CSV template**.
   * Edit the exported CSV and save it. *(Skip this step if you already have a prepared file.)*
3. Click **Import/Export → Import CSV**.
4. Review the preview popup for any errors and correct them if needed.
5. Click **Validate and Save** to complete the import.

Watch a walkthrough: [How to import plan or forecast data via CSV](https://www.loom.com/share/5a31e79cd2214261aac0709c2fcf3120)

</details>


---

# 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/integration-guide/readme/spreadsheets.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.