Standardise Data in Google Sheets
Standardising data means making values consistent in format, spacing, casing and structure so they can be compared, matched and reported reliably. You can do this with Google Sheets formulas, Apps Script or in-sheet custom functions.
Standardise with formulas
Use built-in functions such as TRIM, CLEAN, LOWER, UPPER, PROPER, SUBSTITUTE and REGEXREPLACE to clean text values. Keep original data in place and write standardised output to helper columns for review.
Standardise with Apps Script
Apps Script is useful for repeatable rules, mapping tables and batch transformations. See Standardise data in Google Sheets with Apps Script and Standardise data by example with Apps Script for practical examples.
Standardise with Flookup NORMALIZE
Flookup's NORMALIZE custom function can clean and transform text in-sheet as part of a formula workflow. It can be combined with FUZZYSIM, FLOOKUP, DEDUPE and ULIST for matching and deduplication tasks. See custom functions for details, or use the Sheets AI Assistant to get formula suggestions.