I cleaned a client's 2,000-row supplier spreadsheet in 40 minutes with free tools. That job paid $240 — and it was the third data cleaning job I took that week.
This is the workflow I use. Data cleaning is one of the few freelance services where the deliverable is self-evidently verifiable: the client already knows their data is messy.
The five problems that make up 90% of jobs
- Inconsistent formatting — "USA" / "US" / "U.S.A." / "united states"
- Duplicate rows — same email twice, different casing
- Stray whitespace — leading spaces, trailing tabs, non-breaking spaces
- Broken dates — "03/04/2026" (is that March or April?)
- Missing values — blank phone, empty country
I show the client this list with counts from their own file before starting. It takes five minutes and it usually closes the deal.
The free tool stack
- A desktop spreadsheet for the first pass (Excel / LibreOffice Calc).
- A converter for format wrangling — CSV↔XLSX, JSON→CSV, encoding fixes.
- A rule-based script for the repeatable parts: trim, dedupe, normalise, validate.
The pipeline, step by step
1. Profile before touching anything. Count rows, unique values per column, blanks, near-duplicates.
2. Normalise the messy columns. Map country variants to one canonical value; standardise dates to ISO 8601 (2026-03-04).
3. Deduplicate on the right key. Never dedupe the whole row. Pick the unique column (email/ID), lowercase + trim, then dedupe. Log how many rows you removed.
4. Validate and flag. Basic email pattern, phone length, sane date windows. Flag failures instead of silently deleting.
5. Deliver a clean file plus a report. The clean sheet is the product; the one-page PDF report is what gets you rehired.
How I price it
| Job size | Price | Turnaround |
|---|---|---|
| Under 500 rows | $40–$75 | Same day |
| 1,000–5,000 rows | $120–$250 | 1–2 days |
| Recurring monthly batch | $300–$800/mo | Agreed |
The recurring batch is where the real income is.
Where to find clients
- Local small businesses (their customer lists always have duplicates)
- E-commerce sellers (catalog exports get messy fast)
- Marketing agencies (they receive dirty lists constantly)
- Freelance marketplaces ("data cleaning", "spreadsheet cleanup")
FAQ
Do I need to code? No. Under a few thousand rows, a spreadsheet and a checklist get you 90% there.
Is it safe to handle client data? Keep it local. Don't upload customer lists to random web services, and delete files after delivery.
How long does a job take? Under an hour for a file under 1,000 rows. The first job is slowest; the pipeline pays off after that.
Bottom line
Data cleaning is unglamorous, which is exactly why it pays. A free tool stack plus a repeatable pipeline can turn a $40 cleanup into a $500 monthly retainer.
Full workflow with the tool links and the client pitch: https://aixhdd.com/data-cleaning-service-for-clients-workflow/
Top comments (0)