# Microsoft SharePoint Excel

<!-- BEGIN GENERATED:intro -->

The Microsoft SharePoint Excel connector is a [Palantir-provided driver](../../data-integration/foundry-provided-drivers/index.md) for Microsoft SharePoint Excel.

To create a new Microsoft SharePoint Excel source, follow the [standard setup flow for Palantir-provided drivers](../../data-integration/foundry-provided-drivers/index.md#setup), then use the sections below for Microsoft SharePoint Excel-specific configuration and networking. For the complete property reference, see the [official Microsoft SharePoint Excel driver documentation ↗](https://cdn.cdata.com/help/DTK/jdbc/pg_connectionj.htm).

<!-- END GENERATED:intro -->

<!-- BEGIN GENERATED:capabilities -->

:::callout{theme="neutral" title="Beta"}
The Microsoft SharePoint Excel connector is in the [beta](../../platform-overview/development-life-cycle/index.md) phase of development and may not be available on your enrollment. Functionality may change during active development.
:::

## Supported capabilities

| Capability | Status |
|---|---|
| Exploration | 🟡 Beta |
| Batch syncs | 🟡 Beta |
| Incremental | 🟡 Beta |

<!-- END GENERATED:capabilities -->

<!-- BEGIN GENERATED:configuration -->

## Configuration

The properties below are mandatory or recommended.

| Property | Required? | Description | Default |
|---|---|---|---|
| [`AuthScheme` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_AuthScheme.htm) | Mandatory | The scheme used for authentication. Accepted entries are NTLM,Basic,Digest,Forms,None,Negotiate,ADFS. | `NTLM` |
| [`File` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_File.htm) | Mandatory | The name of the Excel file to which to connect. | `Book1.xlsx` |
| [`SharePointVersion` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_SharePointVersion.htm) | Mandatory | The version of the SharePoint server to which you are connecting. | `SharePoint 2013` |
| [`URL` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_URL.htm) | Mandatory | The base URL for a site or site collection. | `https://myorg.sharepoint.com` |
| [`Folder` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_Folder.htm) | Recommended | The folder containing the workbook specified by the File property. | — |
| [`Library` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_Library.htm) | Recommended | The Document Library to which to connect. | — |
| [`Password` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_Password.htm) | Recommended | The password of the account used to authenticate to the server. | — |
| [`User` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_User.htm) | Recommended | The username of the account used to authenticate to the server. | — |
| [`UseRESTAPI` ↗](https://cdn.cdata.com/help/DTK/jdbc/RSBExcelServices_p_UseRESTAPI.htm) | Recommended | Whether or not the REST API is used for retrieving data. | `TRUE` |

<!-- END GENERATED:configuration -->

<!-- BEGIN GENERATED:networking -->

## Networking

The table below lists the domains that the source must be able to access to run.

For each domain, add a corresponding [egress policy](../../administration/configure-egress/index.md). If the source is hosted on-premises and not directly reachable from Foundry, use an [agent proxy egress policy](../../administration/configure-egress/index.md#agent-proxy-egress-policies) instead. The agent host itself must also be able to reach the listed domains. See [using an agent as a proxy](../../data-connection/agent-proxy/index.md) for details.

| Domain  | Required |
|--- |--- |
| \<URL> | Always. URL connection property |
| \<KerberosKDC>:88 | If `SharePointEdition='SharePoint OnPremise'` (default) AND `AuthScheme=Negotiate` |
| \<KerberosServiceKDC>:88 | If `SharePointEdition='SharePoint OnPremise'` (default) AND `AuthScheme=Negotiate` AND Kerberos topology uses multiple realms |
| \<SSOLoginURL> | If `SharePointEdition='SharePoint OnPremise'` (default) AND `AuthScheme=ADFS` |
| login.microsoftonline.com | If `SharePointEdition='SharePoint Online'` AND `AuthScheme=AzureAD,` AzurePassword, SharePointOAuth, OAuthJWT  AND `AzureEnvironment=GLOBAL` (default) |
| login.chinacloudapi.cn | If `SharePointEdition='SharePoint Online'` AND `AuthScheme=AzureAD,` AzurePassword, SharePointOAuth, OAuthJWT AND `AzureEnvironment=CHINA` |
| login.microsoftonline.us | If `SharePointEdition='SharePoint Online'` AND `AuthScheme=AzureAD,` AzurePassword, SharePointOAuth, OAuthJWT AND `AzureEnvironment=USGOVT` or USGOVTDOD |

<!-- END GENERATED:networking -->