About DataTable

Applies to

Smartsheet Advance Package


Who can use this capability

You must be an Admin or Owner of the sheet to use DataTable.

DataTable is a new type of object that can store millions of rows of data, integrate with external systems using Data Shuttle, and sync subsets of that data into sheets.

DataTable makes it possible for you to use Smartsheet features to work with large data stores or unique custom views, applied formulas, workflows, and more on that data. And your data is always consistent and up to date.

Access DataTable

To use DataTable, your Smartsheet account administrator must grant you the DataTable role in Admin Center. To create a connection between a DataTable and a sheet, you must also be an admin or owner of the sheet. 

  • On the left navigation, select Browse and then select DataTables. 

Get started with DataTable

You can build a DataTable from scratch, but the easiest way to create one is to upload the data via Data Shuttle. 

  1. On the left navigation bar, select Browse > DataTables.
  2. On the top right corner of the DataTables screen, select Create, then select From OneDrive, Google Drive, Box, or Smartsheet attachment
  3. Follow the instructions on your screen. 

That's it. You can now use data from your DataTable in sheets to analyze, perform calculations, create workflows, and more. If you want to make changes, you can manage your DataTable.