Data cleaning guides
Honest, accurate, step-by-step guides for cleaning spreadsheet data in Microsoft Excel and Google Sheets. Each guide shows the real manual method — and the faster way to do the same job in one click, entirely in your browser, with nothing uploaded.
How to remove duplicates in Excel
Find and delete duplicate rows with the Remove Duplicates button, COUNTIF, or Google Sheets.
How to split full names in Excel
Separate a full-name column into first and last name with Text to Columns or formulas.
How to format phone numbers in Excel
Standardize a messy phone column to a consistent format, including the E.164 standard.