> ## 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 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 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 Excel";
export const pageTitle = "Microsoft Excel";
export const advancedurl = "RX";
export const oauthschemes = "AzureAD or OAuth";

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

## Add the Microsoft Excel Connector

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

## Authenticate to Microsoft Excel

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

**URI:** Enter the Uniform Resource Identifier (URI) for your {datasource} resource location.

{siteName} supports the ability to connect to local and cloud-hosted {datasource} files. Select your connection type below to proceed to the relevant section that contains the connection details.

* [**Local**](#local)
* [**Amazon S3**](#amazon-s3)
* [**Azure Blob Storage**](#azure-blob-storage)
* [**Azure Data Lake Storage**](#azure-data-lake-storage)
* [**Azure Files**](#azure-files)
* [**Box**](#box)
* [**Dropbox**](#dropbox)
* [**FTP**](#ftp)
* [**Google Cloud Storage**](#google-cloud-storage)
* [**Google Drive**](#google-drive)
* [**HDFS**](#hadoop-distributed-file-system-hdfs)
* [**HTTP**](#http)
* [**IBM Object Storage Source**](#ibm-object-storage-source)
* [**OneDrive**](#onedrive)
* [**Oracle Cloud Storage**](#oracle-cloud-storage)
* [**SFTP**](#sftp)
* [**SharePoint Online**](#sharepoint-online)

### Local

To connect to {datasource} resources on the local drive, specify the following settings:

* **Connection Type:** Select **Local**.
* **URI:** Enter your local directory path, one file per table (for example, `C:/FolderPath`).

This connection type does not require any authentication settings. [Complete the remaining steps for establishing your connection](#complete-your-connection).

### Amazon S3

To connect to {datasource} resources on Amazon S3, use the [Amazon S3](./amazon-s3-source) connector instead.

### Azure Blob Storage

To connect to {datasource} resources on Azure Blob Storage, specify the following settings:

* **Connection Type:** Select **Azure Blob Storage**.
* **URI:** Enter the name of your container and blob in the **URI** text box (for example, `azureblob://MyContainer/MyBlob`).
* **Azure Storage Account:** Enter the name of your Azure storage account.

See [Connecting to Azure Blob Storage](./storage-source-connection-types/azure-blob-storage-connection-type) for details about choosing your authentication scheme.

### Azure Data Lake Storage

To connect to {datasource} resources on Azure Data Lake Storage, use the [Azure Data Lake Storage](./azure-data-lake-storage-source) connector instead.

### Azure Files

To connect to {datasource} resources on Azure File Storage, specify these properties:

* **Connection Type:** Select **Azure Files**.
* **URI:** Enter the name of your Azure file share and the name of the resource (for example, `azurefile://FileShare/RemotePath`).
* **Azure Storage Account:** Enter the name of your Azure storage account.

See [Connecting to Azure Files](./storage-source-connection-types/azure-files-connection-type) for details about choosing your authentication scheme.

### Box

To connect to {datasource} resources on Box, specify these properties:

* **Connection Type:** Select **Box**.
* **URI:** Enter the pathname for the file system and the name of the folder that contains your {datasource} files (for example, `box://Folder1`).
* **Auth Scheme:** Select **OAuth**. {siteName} provides an embedded OAuth application with which to connect. No additional properties are required.

[Complete the remaining steps for establishing your connection](#complete-your-connection).

### Dropbox

To connect to CSV resources on Dropbox, specify these properties:

* **Connection Type:** Select **Dropbox**.
* **URI:** Enter the path to a folder that contains CSV files (for example, `dropbox://Folder1`).
* **Auth Scheme:** Select **OAuth**. {siteName} provides an embedded OAuth application with which to connect. No additional properties are required.

[Complete the remaining steps for establishing your connection](#complete-your-connection).

### FTP

To connect to CSV resources on an FTP server, specify these properties:

* **Connection Type:** Select either **FTP** or **FTPS**.
* **URI:** Enter the address of the server, followed by the path to the folder that you want to use as the root folder, as shown in these examples:
  * **FTP:** `ftp://localhost:990/Folder1/File.xlsx`
  * **FTPS:** `ftps://localhost:990/Folder1`
* **Auth Scheme:** Use the default scheme, **Basic**.
* **User:** Enter the username that you use to authenticate to your FTP or FTPS server.
* **Password:** Enter the password that you use to authenticate to your FTP or FTPS server.

[Complete the remaining steps for establishing your connection](#complete-your-connection).

### Google Cloud Storage

To connect to CSV resources on Google Cloud Storage, specify these properties:

* **Connection Type:** Select **Google Cloud Storage**.
* **URI:** Enter the name of the bucket and folder that contains your CSV files (for example, `gs://Bucket/RemotePath`).
* **Project Id:** Enter the identifier for the project to which you want to connect.

See [Connecting to Google Cloud Storage](./storage-source-connection-types/google-cloud-storage-connection-type) for details about choosing your authentication scheme.

### Google Drive

To connect to CSV resources on Google Drive, specify these properties:

* **Connection Type:** Select **Google Drive**.
* **URI:** Enter the pathname for the file system and the name of the folder that contains your CSV files (for example, `gdrive://Folder1`).

See [Connecting to Google Drive](./storage-source-connection-types/google-drive-connection-type) for details about choosing your authentication scheme.

### Hadoop Distributed File System (HDFS)

To connect to CSV resources on HDFS, specify these properties:

* **Connection Type:** Set this to **HDFS** or **HDFS Secure**.
* **URI:** Enter the path to a folder that contains your CSV files, as shown in these examples:
  * **HDFS:** `webhdfs://Host:Port/RemotePath`
  * **HDFS Secure:** `webhdfss://Host:Port/RemotePath`

See [Connecting to HDFS](./storage-source-connection-types/hdfs-connection-type) for details about choosing your authentication scheme.

### HTTP

To connect to CSV resources on HTTP Streams, specify these properties:

* **Connection Type:** Select either **HTTP** or **HTTPS**.
* **URI:** Enter the path to a folder that contains your CSV files, as shown in these examples:
  * **HTTP:** `http://RemoteStream`
  * **HTTPS:** `https://RemoteStream`

See [Connecting to HTTP or HTTPS](./storage-source-connection-types/http-connection-type) for details about setting your authentication scheme.

### IBM Object Storage Source

To connect to CSV resources on IBM Object Storage, specify these properties:

* **Connection Type:** Select **IBM Object Storage Source**.
* **URI:** Enter the name of your bucket and folder (for example, `ibmobjectstorage://Bucket1/RemotePath`).
* **Region:** Enter the region for your IBM instance (for example, **eu-gb**).
* **Api Key:** Enter the API key for your IBM Object Storage source. To obtain this key:
  1. Log in to your IBM Cloud account.
  2. Navigate to the **Platform API Keys** page.
  3. Click **Create an IBM Cloud API Key** (middle right corner) to create a new API key. This action opens a dialog box.
  4. Specify a name for the API key name. Then, click **Create**.

     <Note>Save the API key somewhere because you cannot access it again from the dashboard.</Note>

See [Connecting to IBM Object Storage](./storage-source-connection-types/ibm-object-storage-connection-type) for details about choosing your authentication scheme.

### OneDrive

To connect to CSV resources on OneDrive, specify these properties:

* **Connection Type:** Select **OneDrive**.
* **URI:** Enter the path to a folder that contains your CSV files (for example, `onedrive://RemotePath`).

See [Connecting to OneDrive](./storage-source-connection-types/onedrive-connection-type) for details about choosing your authentication scheme.

### Oracle Cloud Storage

To connect to CSV resources on Oracle Cloud Storage, specify these properties:

* **Connection Type:** Select **OracleCloudStorage**.
* **URI:** Enter the name of your bucket and your folder (for example, `os://Bucket/RemotePath`).
* **Region:** Enter the hosting region for your S3-like web services.
* **Oracle Namespace:** Enter your Oracle cloud namespace.
* **Auth Scheme:** Use the default scheme, **HMAC**.
* **Access Key:** Enter your Oracle Cloud access key.
* **Secret Key:** Enter your Oracle Cloud secret key.

[Complete the remaining steps for establishing your connection.](#complete-your-connection)

### SFTP

To connect to CSV resources on an SFTP server, specify these properties:

* **Connection Type:** Select **SFTP**.
* **URI:** Enter the address of your server, followed by the path to your root folder (for example, `sftp://Server:Port/RemotePath`).
* **Auth Scheme:** Use the default scheme, **SFTP**.

See [Connecting to SFTP](./storage-source-connection-types/sftp-connection-type) for details about choosing your SSH authentication mode.

### SharePoint Online

To connect to CSV resources on SharePoint Online, specify these properties:

* **Connection Type:** Select either **SharePoint Online REST** or **SharePoint Online SOAP**.
* **URI:** Enter a document library that contains CSV files (for example, `sprest://RemotePath`).
  * **SharePoint Online REST:** `sprest://RemotePath`
  * **SharePoint Online SOAP:** `spr://RemotePath`
* **Storage Base URL:** Enter the base URL for the SharePoint site. The following are examples of valid URLs:

  * [http://server/SharePoint/](http://server/SharePoint/)
  * [http://server/Sites/mysite/](http://server/Sites/mysite/)
  * [http://server:90/](http://server:90/)

  <Note>If the domain for this option ends in -my (for example, [https://bigcorp-my.sharepoint.com](https://bigcorp-my.sharepoint.com)) then you might need to connect through [OneDrive](#onedrive).</Note>

See [Connecting to SharePoint Online](./storage-source-connection-types/sharepoint-online-connection-type) for details about choosing your authentication scheme.

## Complete Your Connection

To complete your connection:

1. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
2. {oauthschemes ? `If you authenticate with ${oauthschemes}, click` : "Click"} **Connect to {datasource}** to connect to your {pageTitle} account.
3. Click **Create & Test** to create your connection.

## More Information

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