SmartLinkEx

Seamlessly import data from Excel, CSV, and Google Sheets into Smartsheet

SmartLinkEx for Smartsheet automatically imports data from Excel, CSV, and Google Sheets into Smartsheet, ensuring seamless data transfer and minimizing manual data entry errors.

Keep your sheets automatically populated with data in real time

In this demo, customer information in your Customer List sheet will be automatically populated from an external Excel data source, eliminating the need for manual data entry.

Lookup and source columns in the Excel file

You can specify columns from an Excel file to act as the lookup and source data, which will be copied to multiple target sheets in Smartsheet. The Customer ID column will be used as the lookup key, while the other columns will serve as source data.

Lookup and target columns in the target sheet

You can specify lookup and target columns in your sheet to automatically sync with the source Excel file. Whenever you edit or add a new customer in the source Excel, the customer information in the target sheet will be updated or added automatically.

SmartLinkEx task

The SmartLinkEx task is created in Gia Thinh Automation Service. This task is configured with information related to the lookup/source sheet columns and the lookup/taget sheet columns.

Key features

Automatically updates data from a source Excel, CSV, or Google sheet to multiple target sheets.
Option supports overwriting existing data and adding new rows to target sheets.
Includes a filtering option to specify which source row data is updated or added to target sheets.