How to Update a Smartsheet from an Excel File
To bring Excel changes into Smartsheet, first decide whether you want a new sheet, to overwrite an existing sheet, or to update matching rows by unique ID. These operations have different effects on existing data.
Option 1: copy and paste
For a handful of rows, copying cells from Excel and pasting them into the grid works. It gets risky fast: the paste lands by position, so the rows in Excel must line up exactly with the rows in the sheet. If the sheet has been sorted, filtered or had rows added since the export, values land on the wrong rows with no warning.
Option 2: import a new sheet or overwrite an existing one
Use +Create → Import to create a new sheet from a file. The new sheet does not inherit the old sheet’s attachments, comments, forms, automations or incoming references.
You can also import into an existing sheet in Table View: open the three-dot menu beside the sheet name, select Import, choose the file, and review the import panel. This overwrites existing data; it does not selectively merge rows by ID. Keep a recoverable copy and review the import messages before proceeding.
Option 3: Data Shuttle
Smartsheet's own answer for recurring file uploads is Data Shuttle, a premium add-on that can merge uploaded files into an existing sheet on a schedule. It is a good fit for enterprise pipelines, but it is a paid add-on gated to eligible plans, and setup is heavier than a one-off update warrants.
Option 4: sync by unique ID
Our Data Sync tool updates the sheet you already have. Upload the Excel (or CSV/JSON) file, pick the column that uniquely identifies each row in both places, and each file row is matched to its sheet row by ID — row order never matters. Only cells that actually differ are written, blanks in the file leave existing cells alone unless you opt in to clearing, and a preview shows every change before anything is saved.
Official Smartsheet documentation: Import files, Data Shuttle uploads.
Do it in one pass instead
Upload a CSV, JSON or Excel file and update the matching Smartsheet rows by unique ID. Only changed cells are written, with a preview before anything is saved.
Try Data Sync FreeFrequently asked questions
Can I update an existing Smartsheet from an Excel file?
Yes. In Table View, the menu beside the sheet name offers Import, which overwrites existing data. Importing through +Create creates a new sheet. For selective updates matched by unique ID, use Data Shuttle or an ID-based sync tool; copy-paste instead matches by position.
How are Excel rows matched to Smartsheet rows?
With our sync tool, by a unique ID column that exists in both the file and the sheet. Each file row updates the sheet row with the same ID, so sorting and row order never matter.
What happens to cells my Excel file leaves blank?
By default blank values leave the existing cell untouched, so a partial export cannot wipe data. Clearing cells from blanks is an explicit opt-in toggle.