> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Excel SFTP Connector

## Intro

The Domo Excel SFTP connector allows you to access Excel files that you have uploaded to a server using SFTP (Secure File Transfer Protocol).

You connect to Excel files in the Data Center. This topic discusses the fields and menus that are specific to the Excel SFTP connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## Prerequisites

You must have an SFTP host name, username, password, and port number to authenticate to the SFTP server. You must also whitelist the following IP addresses:

```
54.208.95.237
54.208.87.122
54.208.95.167
54.208.94.194
50.207.240.162
50.207.241.62
52.18.90.222
52.62.103.83
34.198.214.100
```

## Connecting to Your Excel File

This section enumerates the options in the **Credentials** and **Details** panes in the Excel SFTP Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](/s/article/360042926274 "Adding a DataSet Using a Data Connector").

### Credentials Pane

This pane contains fields for entering credentials to connect to the Excel file on an SFTP server you want to pull into Domo. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Username </p></td><td colspan="1" rowspan="1"><p> Enter the username you use to authenticate to the SFTP server. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Password </p></td><td colspan="1" rowspan="1"><p> Enter the password you use to authenticate to the SFTP server. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Host Name </p></td><td colspan="1" rowspan="1"><p><span class="s1"> Enter the name or IP address of the SFTP host you want to connect to. </span></p></td></tr><tr><td colspan="1" rowspan="1"><p> Port Number </p></td><td colspan="1" rowspan="1"><p> Enter the port number of the SFTP server. </p></td></tr></tbody></table>

Once you have entered valid Excel credentials, you can use the same account any time you go to create a new Excel SFTP DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](/s/article/360042926054 "Managing User Accounts for Connectors").

### Details Pane

In this pane you choose and configure options for the Excel file you want to pull into Domo.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> File Name or Portion of File Name to Search For </p></td><td colspan="1" rowspan="1"><p> Enter the file name or a portion of the file name of the Excel file you want to pull into Domo. Both <span class="mt-font-courier-new">.xls </span> and <span class="mt-font-courier-new">.xlsx </span> files are supported. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Type of Match to Perform </p></td><td colspan="1" rowspan="1"><p> Select whether the filename starts with or contains the string you entered in the <b> File Name or Portion of File Name to Search For </b> field. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Is Password Protected? </p></td><td colspan="1" rowspan="1"><p> Select whether the Excel file you are pulling into Domo is password protected. </p></td></tr><tr><td colspan="1" rowspan="1"><p> File Password </p></td><td colspan="1" rowspan="1"><p> Enter the password for the Excel file you want to pull into Domo. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Sheet Name (Optional) </p></td><td colspan="1" rowspan="1"><p> Enter the name of the Excel sheet you want to pull into Domo. If you leave this blank, Domo pulls the first sheet of the file. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Layout </p></td><td colspan="1" rowspan="1"><p> Select the layout of the Excel file you are pulling into Domo. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Mode </p></td><td colspan="1" rowspan="1"><p> Select the desired parsing mode. If you select <b> Manual </b>, you are asked to enter a column header range and date range; if you select <b> Automatic </b>, these ranges are determined automatically. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Column Header Range </p></td><td colspan="1" rowspan="1"><p> Enter the range of header cells in the Excel file, e.g. <span class="mt-font-courier-new"> A2:F8 </span>. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Data Range </p></td><td colspan="1" rowspan="1"><p> Enter the range of data cells in the Excel file, e.g. <span class="mt-font-courier-new"> A3:F20 </span>. </p></td></tr></tbody></table>