How to Combine Multiple Sheets in Smartsheet

Updated 2026-10-04

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:

  1. Select the rows in the source sheet (click the first row number, Shift-click the last).
  2. Right-click the selection and choose Copy to Another Sheet…, then pick the destination.
  3. Repeat for every source sheet, and tidy up the destination afterwards.

Where copying falls down

Columns are matched on name and type. Where either differs — or the destination simply lacks the column — the copied values land in new columns added to the right rather than the ones you meant, so a stray "Status " with a trailing space quietly spawns a duplicate column. (A system column with a conflicting name is the one case that errors outright instead.) Formulas are not retained; the destination keeps their computed values. And a copy is capped at 500 rows at a time, with no duplicate protection if you run the same batch twice — so with several source sheets this becomes a recurring manual chore.

For ongoing consolidation, native Copy Row automation can copy qualifying rows into a destination sheet, including on Pro. Setup requires Owner/Admin access to both sheets. Copies contain static values rather than retained formulas, and the workflow does not provide a general key-based merge or deduplication pass over several existing sheets.

Option 2: a multi-sheet report

On Business or higher, a row report can display multiple source sheets together. Pro reports allow one source sheet. Reports display data stored in the source sheets, and permitted edits write back to those sources. A report does not create a consolidated sheet or accept new rows, though reports can supply features such as dashboard report widgets.

Option 3: merge into one master sheet automatically

Our Merge Sheets tool appends rows from selected sources into a master sheet, matching columns by title. Unmatched fields are skipped, so review the preview for omissions and compatible column types. Optional source tagging records origin, and a dedupe key can skip values already in the master. Existing matching rows are not updated by this append operation.

Official Smartsheet documentation: Copy rows, Copy Row automation, Reports and plan limits.

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 Free

Frequently asked questions

Can I merge two sheets in Smartsheet?

You can copy rows manually, configure native Copy Row automation for ongoing copying, display sources together in a report on Business or higher, or use a bulk merge tool. These options differ in whether they create copies, maintain a view, or append selected data.

Does a report combine sheets into one?

A multi-sheet report on Business or higher presents a live view; its data remains in the source sheets. Permitted edits update those sources. Pro reports support one source sheet. Reports can supply dashboard widgets but do not become a new consolidated sheet.

How do I avoid duplicate rows when consolidating?

Manual and automated row copying do not perform key-based deduplication. Our Merge Sheets tool can skip keys already in the master. Choose a suitable key and inspect the preview on each run; matching existing rows are skipped rather than updated.