Data cleaning checklist

A five-step Excel checklist from X user Tanju_mim boiled data cleaning down to the tasks most analysts do before they trust a spreadsheet. (x.com) The post listed remove duplicates, find-and-replace, text-to-column, flash fill, and normalize formatting as a quick prep routine for marketing and analytics work. Microsoft’s own Excel help documents each of those tools as built-in features under the Data or Home tabs. (x.com) (support.microsoft.com) Data cleaning is the step between collecting rows and analyzing them: it strips out repeated records, fixes typos, splits combined fields, and makes dates, currencies, and names follow one format. Microsoft describes Remove Duplicates as a way to filter unique values, Find and Replace as a way to update repeated text or numbers, and Text to Columns as a way to split one cell into several cells. (support.microsoft.com 1) (support.microsoft.com 2) (support.microsoft.com 3) In practice, each item fixes a specific spreadsheet failure. Duplicate customer IDs can inflate counts, “CA” and “California” can split the same market into two buckets, and a full name stored in one cell can block sorting by first or last name. (support.microsoft.com 1) (support.microsoft.com 2) (support.microsoft.com 3) Flash Fill handles the pattern-matching part of cleanup. Microsoft says it can separate first and last names from one column or combine values from two columns after the user gives Excel an example of the pattern to follow. (support.microsoft.com) Normalize formatting is less flashy but usually more important for reporting. Excel lets users standardize cell formats for dates, numbers, currency, alignment, and text so one column does not mix entries like “04/20/2026,” “20 Apr 2026,” and plain text dates. (support.microsoft.com 1) (support.microsoft.com 2) The checklist reads like a shortcut for analysts working in Excel before they move to pivots, dashboards, or attribution models. Microsoft groups many of the same commands under its general “Enter and format data” guidance, which reflects how often cleanup happens before any chart or summary table is built. (support.microsoft.com) That is why short lists like this keep circulating: they turn a messy worksheet into something Excel can sort, filter, and summarize without changing the underlying business question. (x.com) (support.microsoft.com)