I will clean messy csv and excel data
About this Gig
You send a messy CSV or Excel file. You get back a clean table, a conflicts sheet, and a validation report you can check.
What I clean:
- Duplicates: the same order/ID appearing more than once
- Dates written in several different formats
- Numbers with mixed units (yuan vs thousand yuan, commas, spaces)
- Text with emojis, full-width spaces, inconsistent case
- Columns that need merging or splitting
How I work:
1. You send a sample (20-50 rows).
2. I write the rules down and send them to you for confirmation.
3. I run the cleaning script and send back three files: the clean data, a conflicts sheet (anything I refused to guess), and a validation report (rows before/after, what changed, checks passed).
What I do not do:
- I do not guess values. If a rule is ambiguous, it goes into the conflicts sheet.
- I do not modify your original file; you get a new one.
Deliverable: .xlsx or .csv + a short report (PDF or Markdown).
