How to Combine Multiple Sheets in Smartsheet
Sooner or later the data you need is spread across several sheets — one per region, per quarter, per intake form — and you need it in one place. Smartsheet has no single "combine sheets" button, but there are three workable routes depending on whether you need a copy, a view, or a real consolidated sheet.
Option 1: copy rows between sheets
For a one-off, Smartsheet can copy rows directly:
- Select the rows in the source sheet (click the first row number, Shift-click the last).
- Right-click the selection and choose Copy to Another Sheet…, then pick the destination.
- Repeat for every source sheet, and tidy up the destination afterwards.
Where copying falls down
Columns are matched by name, and any source column the destination lacks gets created on the fly — so a stray "Status " with a trailing space quietly spawns a duplicate column. Formulas are not retained on copied rows, there is no duplicate protection if you copy the same batch twice, and with several source sheets this becomes a recurring manual chore.
Option 2: a multi-sheet report
A row report can display rows from many sheets in one grid, with filtering, grouping and summaries — often exactly right when you only need to see everything together. But a report is a live view, not a sheet: the rows still live in their source sheets, and you cannot use the report itself as a plain consolidated data source or add rows to it.
Option 3: merge into one master sheet automatically
When you need an actual combined sheet, our Merge Sheets tool appends rows from any number of source sheets into a master in one pass. Columns are matched by title (mismatches are skipped, never misfiled), each row can be tagged with its source sheet's name, and a dedupe key lets you skip rows the master already has — so re-running after new data arrives only adds what is new. A preview shows the full plan before anything is written.
Do it in one pass instead
Combine rows from many Smartsheets into one master sheet, matched by column title, with optional source tagging and duplicate skipping.
Try Merge Sheets FreeFrequently asked questions
Can I merge two sheets in Smartsheet?
There is no built-in merge button. You can copy rows between sheets manually, view sheets together in a report, or use a merge tool that appends rows from many source sheets into one master with columns matched by title.
Does a report combine sheets into one?
Only as a view. A row report displays rows from many sheets in one grid, but the rows still live in their source sheets — it is not a consolidated sheet you can treat as a data source.
How do I avoid duplicate rows when consolidating?
Manual copying has no duplicate protection. The Merge Sheets tool lets you set a column as the dedupe key, so source rows whose value already exists in the master are skipped — safe to re-run as new data arrives.