Data Formats
-
How to Clean an Email List in a Spreadsheet
Cleaning an email list in a spreadsheet takes four passes: lowercase and trim every address, flag structurally invalid ones (no @, spaces, doubled dots), remove duplicates, and only then worry about deliverability, which a spreadsheet cannot test. Here is each pass with the exact formulas, and what honestly requires an email verification service. Pass 1:
-
Why Dates Sort Wrong in Excel (and How to Fix Them)
Dates sort wrong in Excel because some of your “dates” are real date values and some are text that only looks like a date. The fix is converting everything to one true date type, or to the ISO format YYYY-MM-DD, which sorts correctly even as text. Here is how to diagnose which problem you have
-
How to Fix Phone Number Formats in a Spreadsheet
To fix inconsistent phone numbers in a spreadsheet, strip every non-digit character, then reapply one display format, usually (555) 123-4567 for US numbers. In Excel that is a nested SUBSTITUTE formula plus TEXT; in our free cleaning tool it happens automatically with a preview of every change. This guide shows both, plus the edge cases