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

# Microsoft SharePoint Excel

export const CommonDatasourceMoreInformation = ({datasource = "the data source", advancedurl = "", siteName = "CData Sync", driverVersion = ""}) => {
  return <>
      <p>
        For more information about interactions between {siteName} and {datasource}, see{' '}
        <a href={`https://cdn.cdata.com/help/${advancedurl}${driverVersion}/synch/default.htm`}>
          {datasource} Connector for {siteName}
        </a>.
      </p>
    </>;
};

export const CommonAuthSchemeNone = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>To connect without authentication, select <strong>None</strong> for <strong>Auth Scheme</strong>. No additional properties are required.</p>
    </>;
};

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        To enable {siteNameShort} to use data from {datasource}, you first must add the
        connector, as follows:
      </p>
      <ol>
        <li>Open the <strong>Connections</strong> page of the {siteNameShort} dashboard.</li>
        <li>Click <strong>Add Connection</strong> to open the <strong>Select Connectors</strong> page.</li>
        <li>
          Click the <strong>{destination ? "Destinations" : "Sources"}</strong> tab and locate
          the <strong>{title}</strong> row.
        </li>
        <li>
          Click the <strong>Configure Connection</strong> icon at the end of that row to open
          the <strong>New Connection</strong> page. This action opens the{' '}
          <strong>Add Connection</strong> dialog box.
          <br />
          <strong>Note:</strong> If the <strong>Configure Connection</strong> icon is not
          available, click the <strong>Download Connector</strong> icon to install
          the {title} connector.
        </li>
        <li>Enter a name for your connection in the <strong>Add Connection</strong> dialog box.</li>
        <li>Click <strong>Add</strong> to open the <strong>Settings</strong> tab for your connector.</li>
      </ol>
      <p>
        For more information about installing new connectors, see{' '}
        <a href="../connections">Connections</a>.
      </p>
    </>;
};

export const CommonDatasourceIntroSource = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      You can use the {datasource} connector from the {siteName} application to capture data
      from {datasource} and move it to any supported destination. To do so, you need to add
      the connector, authenticate to the connector, and complete your connection.
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Microsoft SharePoint Excel";
export const pageTitle = "Microsoft SharePoint Excel";
export const advancedurl = "DT";

<CommonDatasourceIntroSource datasource={datasource} siteName={siteName} />

## Add the Microsoft SharePoint Excel Connector

<CommonDatasourceAddConnector datasource={datasource} title={pageTitle} destination={false} siteNameShort={siteNameShort} />

## Authenticate to Microsoft SharePoint Excel

After you add the connector, you need to set the required properties.

* **URL:** Enter the base URL for a site or site collection.
* **File:** Enter the name of the Microsoft Excel workbook to which you want to connect.

{siteName} supports authenticating to {datasource} in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**NTLM**](#ntlm) (default)
* [**Basic**](#basic)
* [**Digest**](#digest)
* [**Forms**](#forms)
* [**None**](#none)
* [**Negotiate**](#negotiate)
* [**Active Directory Federation Services**](#active-directory-federation-services-adfs)

### NTLM

To connect with NTLM user credentials, specify the following properties:

* **Auth Scheme:** Select **NTLM**.
* **User:** Enter the username that you use to authenticate to the Microsoft server.
* **Password:** Enter the password that you use to authenticate to the Microsoft server.

### Basic

To connect with your user credentials, specify the following properties:

* **Auth Scheme:** Select **Basic**.
* **User:** Enter the username that you use to authenticate to the Microsoft server.
* **Password:** Enter the password that you use to authenticate to the Microsoft server.

### Digest

To connect with digest-authentication credentials, specify the following properties:

* **Auth Scheme:** Select **Digest**.
* **User:** Enter the username that you use to authenticate to your Microsoft account.
* **Password:** Enter the password that you use to authenticate to your Microsoft account.

### Forms

To connect with a custom authentication method, specify the following properties:

* **Auth Scheme:** Select **Forms**.
* **User:** Enter the username that you use to authenticate to your Microsoft account.
* **Password:** Enter the password that you use to authenticate to your Microsoft account.

### None

<CommonAuthSchemeNone siteName={siteName} siteNameShort={siteNameShort} datasource={datasource} />

### Negotiate

To connect with Kerberos credentials, specify the following properties:

* **Auth Scheme:** Select **Negotiate**.
* **User:** Enter the username that you use to authenticate to your Microsoft account.
* **Password:** Enter the password that you use to authenticate to your Microsoft account.

### Active Directory Federation Services (ADFS)

To connect with single sign-on (SSO) via ADFS, specify the following properties:

* **Auth Scheme:** Select **ADFS**.
* **User:** Enter the username that you use to authenticate to your ADFS account.
* **Password:** Enter the password that you use to authenticate to your ADFS account.
* **STSURL:** The URL of the security token service (STS).
* **SSO Login URL:** Enter the login URL that is used by your SSO provider.
* **SSO Domain:** Enter the domain of the user.
* **SSO Properties:** Enter additional properties that are required to connect to your identity provider. You must use a semicolon-separated list of properties (for example, *SSOProperty1*=*Value1*;*SSOProperty2*=*Value2*;...).

## Complete Your Connection

To complete your connection:

1. Specify the following properties:
   * **SharePoint Version:** Select your version of Microsoft SharePoint from the list. The default version is **SharePoint 2013**.
   * **Folder:** Enter the path to the folder that contains the workbook that you specified earlier for **File**.
   * **Library:** Specify the document library to which you want to connect.
   * **Use RESTAPI:** Select whether you want to use the REST API (instead of the OData API) to retrieve data. By default, the **Enable** checkbox is already selected.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. Click **Create & Test** to create your connection.

## More Information

<CommonDatasourceMoreInformation datasource={datasource} advancedurl={advancedurl} siteName={siteName} driverVersion={driverVersion} />