I will clean and deduplicate CSV data with a clear change log
About this Gig
I will clean one UTF-8, comma-delimited CSV and provide a clear audit trail.
Packages:
Basic: 100 data rows / 15 columns, 2 days.
Standard: 5,000 data rows / 25 columns, 3 days.
Premium: 10,000 data rows / 40 columns, 4 days.
Each includes one revision within the original file and agreed rules.
Included: trim outer whitespace, deduplicate by an agreed key (keep first), flag missing required fields and reconcile counts. Text identifiers retain leading zeros in the CSV; import those columns as text in Excel.
Deliverables: cleaned CSV, row-level change log, issue report and rule sheet. Formula-like values receive a protective apostrophe, recorded in the log. Blank keys remain for review; conflicting values are not guessed or merged.
Message me with a redacted sample before ordering. I use AI-assisted workflows with programmatic checks; external AI processing of client data requires agreement. Portfolio samples are synthetic.
XLSX, macros, enrichment and integrations are outside scope. Please omit sensitive data and credentials. Communication and delivery stay on Fiverr.
FAQ
Can I send an Excel workbook?
Please export one sheet as a UTF-8, comma-delimited CSV. Workbook formatting, formulas and macros are outside scope. Import identifier columns as text in Excel to preserve leading zeros.
How will duplicates and missing values be handled?
I use the agreed key, keep the first matching record and log removed duplicates. Blank keys stay for review. Missing required values are reported; I do not guess replacements or merge conflicting records.
What does one revision cover?
One correction using the original file and agreed rules. New files, extra rows, joins or new rules require a separately agreed scope. Please message me with a redacted sample before ordering.
