---
title: "Generate Excel Snippet"
slug: "generate-excel-snippet"
updated: 2025-09-25T23:38:40Z
published: 2025-09-25T23:38:40Z
canonical: "docs.unqork.io/generate-excel-snippet"
---

> ## 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.

# Generate Excel Snippet

## Overview

The Generate Excel snippet gives you an Export button you can add to your module. When your end-user clicks the button, they'll download an .xlsx file of the module's data.

This snippet is a great addition to a dashboard. Use it any time to give your end-user the ability to export their dashboard data.

The snippet works out-of-the-box, exporting the data found in the Data Table component. But, when you set the snippet up in your own module, you can configure it to export any of the data in the module.

Here's how the snippet looks in Express View:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_01.gif?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)

And here's how the snippet looks in the Module Builder:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_02.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)

## Adding the Snippet

Once you determine a need for generating an excel sheet, you'll add the Generate Excel Snippet.

Before you use this snippet in your application, you must install the snippet to your environment.

### Adding the Snippet to Your Environment

To add the snippet to your environment:

1. At the top right of the Unqork Designer Platform, click **Library**.
2. Click **Template****s**.
3. Click **Marketplace**.

> [!NOTE]
> You can also access the Marketplace at any time by visiting [https://marketplace.unqork.io](https://marketplace.unqork.io/#/).
4. In the **Search the Listings Directory** field, enter Generate Excel.
5. Click the **Generate Excel** tile.
6. Click **Install to Environment**.
7. Click **Install** **Template**.

> [!NOTE]
> If you aren't logged in, you'll see a field for **Environment URL** and a **Login** button. Enter your environment's URL where to install the template. For example: [environmentname.unqork.io]. Click the **Login** button. Then, return to step 4 and click **Install to Environment** again. Follow the remaining steps as listed.

Now, you can now use your newly installed snippet in your application.

### Adding the Snippet to Your Module

After you install the Generate Excel snippet to your environment, you can drag and drop the snippet into your module:

1. In the left sidebar of the Module Builder, click the **Snippet****s** button.
2. In the search bar, enter Generate Excel.
3. Drag and drop the **Generate Excel** snippet onto your canvas.

> [!NOTE]
> If you don't see the snippet at first, make sure to expand the **Marketplace Snippets** section.
4. **Save** your module.

## How the Snippet Works

The Generate Excel snippet has 6 components that all work together. The chain of events starts with a button click and ends with an .xlsx file downloaded to the end-user's desktop.

First, your end-user clicks the Export button. The button triggers the Data Workflow. Here's what the Data Workflow's canvas looks like:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_03.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)

As you can see, the Data Workflow inputs the data from the Data Table. It then converts that data to an HTML table. Finally, the Data Workflow outputs the HTML table to the excelHTML Hidden component.

Then the initExportExcel Initializer component comes into play. This Initializer uses the Hidden component as its input. So, when the Data Workflow outputs data to the Hidden component, the Initializer gets triggered. The Initializer then triggers the Content component. The Content component is what actually downloads the Excel file. In the image below, you can see how the Content component pulls the data from the excelHtml component:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_04.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)

In the configuration window of the Content component, you'll see the toggle for **Include Excel Download Link** is set to **ON**. This allows the data in the Content component to download as an .xlsx file. The **Hide Component** setting is also set to **ON**. That way, the only thing visible in the front end is the Export button.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_05.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)

## Setting Up the Snippet

By default, the snippet exports an .xlsx file that looks like this:

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_07.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)

Most likely, this file isn't useful to you. That's because it's a placeholder. To integrate this snippet into your module, you'll customize the export with your module's data.

> [!NOTE]
> The file name comes from the Property ID of your export Content component. But, you can customize this feature as well.

### Connecting The Snippet to Your Dashboard

The key to connecting this snippet to the module's data is in the excelHTML Hidden component. Whatever data you output into that Hidden component is exported in the Excel file. If you have a dashboard module, you have a Plug-In whose data you can output to the Hidden component. See below for how to connect this snippet to an existing dashboard.

These instructions assume you have a working dashboard.

### Adding the Snippet

To add the snippet to your module:

1. In the left sidebar of Module Builder, click the **Snippet****s** button.
2. In the search bar, enter Generate Excel.
3. Drag and drop the **Generate Excel** snippet onto your canvas, positioning it either above or below the ViewGrid component.
4. **Save** your module.

