---
title: "Excel Upload"
slug: "excel-upload"
updated: 2026-02-17T16:36:32Z
published: 2026-02-17T17:28:33Z
canonical: "docs.unqork.io/excel-upload"
---

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

# Excel Upload

Sometimes, your end-user might have to save multiple submissions on your form simultaneously. For usability, you do not want them to have to log in and out of the application over and over, creating submissions individually. Instead, it’s easier to collect large amounts of data in an Excel sheet. Then upload that sheet, populating your application automatically. The **Excel Upload** feature makes that possible.

> [!NOTE]
> There is a known issue with Chrome and Chromium-based browsers where uploading XLSX and XLS files from non-US locales might incorrectly parse the timestamp value. For example, the timestamp might be off by one-tenth. To avoid this issue, use a different browser (like Firefox or Safari), change your browser's locale, or manually adjust incoming date values to `YYYY-MM-DD-T12:mm:ss.sssZ` as a workaround.

## What Is an Excel Upload?

An Excel upload feature lets your end-user upload an Excel sheet to your application. Your application stores the Excel sheet, where you can parse the data into your application's fields.

Let’s say a broker has a client applying for insurance on multiple golf courses. There are several questions the client must answer about each golf course. It would be time-consuming for the client to answer the same questions for each golf course. Instead, you provide them with an Excel template. The client can complete the template and upload it to your Unqork application. Doing so simplifies the process and saves time.

**UDesigner**

## Preconfiguration

> [!NOTE]
> These instructions assume you have a new Front-End module open, saved, and with a title.

### Configure the Advanced Datagrid Component

The [Advanced Datagrid](/v1/docs/advanced-datagrid-component) component will display the golf course data, including the name of the golf course, the number of annual visitors, the number of holes on the course, and the course's acreage.

1. In the Module Builder, drag and drop an **Advanced Datagrid** component onto your canvas.
2. In the **Property ID** field, enter `Golf Course Information`.
3. In the **Label Text** field, enter `adgGolfCourses`.
4. In the **Display** table, enter the following:

| # | ID | Formula | Heading |
| --- | --- | --- | --- |
| 1 | golfName |  | Course Name |
| 2 | golfVisitors |  | Number of Annual Visitors |
| 3 | golfHoles |  | Number of Holes |
| 4 | golfAcreage |  | Property Acreage |

> [!NOTE]
> The entries in the Display table are for the components you’ll add in the next steps.

