All 22 tools
Grouped by task. Every tool that writes to a sheet shows a preview first.
Clean up data
Find and replace values
Update repeated text across the sheets you select, with a preview of every proposed replacement.
Remove duplicate rows
Choose the columns that define a duplicate, review the matches, and decide which copies go.
Clean up messy text
Trim stray spaces and clear blank rows across the sheets you pick, in one previewed pass.
Rename columns in bulk
Standardise column names across many sheets and review the rename plan before any header changes.
Update sheets
Look up values across sheets
Match on a key column and pull values from a source sheet into a target — no VLOOKUP formulas to maintain.
Merge sheets into one master
Pull rows from any number of source sheets into one master, matched by column title.
Push a new option list
Paste the options once and push them to the same dropdown across the sheets you pick.
Keep dropdowns consistent
Use one sheet column as the master list and push its values to a dropdown wherever it is needed.
Update a sheet from a file
Match CSV, JSON or Excel rows to existing rows by ID and write only the cells that changed.
Audit access
Run a health check
One read-only scan: public links, external sharing, broken workflows and stale sheets, worst first.
Review sheet access
Review sharing entries, flag different email domains, and remove selected shares.
Find published sheets
Review published links returned by the scan, ranked by access settings.
Review and pause automation rules
Inspect supported rules, search explicit recipient emails, review disabled workflows and pause the ones that should stop.
Find broken references
Review the cross-sheet references Smartsheet reports it can no longer resolve, across every sheet you can open.
List your column formulas
See every column formula across the sheets you can open, with the ranges each one reads.
Find formula drift in a sheet
Spot the columns where a shared formula was overwritten by hand, row by row.
Find stale sheets
Rank returned sheets by last-modified date, with your access level on each.
Export & capture
Back up a sheet
Download sheet data, comments and attachments together as one zip.
Download every attachment
Collect all the files on a sheet, report or workspace into a single zip.
Embed images in bulk
Drag and drop many images at once; the workspace is built and each image lands in its cell.
Capture notes into Smartsheet
Drop links, files and notes into a triage row the moment they turn up, and process them later.
Triage notes visually
Organise, filter and approve captured notes in a card view before pushing them live.
No tool matches that. Try a different word, or browse the guides.