### Deleting the Data Table Component

1. In the Module Builder hover over the **dtToExportData Table** component.

A 5-button toolbar displays above the component on hover-over.
2. Using the toolbar, click the ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/AppBuildButton_Remove(18).jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D) (**Remove**) button.

### Updating the Data Workflow Component

1. In the Module Builder hover over the **dwfCreateExcelData Workflow** component.

A 5-button toolbar displays above the component on hover-over.
2. Using the toolbar, click the ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/AppBuildButton_Settings(27).jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D) (**Settings**) button.
3. Click the **Input** operator.
4. In the **Component** field, select your Plug-In component that retrieves submissions.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_08.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)
5. Click **Save**.

Your dashboard now has an Export button that pulls and exports the dashboard's data.

## Customizing the Snippet

There are two different ways you can customize what data gets exported into the Excel file. You can either omit certain data from the file or choose which data to include in the file. Which method you choose depends on how many values you include in the Excel file. If you want to omit one or two values, the **Omit** operator is easiest. If you want to include a small number of the values, the **Pick** operator is better.

### Updating the Data Workflow Component

1. In the Module Builder hover over the **dwfCreateExcelData Workflow** component.

A 5-button toolbar displays above the component on hover-over.
2. Using the toolbar, click the ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/AppBuildButton_Settings(27).jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D) (**Settings**) button.

#### Configuring the Pick Operator

The first way you can customize the Excel file is by choosing which data to include in the file. For this, you'll use the Pick operator.

1. Drag and drop a **Pick** operator onto your Data Workflow canvas.
2. In the **Pick Keys** field, enter the values to export. Separate each value with a comma.
3. Delete the line connecting the Input operator and HTML Table operator.
4. Connect the output port (right) of the **Input** operator to the input port (left) of the Pick operator.
5. Connect the output port (right) of the **Pick** operator to the input port (left) of the HTML Table operator.

![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/Snippets_Generate_Excel_09.jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D)
6. Click **Save**.

#### Configuring the Omit Operator

The Omit operator works the same way as the Pick operator, but in reverse. So, enter any values you don't want to export into the **Omit Keys** field.

1. Drag and drop an **Omit** operator onto your Data Workflow canvas.
2. In the **Omit Keys** field, enter the values you don't want to export. Separate each value with a comma.
3. Delete the connection between the Input operator and HTML Table operator.
4. Connect the output port (right) of the **Input** operator to the input port (left) of the Omit operator.
5. Connect the output port (right) of the **Omit** operator to the input port (left) of the HTML Table operator.
6. Click **Save**.

Your Excel file now omits any values you added to the Omit operator.

## Removing the Snippet

You might want to remove a snippet from your application. Here, you'll learn how to remove the snippet from your module. Then, you'll learn how to uninstall the snippet from your environment.

### Remove the Snippet from Your Module

To remove the Generate Excel snippet:

1. In the Module Builder, hover over the **panelGenerateExcel** Panel.

A 5-button toolbar displays above the component on hover-over.
2. Using the toolbar, click the ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/AppBuildButton_Remove(18).jpg?sv=2026-02-06&spr=https&st=2026-11-09T16%3A59%3A10Z&se=2026-11-09T17%3A59%3A10Z&sr=c&sp=r&sig=nYpSjJoHUAR91zAhVTwrHlmx3ZQ9ZMtIIjX0v0nfG%2F4%3D) (**Remove**) button.
3. **Save** your module.

### Remove the Snippet from Your Environment

Use the Unqork Template Library to remove unused snippets. To uninstall a snippet from your environment:

1. At the top right of the Unqork Designer Platform, click **Library** or **Template****s**.
2. Find the snippet you want to uninstall.
3. Click the **ellipsis** (...) in the snippet's tile header.
4. Click **Uninstall** **Template**.
5. Click **Yes, Uninstall** in the confirmation modal.

You can visit the Marketplace and reinstall the snippet at any time.

> [!NOTE]
> What if you have an existing application built using this snippet and then uninstall the snippet from your environment? No problem. Your existing application remains unaffected. Also, your application doesn't have any ties to the snippet. So, let's say you reinstall a newer version of the snippet in the future. You can rest assured that the installation doesn't impact your existing application.