---
title: "Create a worksheet from a data file"
slug: "configure-worksheet-from-data-file"
description: "Create a worksheet by importing a data file."
updated: 2023-04-26T15:14:58Z
published: 2023-04-26T15:14:58Z
canonical: "docs.zilliant.com/configure-worksheet-from-data-file"
---

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

# Create a worksheet from a data file

In addition to the ability to add a worksheet from an existing data source, you can also create a worksheet by importing a data file. Doing this creates a new data source.

1. From the **Manager Dashboard**, open a workbook.
2. In the worksheet tabs area, select **Add**. ![Add a worksheet.png](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/Add%20a%20worksheet%284%29.png?sv=2026-02-06&spr=https&st=2026-11-02T18%3A24%3A31Z&se=2026-11-02T19%3A24%3A31Z&sr=c&sp=r&sig=7CRWT1yITcB0D5hgVi7q3uYhsHsS0Vb2%2B5zjfi9TTyQ%3D)
3. Enter a name for the new worksheet, then select **Next**.

          Tip

          

The name you specify for the new worksheet is given to the new data source, so Zilliant recommends you choose something short but descriptive. This makes it easier for other users to take advantage of the new data source in other worksheets.

1. Select **Import from file**, then select **Next**.
2. Select a CSV file to load, then select **Next**.
3. Define a set of data source columns to match the columns of the CSV file:

          Note

          

For columns that contain date and time data, make sure to indicate the **DateTime** type. Otherwise, you will get an error message when you proceed with the **Import** action.
  1. In the **Business Key** column, select one or more business key columns.
  2. From the **Column Type** dropdown, select the data type for each column.
4. Select **Add** to add one or more of the newly-defined input columns to the new worksheet.
5. Select **Finalize** to import the CSV data into the new data source and to create the new worksheet.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/add_60(1).png?sv=2026-02-06&spr=https&st=2026-11-02T18%3A24%3A31Z&se=2026-11-02T19%3A24%3A31Z&sr=c&sp=r&sig=7CRWT1yITcB0D5hgVi7q3uYhsHsS0Vb2%2B5zjfi9TTyQ%3D) Add