Data Cleaning Service Guide

How to clean a messy contact list for a client, from the first message to the delivered file — using free tools that run in your browser.

ℹ️ No income promises. These guides teach a skill and a way to offer it. Whether you earn anything depends on your effort, your market, and the clients you find. Some people will not land a paying client, and nothing here guarantees one.

What Clients Actually Need

Most small businesses have a spreadsheet they are afraid to use: a lead list exported from a prospecting tool, a customer list merged from three places, or sign-ups typed in by hand. The usual problems are the same every time.

• The same person appears more than once
• Blank rows and stray spaces break imports
• Phone numbers and dates are written five different ways
• Names are in ALL CAPITALS or all lowercase
• Some email addresses are obviously broken

Your service is simple to describe: they send a messy file, you send back a clean one and a report of what changed. The report is what makes it professional.

The Job, Step by Step

1. Ask before you quote. How many rows, where the file is going, and which duplicates to keep. Use the client intake questions.

2. Keep the original. Save an untouched copy. You will need it to check your work and to answer questions later.

3. Score it first. Run the file through the Data Health Score. The before-score is a simple way to show the client where they started.

4. Clean it. Open the CSV Cleaner, upload the CSV or Excel file, and choose the options that fit the job. For a contact list that usually means all of them. Use Merge duplicate emails only when each person should appear once; leave it off for order histories or anything where repeat rows are normal.

5. Read the report. The "Needs review" section lists every value the tool was not sure about: phones and dates it could not recognize, invalid emails, rows with too many cells. The tool leaves these unchanged. Fix the ones you are certain about by hand and list the rest for the client.

6. Check your own work. Go through the delivery checklist. Compare ten random rows with the original.

7. Deliver two files. The cleaned CSV and the change report, with a short message: rows in, rows out, what you removed, what you standardized, and what still needs their decision.

Practice Project: Outbound lead list

A nine-row lead list with a duplicate, a blank row, a header pasted in twice, mixed formats, and two bad emails. Every person and company in this file is fictional.

Open This File in the CSV Cleaner Download the CSV

Before

Outbound lead list before cleaning
Full Name	Email	Phone	Signup Date	Company
MARIA GONZALEZ	Maria.Gonzalez@Northwind-Example.com	(415) 555-0142	3/14/2026	Northwind Example Co
(empty)	(empty)	(empty)	(empty)	(empty)
david o'connor	david@harborlight-example.com	415.555.0178 ext 4	03/22/2026	Harborlight Example LLC
MARIA GONZALEZ	maria.gonzalez@northwind-example.com	(415) 555-0142	3/14/2026	Northwind Example Co
Priya Raman	priya.raman@gmial.com	555-0119	April 2 2026	Raman, Patel & Co (example)
Full Name	Email	Phone	Signup Date	Company
Tom Becker	tom.becker[at]example.org	+44 20 7946 0321	2026-04-09	Becker Example Ltd
priya raman	PRIYA.RAMAN@gmial.com	(empty)	(empty)	(empty)
Ludwig van Hoorn	l.vanhoorn@example.net	1-312-555-0166	4/15/2026	Van Hoorn Example BV

After

Produced by the CSV Cleaner with every option switched on. Run it yourself and compare.

Outbound lead list after cleaning
Full Name	first_name	last_name	Email	Phone	Signup Date	Company	email_check
Maria Gonzalez	Maria	Gonzalez	maria.gonzalez@northwind-example.com	+14155550142	2026-03-14	Northwind Example Co	ok
David O'Connor	David	O'Connor	david@harborlight-example.com	+14155550178 x4	2026-03-22	Harborlight Example LLC	ok
Priya Raman	Priya	Raman	priya.raman@gmial.com	555-0119	2026-04-02	Raman, Patel & Co (example)	check domain (did you mean gmail.com?)
Tom Becker	Tom	Becker	tom.becker[at]example.org	+442079460321	2026-04-09	Becker Example Ltd	invalid format
Ludwig van Hoorn	Ludwig	van Hoorn	l.vanhoorn@example.net	+13125550166	2026-04-15	Van Hoorn Example BV	ok

