Create a worksheet from a data file
  • 26 Apr 2023
  • 1 Minute to read
  • Dark
    Light

Create a worksheet from a data file

  • Dark
    Light

Article summary

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

  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:

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

  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.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.