Data Shuttle FAQs

Data Shuttle can perform automatic uploads of CSV or XLSX exports from other systems and can generate CSV or XLSX exports from Smartsheet. It doesn’t create a direct connection with other systems, but it can be used to streamline upload merges of information into existing sheets. 

There are integrations and connectors to specific systems (including bidirectional syncs with Jira, Salesforce, and Microsoft Dynamics 365). Bridge by Smartsheet can create custom Integrations with other systems.

CSV, XSLX, or Google Sheet files that are either attachments to a sheet in Smartsheet or stored in Google Drive, Microsoft OneDrive/SharePoint, or Box.

In Commercial accounts, all drives (including Google Drive, OneDrive/Sharepoint, & Box) are accessible by default based on system permissions, but the SysAdmin may restrict access. In Gov accounts, these drives are not accessible by default and you must contact support to activate access.

The Live Data Connector provides a common Integration to any ODBC-capable external application. The ODBC is a desktop product, so the customer needs to be able to install external products. This means it doesn’t really work with cloud services.  

If it's not capable, then you'd likely need an export so Data Shuttle can pick it up from an external storage service.

Yes. Workflows need to be deleted completely or they will count towards your total number of workflows.

Yes, Data Shuttle is available in the Commercial Smartsheet instance in both the US and EU, as well as Smartsheet Gov. To learn more visit the Smartsheet Gov and Smartsheet Regions articles. 

You can create a new sheet by importing an XLSX file into Smartsheet. If you have an existing sheet that needs changes merged into it on a recurring cadence, then creating a Data Shuttle upload workflow is more efficient.

Data Shuttle can offload data from Smartsheet to OneDrive/Sharepoint, Box, Google Drive or as an attachment to a Smartsheet sheet. Attachment formats can be in either Excel XLSX or CSV format.

You can see any workflows that you have created. Smartsheet SysAdmin can see all workflows created by users in their organization. For more information, see Manage existing Data Shuttle workflows.

Files imported via Data Shuttle must be encoded as UTF-8.

Yes. You can set filters on upload and offload workflows to only import or export a subset of your data. 

If you need to upload from a source to replace more than 5,000 rows or merge data into 20,000 rows, you can apply filters or map to only a selection of columns. You can also create multiple workflows using a common data category to distribute the data into multiple sheets. You can offload up to 20,000 rows. 

Any user on a plan that is licensed to use Data Shuttle can access by logging in at datashuttle.smartsheet.com. Data Shuttle appears in the launcher until a user logs in for the first time. Sys Admins can restrict access to Data Shuttle and other premium apps in the User Admin Center.