Administration and Executive AssistantTier 260 minintermediate

Working with Real Data: Messy Imports

Take a raw export and make it usable.

What you will learn

• Import CSV and understand encoding issues
• Remove duplicate rows
• Handle blank rows and missing values
• Standardize text case and spacing
• Build a cleaning workflow

Excel skills

Text to Columns, Remove Duplicates, Find & Replace, formulas · Data Preparation

The task

Forty rows came in from a merged mailing list and I know some of these are the same person twice, just typed differently - different capitalisation, an extra space, that sort of thing. I need to know how many actually distinct people are in this list before I pay per-contact for the mail-out.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free