# Excel

This guide will teach you how to import a dataset into Excel using the Foundry ODBC driver.

## Configure a Foundry Connection

1. Open the Windows ODBC Administrator App (search for "odbc" in the Windows search bar and open the 32 or 64 bit version matching your Excel version).
2. Create a new User DSN, choosing the FoundrySqlDriver driver. Give it a meaningful name, such as `Foundry Excel`.
3. For the **Server**, enter your Foundry URL (example: `myorganization.palantirfoundry.com`).
4. Optional: If you are using OAuth to authenticate, set the [OAuth properties](../odbc-jdbc-drivers/index.md#use-oauth-to-authenticate).
5. Optional: You can save an authentication token here, but we recommend entering it later in Excel where you will be prompted when importing data.
6. Click **OK** to save the DSN.

![excel-odbc-app](../../../assets/31f5c158e13828b52a3bf3c16cb53cd1875ef367f6f78f768ff592118e9408b7.webp)

## Import data via SQL

1. From Excel, open the **Data** tab and click on **Get data** in the ribbon. Select **From Other Sources -> From ODBC**.
2. Choose the DSN you configured in the previous step.
3. Under "Advanced Options", enter a SQL query to import data.
   * If you want to import the dataset `/YourProject/yourdataset`, you would enter `SELECT * FROM "/YourProject/yourdataset"`.
   * If you are familiar with SQL, you can enter more advanced queries such as filters and aggregates here.
4. Click **OK**.
5. If this is your first time importing data, you will be prompted for credentials.
   * If using OAuth, select the "Default or Custom" credential type, leave the field blank and click "Connect"
   * Otherwise, you will need an authentication token. Choose "Database", and enter your username. In the "password" field, enter your token, *not* your Foundry password.
6. Click **Connect**.

![excel-data-import](../../../assets/693d9a09a6c6e0293c3cac7ed88c3de0058fe7eb1fc7f6b232eebc73871c7124.webp)

## Import data via the table browser

By default, if you follow the steps above but do not enter a SQL query, the table browser will display an empty state. This can be resolved by restricting the connection to a single project by adding the `catalog` property in your DSN and setting it to a full project path, such as `MyOrg/MyProject`. You can do this by clicking on **Additional Properties** on the Driver DSN Setup window, and then clicking on **Add**. The table browser should then display correctly, although you will be limited to browsing a single project per DSN.

## Import data into Microsoft Access

The same Foundry Connector for Excel can also be used to import data into Access databases.

1. From Access, open the **External Data** tab and click on **New Data Source** in the ribbon. Select **From Other Sources -> ODBC Database**.
2. Choose whether you want to **Import the source data** or **Link to the source data**.
3. Under the **Machine Data Source** tab, select the DSN you configured in the first step of this guide.
   * You will need to have saved your authentication token in the Driver DSN Setup window.
   * You will need to have set the `catalog` property as described in the previous step.
   * Your project path must conform to [Access table name restrictions ↗](https://support.microsoft.com/en-us/office/guidelines-for-naming-fields-controls-and-objects-120c27fa-7ae1-4182-9baa-dbd183179cc3).
4. Select your table(s) from the table browser and click **OK**.