The change report

Report text for Outbound lead list

SMARTDATAAI — CLEANING REPORT
Source: lead-list.csv (fictional practice data)

SUMMARY
Rows in (excluding header): 9
Rows out: 5
Rows removed: 4
  Empty rows: 1
  Exact duplicates: 1
  Repeated header rows: 1
  Duplicate emails that added nothing new: 1
Cells changed: 18
  Leading/trailing spaces trimmed: 1
  Inner spaces and line breaks collapsed: 1
  Emails normalized: 2
  Phones standardized to +E.164: 5
  Dates standardized to YYYY-MM-DD: 5
  Names re-cased: 4
Columns added: first_name, last_name, email_check

COLUMNS DETECTED
Email: Email
Phone: Phone
Date: Signup Date
Name: Full Name

NEEDS REVIEW
- Invalid email format: 1 (rows 8)
- Possible email domain typos: 1 (rows 6)
- This list contains international numbers. 3 ten-digit number(s) with no country code were read as US/Canada (+1) (rows 2, 4, 5). Check that those rows are US or Canadian numbers.
- Phones not recognized, left unchanged: 1 (rows 6)

SAMPLE OF CHANGES (first 15 of 18)
Row 2 · Email: " Maria.Gonzalez@Northwind-Example.com " → "Maria.Gonzalez@Northwind-Example.com"  [whitespace]
Row 2 · Email: "Maria.Gonzalez@Northwind-Example.com" → "maria.gonzalez@northwind-example.com"  [email]
Row 2 · Phone: "(415) 555-0142" → "+14155550142"  [phone]
Row 2 · Signup Date: "3/14/2026" → "2026-03-14"  [date]
Row 2 · Full Name: "MARIA GONZALEZ" → "Maria Gonzalez"  [name case]
Row 4 · Phone: "415.555.0178 ext 4" → "+14155550178 x4"  [phone]
Row 4 · Signup Date: "03/22/2026" → "2026-03-22"  [date]
Row 4 · Full Name: "david o'connor" → "David O'Connor"  [name case]
Row 5 · Phone: "(415) 555-0142" → "+14155550142"  [phone]
Row 5 · Signup Date: "3/14/2026" → "2026-03-14"  [date]
Row 5 · Full Name: "MARIA GONZALEZ" → "Maria Gonzalez"  [name case]
Row 6 · Full Name: "Priya  Raman" → "Priya Raman"  [inner whitespace]
Row 6 · Signup Date: "April 2 2026" → "2026-04-02"  [date]
Row 8 · Phone: "+44 20 7946 0321" → "+442079460321"  [phone]
Row 9 · Email: "PRIYA.RAMAN@gmial.com" → "priya.raman@gmial.com"  [email]

Values the tool cannot settle are left as they were and listed above. Where the day/month order of a date was worked out from other dates in the same column, that is listed above too.
Row numbers refer to the original file (header = row 1). Email checks cover format only; they do not confirm that a mailbox exists.

What the Tools Do Not Do

Be exact about this with clients. It protects you.

• They check email format, not whether the mailbox exists. Never call a list "verified" on the strength of a format check.
• They do not find missing information. No job titles, no phone numbers, no company details.
• They are rule-based, not AI. That is a strength: every change follows a rule you can explain, and every change is in the log.
• They do not catch near-duplicates such as the same person with two different email addresses. Sort by name and look.

Templates for This Service

📄 Service description template
✅ Delivery checklist
❓ Client intake questions

Next: CRM cleanup guide · Suggested service packages

Free Tools vs. Human Services

SmartDataAI offers two different things. Please do not mix them up when you talk to clients.

Free browser tools

Run on your own computer. Nothing is uploaded, there is no signup, and nobody at SmartDataAI sees the file. Rule-based, not AI. You — or your client — do the work.

Optional human services

A person cleans the file for a fee. The client chooses to send the file, and it is handled under our Privacy Policy. See the $19 cleaning service or ask for a quote.