---
title: Excel (Gen1.3)
slug: litmusedge/quickstart-guide/industrial-systems-connection-guide/excel/excel-gen1
description: You can set up the Excel driver to read values in an Excel file.
docTags: 
createdAt: 2022-05-26T20:56:06.000Z
---

You can set up the Excel driver to read values in an Excel file.

# Before You Begin

Make sure you do the following:

- Have an Excel file located on your hard drive.
- Ensure the FTP service is running. See [Manage FTP and System Services](docId:8WXaruBsl0wubj_tsL3ha) for more information.
- Install the [WinSCP FTP client ](https://winscp.net/eng/index.php)on your computer.
- Add an FTP user. See [Add an FTP User](docId\:mCl0LRotQ1vOOa5E2crmi) for more information.

# Set Up Excel Driver

Setting up the Excel driver includes the following tasks:

- Step 1: Set Up FTP Client
- Step 2: Add Excel Driver
- Step 3: Add a Tag For a Single Cell in Excel
- Step 4: Add a Tag for Range of Cells in Excel
- Step 5: Create Flow for Single Cell in Excel
- Step 6: Create Flow for Range of Cells in Excel

## Step 1: Set Up FTP Client

**To set up the FTP client:**

1. Open the WinSCP FTP client. 
   The *FTP Login* dialog box appears.

::Image[]{src="https://app.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/kHFvF63MmsPXpbz2ST2Eg_ftp-client-window.png" size="80" width="827" height="538" position="flex-start" caption="FTP Login dialog box" showCaption="true" indent="2"}

2. For **File Protocol**, select **FTP**. 
3. Configure the following parameters. 
   - **Host name**: Enter the Litmus Edge URL. 
   - **User name**: Enter the FTP username you created when you [Added an FTP User](docId\:mCl0LRotQ1vOOa5E2crmi).
   - **Password**: Paste the password you copied when you [Added an FTP User](docId\:mCl0LRotQ1vOOa5E2crmi).
4. Click **Login**. 
   The WinSCP window appears.

5. Open the DeviceHub folder in the right pane.
6. From the left pane, drag the Excel file to the open DeviceHub folder.
   The Excel file uploads to the folder.

## Step 2: Add Excel Driver

**To add the Excel driver: **

1. In Litmus Edge, navigate to **DeviceHub **> **Devices**. 
2. Click the **Connect a Device** box. 
   The *Connect Device *dialog box appears.

::Image[]{src="https://app.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/atJL37pPuLGI2bM_w2ibz_adddevice.png" size="80" width="1046" height="528" position="flex-start" caption="Connect a Device box" showCaption="true" indent="2"}

3. In the **Device Type** drop-down list, select **Excel**. 
4. In the **Driver Name** drop-down list, select **Excel (Gen1.3)**. 
5. In the **Name **field, enter a name for the device. 
6. In the **Path **field, enter the path for the Excel file that you just previously uploaded. 
7. Click **Add Device**. 
   The Excel device appears in the *Devices *pane. 

## Step 3: Add a Tag For a Single Cell in Excel

The Excel device is disconnected until you add a tag.

**To add a tag for single cell:**

1. In Litmus Edge, navigate to **DeviceHub **> **Tags**.
2. Click the Excel device. 
3. Click the **Add **icon and select **Add a Tag**. 

::Image[]{src="https://app.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/4nexvxRZvUEqBp9uGaXNl_addexceltag.png" size="80" width="1186" height="337" position="flex-start" caption="Add a Tag option" showCaption="true" indent="2"}

4. Configure the following parameters. 
   - **Name**: Select **R**. 
   - **Value Type**: Select **single**.
   - **Polling Interval**: Enter a value. 
   - **Tag Name**: Enter a tag name.
   - **Start Cell**: Enter a value. For example, **A1**. 
   - **End Cell**: To configure the tag for only one cell, enter the same value as the Start Cell.  
   - **Sheet**: Enter the Excel file sheet name from which the cell data is used. The sheet name must be exactly the same as the sheet name in the Excel file.
5. Click **Add Tag**. 
   The tag is added to the tags pane.
6. Click the **Copy **icon for the tag in the *RAW Topic* column. 

## Step 4: Add a Tag for Range of Cells in Excel

**To add a tag for a range of cells:**

1. In Litmus Edge, navigate to **DeviceHub **> **Tags**.
2. Select the Excel device. 
3. Click the **Add **icon and select **Add a Tag**. 

::Image[]{src="https://app.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/4nexvxRZvUEqBp9uGaXNl_addexceltag.png" size="80" width="1186" height="337" position="flex-start" caption="Add a Tag option" showCaption="true" indent="2"}

4. Configure the following parameters. 
   - **Name**: Select **R**. 
   - **Value Type**: Select **range**.
   - **Polling Interval**: Enter a value. 
   - **Tag Name**: Enter a tag name.
   - **Start Cell**: Enter the starting cell to read data. 
   - **End Cell**: Enter the ending cell to read data. 
   - **Sheet**: Enter the Excel file sheet name from which the cell data is used. The sheet name must be exactly the same as the sheet name in the Excel file.
5. Click **Add Tag**. 
   The tag is added to the tags pane.
6. Click the **Copy **icon for the tag in the *RAW Topic* column. 

## Step 5: Create Flow

**To create a flow:**

1. In Litmus Edge, navigate to the **Flows Manager **and create a new flow. See [Create a Flow](docId\:wh4ZihWF0PwMRYRbAZbco) to learn more. 
2. Drag the **DataHub Subscribe **and **Debug **nodes to the canvas and wire them together.
3. Double-click the **DataHub Subscribe **node.
4. In the Topic field, paste the RAW Topic value from either "Step 3: Add a Tag For a Single Cell in Excel" or "Step 4: Add a Tag for Range of Cells in Excel". 
5. If needed, configure the *Datahub Subscribe* connection. See the "Step 3: Configure Connector Nodes" section in [Create a Flow](docId\:wh4ZihWF0PwMRYRbAZbco) to learn more. 
6. Click **Deploy**.
7. Click the **Debug **icon. See the "Additional Options" section in [Manage the Flow Canvas](docId\:Fd9Bu5dD1Nbv3Xvy-0xxn) to learn more. 
8. Review the debug messages and confirm they correspond to the values in the Excel file.