Consolidate Many Sheets Into One
Stop copy-pasting rows between sheets by hand. Pull rows from as many source sheets as you like into a single master sheet, matched by column title, with a preview before anything is written.
Connect Smartsheet to StartWhy teams use it
Combine sheets in one pass
Append rows from multiple source sheets into a single master sheet without manual copy-paste.
Columns matched automatically
Rows are matched into the master by column title, so mismatched or missing columns are simply skipped.
Know where every row came from
Optionally tag each row with the name of its source sheet, so consolidated data stays traceable.
How it works
Pick the master sheet
Choose the sheet that will receive the combined rows.
Select source sheets
Choose every sheet whose rows should be added in.
Review, then merge
Optionally tag rows by source or skip duplicates, then preview and confirm.
Frequently asked questions
Can I merge rows from several Smartsheets into one?
Yes. Select any number of source sheets and their rows are appended into a single master sheet.
What happens if the columns don't match?
Rows are matched to the master by column title. Columns the master doesn't have are simply skipped, so nothing is misfiled.
Can I skip rows that are already in the master?
Yes. Set a column as the dedupe key and source rows whose value already exists in the master are skipped.
Is there a usage limit?
Previews and dry runs are unlimited and never count. Applying changes (a real write) is capped at 3 bulk runs per account per day while the tool is free, and a single run can span up to 5 sheets. The counter resets daily.
Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start