Use Google Sheets™ built-ins for everyday cleanup
For well-structured records, use the built-in Data cleanup and table tools first. They are direct, familiar and often the fastest way to trim extra spaces, split delimited text, remove exact duplicates, filter records or build a pivot summary. A pivot table requires a header in each source column.
Tasks that need more than routine cleanup
Use Sheet Analyst when a cleanup or reconciliation task needs more than a built-in menu command. Fuzzy matching can help identify records whose names or labels are similar rather than identical. Combine and join workflows bring separate ranges together, while reshape tools change table structure for downstream analysis. Compare ranges to identify added, removed or changed values before acting on a difference.
| Task | Start here | Why |
|---|---|---|
| Trim spaces, split text or remove exact duplicates | Google Sheets™ Data cleanup | These routine cleanup actions are built into Sheets. |
| Summarize a headed table by category | Google Sheets™ pivot table | Pivot tables arrange and aggregate fields from a headed source table. |
| Match labels that are similar but not identical | Sheet Analyst fuzzy matching | Fuzzy matching helps surface likely matches for review. |
| Bring related ranges together or compare two versions | Sheet Analyst combine, join or compare | These workflows focus on reconciliation across ranges. |
Prepare a source range safely
Keep a copy of important source data, select a bounded range and check whether the first row contains headers. Review the preview and result destination before creating an output sheet. Fuzzy matches are candidates for human review—not proof that two records represent the same person or entity.
Common questions
Should I use Sheet Analyst to remove duplicates or trim spaces?
For routine duplicate removal or whitespace trimming, use Google Sheets™ Data cleanup. Sheet Analyst is positioned around more specialized analysis, matching, combining, reshaping and comparison workflows.
Is a fuzzy match automatically a correct match?
No. A fuzzy match is a similarity signal. Inspect candidate records and confirm the appropriate match using your own criteria.
Should my source table have headers?
Use a header row when column names are needed to select or describe fields. Google Sheets™ pivot tables require a header in each source column; review each Sheet Analyst tool’s header option before running it.