Create and populate a DataTable

Prerequisites

To use DataTable, you must:

• Be aLicensed User
• 对一个有所有者或管理员权限y DataTable connected sheets
• Have DataTable permissions enabled inUser Managementby a Smartsheet System Admin

You can add, edit, or remove fields after you've created the DataTable. DataTable supports text, number, date, and checkbox fields. The field type is important for searching and filtering – for example, if you want to search or filter based on dates, your field must be the associated date type.

Create a DataTable

There are two ways to create a DataTable: Create an empty data table and populate the data later, or use a Data Shuttle workflow.

Option 1: Create an empty DataTable

Using this method, you will create an empty DataTable and then use a Data Shuttle workflow to populate the data. Creating the DataTable first gives you more data formatting options at setup.

1. On the left navigation bar, select Browse > DataTables.
2. On the top right corner of the DataTables screen, select Create, then select Create a blank DataTable.
3. Follow the instructions on your screen.

You can edit the DataTable schema on the Setting page at any time. Be aware changes can impact your sheet connections and Data Shuttle workflows.

Option 2: Create a new DataTable and Data Shuttle workflow

The import wizard auto-detects the source file column heading and maps the headers to your DataTable schema.

This method does not support advanced date format options. The Data Shuttle workflow option will only detect the standard ISO format YYYY-MM-DD HH:MM:SSZ. If your source file contains a different format, use option one above.

1. On the left navigation bar, selectBrowse>数据表s.
2. On the top right corner of the数据表sscreen, selectCreate, then selectFrom OneDrive, Google Drive, Box, or Smartsheet attachment.
3. Follow the instructions on your screen.

Import data into a DataTable

Once you have a created DataTable, you can create DataShuttle workflows to populate the DataTable with additional data.

You can create multiple workflows for a single DataTable, but use the same unique identifier to prevent the addition of duplicates and empty fields on subsequent workflow runs.

Learn more about DataShuttle.

1. Log into datashuttle.smartsheet.com
2. Select the plus icon in the left navigation bar.
3. SelectUpload Dataand follow the instructions on your screen. For Target (step two), select DataTable and proceed with the setup.

Make sure you have selected field typeNumberfor any numeric data. DataTable doesn’t interpret special characters (currency symbols, commas, percentage signs, etc.) as numeric values. Do not include percent, commas, or currency symbols — instead, format percentages as a decimal value (e.g. 0.5 instead of 50%).

---

Smartsheet Universitysubscribers can learn this process in theCreate and Connect a DataTable course.