Clean 50 email entries
Budget: $10 – $30 USD
I have a spreadsheet of roughly 500 email addresses that needs a quick but careful cleanup. Your task is to eliminate duplicates, force every address to lowercase, and run a sanity-check pass for the most common mistakes.
Here’s exactly what I expect:
• All entries in pure lowercase.
• Any address missing a domain should be removed outright.
• If an address looks fixable—say the “@” symbol is absent or there’s an obvious typo in “gmail.com” or “yahoo.com”—go ahead and correct it; only discard when the fix is truly unclear.
• Return a single, tidy worksheet plus a short note summarising how many rows were deleted, how many were corrected, and anything that still looked suspicious.
You’re free to work in Excel, Google Sheets, or your favourite cleaning tool, as long as the final file comes back in a standard .xlsx or .csv format. Quick turnaround appreciated; accuracy expected.
Here’s exactly what I expect:
• All entries in pure lowercase.
• Any address missing a domain should be removed outright.
• If an address looks fixable—say the “@” symbol is absent or there’s an obvious typo in “gmail.com” or “yahoo.com”—go ahead and correct it; only discard when the fix is truly unclear.
• Return a single, tidy worksheet plus a short note summarising how many rows were deleted, how many were corrected, and anything that still looked suspicious.
You’re free to work in Excel, Google Sheets, or your favourite cleaning tool, as long as the final file comes back in a standard .xlsx or .csv format. Quick turnaround appreciated; accuracy expected.