![Advanced Datagrid component settings with the Display table highlighted.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/ExcelUpload_adgGolfCourses.png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
5. Click **Save Component**.

### Configure the Text Field Component

Next, you’ll use a [Text Field](/v1/docs/text-field-component) component to store the name of the golf course. You’ll place this component inside your Advanced Datagrid component.

1. Drag and drop a **Text Field** component inside your Advanced Datagrid component.
2. In the **Property ID** field, enter `golfName`.
3. In the **Label Text** field, enter `Golf Course Name`.
4. Click **Save Component**.

### Configure the Number Components

Next, you’ll use three [Number](/v1/docs/number-component) components to store data about the golf course, placing them inside your Advanced Datagrid component.

1. Drag and drop three **Number** components inside your Advanced Datagrid component.
2. In the **Property ID** and **Label Text** fields, enter the following for each component:

| # | Property ID | Label Text |
| --- | --- | --- |
| 1 | golfVisitors | Number of Annual Visitors |
| 2 | golfHoles | Number of Holes |
| 3 | golfAcreage | Property Acreage |
3. Click **Save Component** for each component as you add it.

### Configure the File Component

Your [File](/v1/docs/file-component) component is how your end-user uploads their Excel sheet. On its own, the component doesn't interpret any data. Later, you'll add a Data Workflow to retrieve the uploaded files and interpret them.

1. Drag and drop a **File** component onto your canvas, placing it above your Advanced Datagrid component.
2. In the **Property ID** field, enter `fileGolfCourses`.
3. In the **Label Text** field, enter `Please Upload Your File`.
4. Click **Save Component**.

## Configuration

### Configure the Data Table Component

Next, let’s add a [Data Table](/v1/docs/data-table-component) component to determine which columns of the Excel sheet belong in which fields of your application.

> [!NOTE]
> We'll create an Excel template as the last step in this configuration. But keep in mind that your **Source** column must match the label headings you use in your Excel sheet.

1. Drag and drop a **Data Table** component onto your canvas, placing it above your File component.
2. In the **Property ID** and **Label Text** fields, enter `golfCourseMapping`.
3. Configure the data table as follows:

| Source | Target |
| --- | --- |
| Golf Course Name | golfName |
| Number of Annual Visitors | golfVisitors |
| Property Acreage | golfAcreage |
| Number of Holes | golfHoles |

![Data table component settings with the Data Table highlighted.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/ExcelUpload_golfCourseMapping(1).png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
4. Click **Save Component**.

### Configure the Calculator Component

A Data Workflow can’t process an Excel sheet on its own. First, you must retrieve the Excel data and add it to a JSON file using a [Calculator](/v1/docs/calculator-component) component.

1. Drag and drop a **Calculator** component onto your canvas, placing it below your Data Table component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `calcGolfCourseUpload`.
3. Set the **Trigger Type** as **Watch**.
4. In the **Inputs** table, enter the following:

| Source | Alias | Required |
| --- | --- | --- |
| fileGolfCourses[0].json | A | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/icon_unchecked(1).png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D) (unchecked) |
5. In the **Outputs** table, enter the following:

| Source | Formula |
| --- | --- |
| golfCourseUpload | =A |

> [!NOTE]
> This configuration outputs the data to the `golfCourseUpload` **Hidden** component you’ll add next.

![Calculator component settings with the Inputs and Outputs table highlighted.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/ExcelUpload_calcGolfCourseUpload(1).png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
6. Click **Save Component**.

### Configure the Hidden Component

Next, let’s add a [Hidden](/v1/docs/hidden-component) component to act as a storage container for your converted Excel sheet. You’ll later reference this component and its data in your Data Workflow.

1. Drag and drop a **Hidden** component onto your canvas, placing it below your Calculator component.
2. in the **Property ID** and **Label Text** fields, enter `golfCourseUpload`.
3. Click **Save Component**.

### Configure the Data Workflow Component

The JSON object stored by your Hidden component contains all data from the Excel sheet. Let's add a [Data Workflow](/v1/docs/data-workflow-component) component to retrieve that data and separate it by golf course and field.

1. Drag and drop a **Data Workflow** component onto your canvas, placing it below your `golfCourseUpload` **Hidden** component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `dwfGolfCourseUpload`.

#### Configure the First Input Operator

1. Drag and drop an **Input** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Input |
| Component | golfCourseUpload |
| Required | Yes |
| Source | Default |

#### Configure the Second Input Operator

1. Drag and drop a second **Input** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Input |
| Component | golfCourseMapping |
| Required | Yes |
| Source | Default |

#### Configure the Map Keys Operator

1. Drag and drop a **Map Keys** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Map Keys |
| Label |  |
| Source Column | Source |
| Target Column | Target |
3. Connect the output port (right) of the `golfCourseUpload` **Input** operator to the upper input port (left) of the **Map Keys** operator.
4. Connect the output port (right) of the `golfCourseMapping` **Input** operator to the lower input port (left) of the **Map Keys** operator.

#### Configure the Output Operator

1. Drag and drop an **Output** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Output |
| Component | adgGolfCourses |
| Action | Value |

#### Configure the First Console Operator

These [Console](/v1/docs/console-operator) operators let you troubleshoot if any issues arise.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label |  |
3. Connect the output port (right) of the `golfCourseUpload` **Input** operator to the input port (left) of the **Console** operator.

#### Configure the Second Console Operator

1. Drag and drop a second **Console** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label |  |
3. Connect the output port (right) of the **Map Keys** operator to the input port (left) of the **Console** operator.
4. Click **Save Component**.
5. Save your module.

Here's how your completed module looks in the Module Builder:

![Completed module builder.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UploadExcel_ModuleBuilder.png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)

## Configure the Excel Sheet

Your final step happens outside of Unqork. A best practice for Excel uploads is to provide your end-user with an Excel template. Remember that the column labels must match what's used in your Data Table component. You can also set up fields with validation criteria in the Excel template. Keep in mind that data mapping is case sensitive, so you must set those restrictions in your template as well. In our example, we’ll set our Number of Annual Visitors, Property Acreage, and Number of Holes columns to accept numeric values greater than 0.

1. In Excel, open a **blank workbook**.
2. In the first row, enter the following **headers**:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_Headers.jpg?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
  1. Golf Course Name
  2. Number of Annual Visitors
  3. Property Acreage
  4. Number of Holes
3. Highlight columns **B**, **C**, and **D**.
4. Click the **Data** tab and select **Data Validation**.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_Validation.jpg?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
5. From the **Allow** drop-down, select **Whole Number**.
6. From the **Data** drop-down, select **Greater Than**.
7. Set the **Minimum** as `0`.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_Criteria.jpg?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
8. Click **OK**.
9. **Save** your Workbook.

With the above steps completed, you can test your configuration. In your Excel template, input some sample data. Then, preview your Unqork module in Express View and upload the Excel sheet.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_GIF.gif?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)

**Classic Designer**

## Preconfiguration

> [!NOTE]
> These instructions assume you have a new Front-End module open, saved, and with a title.

### Configure the Advanced Datagrid Component

The [Advanced Datagrid](/v1/docs/advanced-datagrid-component) component will display the golf course data, including the name of the golf course, the number of annual visitors, the number of holes on the course, and the course's acreage.

1. In the Module Builder, drag and drop an **Advanced Datagrid** component onto your canvas.
2. In the **Label** field, enter `Golf Course Information`.
3. In the **Property Name** field, enter `adgGolfCourses`.
4. In the **Display** table, enter the following:

| ID | Formula | Heading |
| --- | --- | --- |
| golfName |  | Course Name |
| golfVisitors |  | Number of Annual Visitors |
| golfHoles |  | Number of Holes |
| golfAcreage |  | Property Acreage |

> [!NOTE]
> The entries in the Display table are the components you’ll add in the next steps.

![Advanced datagrid component settings with the Display table highlighted.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/ExcelUpload_adgGolfCoursesClassic.png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
5. Click **Save**.

### Configure the Text Field Component

Next, you’ll use a [Text Field](/v1/docs/text-field-component) component to store the name of the golf course. You’ll place this component inside your Advanced Datagrid component.

1. Drag and drop a **Text Field** component inside your Advanced Datagrid component.
2. In the **Property ID** field, enter `golfName`.
3. In the **Label Text** field, enter `Golf Course Name`.
4. Click **Save & Close**.

### Configure the Number Components

Next, you’ll use three [Number](/v1/docs/number-component) components to store data about the golf course, placing them inside your Advanced Datagrid component.

1. Drag and drop three **Number** components inside your Advanced Datagrid component.
2. In the **Property ID** and **Label Text** fields, enter the following for each component:

| # | Property ID | Label Text |
| --- | --- | --- |
| 1 | golfVisitors | Number of Annual Visitors |
| 2 | golfHoles | Number of Holes |
| 3 | golfAcreage | Property Acreage |
3. **Save & Close** each component as you add it.

### Configure the File Component

Your [File](/v1/docs/file-component) component is how your end-user uploads their Excel sheet. On its own, the component doesn't interpret any data. Later, you'll add a Data Workflow to retrieve the uploaded files and interpret them.

1. Drag and drop a **File** component onto your canvas, placing it above your Advanced Datagrid component.
2. In the **Property ID** field, enter `fileGolfCourses`.
3. In the **Label Text** field, enter `Please Upload Your File`.
4. Click **Save & Close**.

## Configuration

### Configure the Data Table Component

Next, let’s add a [Data Table](/v1/docs/data-table-component) component to determine which columns of the Excel sheet belong in which fields of your application.

> [!NOTE]
> We'll create an Excel template as the last step in this configuration. But keep in mind that your **Source** column must match the label headings you use in your Excel sheet.

1. Drag and drop a **Data Table** component onto your canvas, placing it above your File component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `golfCourseMapping`.
3. Configure the data table as follows:

| Source | Target |
| --- | --- |
| Golf Course Name | golfName |
| Number of Annual Visitors | golfVisitors |
| Property Acreage | golfAcreage |
| Number of Holes | golfHoles |

![Data table component with Data Table highlighted.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/ExcelUpload_golfCourseMapping.png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
4. Click **Save & Close**.

### Configure the Calculator Component

A Data Workflow can’t process an Excel sheet on its own. First, you must retrieve the Excel data and add it to a JSON file using a [Calculator](/v1/docs/calculator-component) component.

1. Drag and drop a **Calculator** component onto your canvas, placing it below your Data Table component.
2. In the **Property ID** and **Canvas Label Text** fields, enter `calcGolfCourseUpload`.
3. Set the **Trigger Type** as **Watch**.
4. In the **Inputs** table, enter the following:

| Source | Alias | Required |
| --- | --- | --- |
| fileGolfCourses[0].json | A | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/icon_unchecked(1).png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D) (unchecked) |
5. In the **Outputs** table, enter the following:

| Source | Formula |
| --- | --- |
| golfCourseUpload | =A |

> [!NOTE]
> This configuration outputs the data to the `golfCourseUpload` **Hidden** component you’ll add next.

![Calculator component settings with the Inputs and Outputs tables highlighted.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/ExcelUpload_calcGolfCourseUpload.png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
6. Click **Save & Close**.

### Configure the Hidden Component

Next, let’s add a [Hidden](/v1/docs/hidden-component) component to act as a storage container for your converted Excel sheet. You’ll later reference this component and its data in your Data Workflow.

1. Drag and drop a **Hidden** component onto your canvas, placing it below your Calculator component.
2. in the **Property ID** and **Canvas Label Text** fields, enter `golfCourseUpload`.
3. Click **Save & Close**.

### Configure the Data Workflow Component

The JSON object stored by your Hidden component contains all data from the Excel sheet. Let's add a [Data Workflow](/v1/docs/data-workflow-component) component to retrieve that data and separate it by golf course and field.

1. Drag and drop a **Data Workflow** component onto your canvas, placing it below your Hidden component.
2. In the **Canvas Label Text** and **Property Name** fields, enter `dwfGolfCourseUpload`.

#### Configure the First Input Operator

1. Drag and drop an **Input** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Input |
| Component | golfCourseUpload |
| Required | Yes |
| Source | Default |

#### Configure the Second Input Operator

1. Drag and drop a second **Input** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Input |
| Component | golfCourseMapping |
| Required | Yes |
| Source | Default |

#### Configure the Map Keys Operator

1. Drag and drop a **Map Keys** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Map Keys |
| Label |  |
| Source Column | Source |
| Target Column | Target |
3. Connect the output port (right) of the `golfCourseUpload` **Input** operator to the upper input port (left) of the **Map Keys** operator.
4. Connect the output port (right) of the `golfCourseMapping` **Input** operator to the lower input port (left) of the **Map Keys** operator.

#### Configure the Output Operator

1. Drag and drop an **Output** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Output |
| Component | adgGolfCourses |
| Action | Value |

#### Configure the First Console Operator

These [Console](/v1/docs/console-operator) operators let you troubleshoot if any issues arise.

1. Drag and drop a **Console** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label |  |
3. Connect the output port (right) of the `golfCourseUpload` **Input** operator to the input port (left) of the **Console** operator.

#### Configure the Second Console Operator

1. Drag and drop a second **Console** operator onto your Data Workflow canvas.
2. Configure the operator’s **Info** window as follows:

| Setting | Value |
| --- | --- |
| Category | Console |
| Label |  |
3. Connect the output port (right) of the **Map Keys** operator to the input port (left) of the **Console** operator.
4. Click **Save**.
5. **Save** your module.

Here's how your completed module looks in the Module Builder:

![Completed module builder.](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/UploadExcel_ModuleBuilder.png?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)

## Configure the Excel Sheet

Your final step happens outside of Unqork. A best practice for Excel uploads is to provide your end-user with an Excel template. Remember that the column labels must match what's used in your Data Table component. You can also set up fields with validation criteria in the Excel template. Keep in mind that data mapping is case sensitive, so you must set those restrictions in your template as well. In our example, we’ll set our Number of Annual Visitors, Property Acreage, and Number of Holes columns to accept numeric values greater than 0.

1. In Excel, open a **blank workbook**.
2. In the first row, enter the following **headers**:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_Headers.jpg?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
  1. Golf Course Name
  2. Number of Annual Visitors
  3. Property Acreage
  4. Number of Holes
3. Highlight columns **B**, **C**, and **D**.
4. Click the **Data** tab and select **Data Validation**.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_Validation.jpg?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
5. From the **Allow** drop-down, select **Whole Number**.
6. From the **Data** drop-down, select **Greater Than**.
7. Set the **Minimum** as `0`.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_Criteria.jpg?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)
8. Click **OK**.
9. **Save** your Workbook.

With the above steps completed, you can test your configuration. In your Excel template, input some sample data. Then, preview your Unqork module in Express View and upload the Excel sheet.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Solutions_ExcelUpload_GIF.gif?sv=2026-02-06&spr=https&st=2026-11-10T12%3A00%3A21Z&se=2026-11-10T13%3A00%3A21Z&sr=c&sp=r&sig=yWzWImTmLkyiFjyhG%2ByKSkqnKIkDpkcCRAgAHIWqtIw%3D)

End-users, also known as Express Users, are the individuals accessing an application through Express View. In most cases, end-users are the customers using the product.

Also known as Record Data. Submission data consists of information saved by Unqork components. View submission data by using the angular command, or in Record Collections.

Also known as Record Data. Submission data consists of information saved by Unqork components. View submission data by using the angular command, or in Record Collections.

A Property ID is the unique field ID used by Unqork to track and link components in your module.

Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field.

JSON (JavaScript Object Notation) is an open standard file and data interchange format. Unqork uses JSON for submission (record) data.

Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the .

Enter inputs components and actions you want the component to perform..

Enter outputs components and actions you want the component to perform.

An object is a type of data structure that represents a single, self-contained entity that acts as a container for the characteristics of that entity.

Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View.

Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field.

A Property ID is the unique field ID used by Unqork to track and link components in your module.