I will clean format and deduplicate your CSV or excel data
About this Gig
Clean CSV or Excel data with clear rules and a reusable Python script.
I remove exact duplicates, trim whitespace, standardize dates and text, and split or combine columns according to your instructions. One item means one data row; row limits are the total across all files. Each file may contain up to 10 columns.
Basic: 1 file, 100 rows, 3 rules, 1-day delivery.
Standard: up to 3 files, 5000 total rows, 5 rules, 2-day delivery.
Premium: up to 5 files, 10000 total rows, 10 rules, 3-day delivery, plus a validation report.
Every package includes cleaned files, a reusable Python script and a change summary. Original files are preserved. Revisions correct the agreed rules; new files or rules need a separate scope.
Share an anonymized sample, cleanup rules and desired output. Missing values are handled only as you instruct. Fuzzy matching, manual research, complex formulas and workbook redesign require a custom quote. I communicate in writing and check the output before delivery.
FAQ
Will you modify my original file?
I return a separate cleaned copy so your original remains intact. I also include a short change summary.
Can you clean larger files or automate future updates?
Yes. All packages include a reusable Python script. Standard covers 5000 total rows; Premium covers 10000. Larger files, fuzzy matching or complex rules need a custom quote after reviewing an anonymized sample.
