> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hightouch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Excel

> Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.

## Overview

Hightouch lets you pull data stored in Microsoft Excel and push it to downstream destinations. Before connecting your Microsoft Excel source, it's best to make sure they meet the formatting requirements.

## Microsoft Excel formatting requirements

* Your Microsoft Excel workbook must be a `.xlsx` file. Other extension workbooks, for example, `.xls` or `.csv` aren't supported. [Convert your file](https://answers.microsoft.com/en-us/msoffice/forum/all/converting-xls-to-xlsx/ba8d05f4-d38a-462a-a062-d6083db4b479) if necessary.
* Your Excel worksheet must have column names in the first row. In the following image, you can see that the column names are `Country`, `Product`, `Discount Band`, `Units Sold`, and ` Manufacturing Price` etc.
* To ensure accurate processing, all valid data must be present in the top-left portion of the sheet. If a column name is left empty, the preceding column will be treated as the last column in the file. Similarly, if a row is left empty, the preceding row will be considered the last row in the file, and any subsequent rows will not be processed.

![Microsoft Excel Example](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/sources/source-microsoft-excel.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=3ea39257ea4a913f57c26c0ab13b7f03)

## Connection configuration

To get started, go to the [**Sources** overview page](https://app.hightouch.com/sources?from=docs) and click the **Add source** button. Select **Microsoft Excel** and follow the steps below.

### Authorize connection

1. Click **Log in to Microsoft Excel** and select the desired Microsoft Account.
2. After reading what authorization you're giving to Hightouch, click **Accept**.
3. Select the **Drive** containg the data you wish to sync from the dropdown.
4. Click **Continue**.

## Test your connection

When setting up Microsoft Excel as a source for the first time, Hightouch checks that you have the correct permissions. Once the test passes, click **Continue** to finish setup.

## Create models

Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up [models](https://docs.hightouch.com/getting-started/concepts.md#models) to define which data you want to pull from Microsoft Excel.

### Model setup

1. In Hightouch, go to the [**Models** overview page](https://app.hightouch.com/models?from=docs).
2. Click **Add model.**
3. Select the Microsoft Excel source you previously created.
4. Select the **Workbook** which has the data you want to sync.
5. Next, select a **Sheet** to read from. Hightouch treats each sheet as a separate table. If you want to sync data from multiple sheets, you need to set up a separate model for each one.
6. Preview your model's query results.
7. Click **Continue**.
8. Name your model and select its [**primary key**](https://docs.hightouch.com/models/creating-models.md#unique-primary-key-requirement). Hightouch uses the primary key to determine which rows have been added, changed, or removed since the last sync.

## Tips and troubleshooting

If you run into an issue this page doesn't cover, [contact support](#pylon-chat).

### Need admin approval

If you see a **Need admin approval** page appear when [accessing Microsoft's OAuth login flow](#connect-to-microsoft-onedrive), your Azure Active Directory user account might not have the necessary permissions to connect applications to your organization.

![Microsoft's "Need admin approval" screen](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/workspace-management/permissions/microsoft-need-admin-approval.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=c9cf06dcd44f67bebf71c67bb2339af2)

Ask one of your Azure organization's admins to edit your user account permissions.

You can read more about [Azure user permissions](https://learn.microsoft.com/en-us/azure/active-directory/develop/active-directory-how-applications-are-added#who-has-permission-to-add-applications-to-my-azure-ad-instance) and [configuring user settings](https://learn.microsoft.com/en-us/azure/active-directory/manage-apps/configure-user-consent?pivots=portal#configure-user-consent-settings) in Azure's documentation.

### Files not appearing in model dropdown

Only `.xlsx` files are [supported](#microsoft-excel-formatting-requirements).
Other files won't appear in the dropdown.
[Convert your file type to `.xlsx`](https://answers.microsoft.com/en-us/msoffice/forum/all/converting-xls-to-xlsx/ba8d05f4-d38a-462a-a062-d6083db4b479) to make it available to Hightouch.