I will clean and validate CSV data with an audit and exception report
About this Gig
Need a CSV cleaned without losing track of what changed?
I will process one CSV with up to 100 data rows and 10 columns using up to 5 agreed rules. Examples include trimming spaces, standardizing date or number formats, identifying exact duplicates, and checking required values.
You receive:
- Cleaned CSV with accepted records
- Separate duplicate and exception lists
- A change log and summary reconciling input and output counts
Ambiguous dates, conflicting IDs, and missing facts are flagged for your decision. Original source values are preserved in the audit. No invented corrections.
Please share a small anonymized sample, the column meanings, and your desired rules before ordering. One revision covers corrections to the agreed rules and original data; new files or new rules need a separate quote.
This package covers a one-time CSV cleanup. It excludes XLSX formatting, PDF/OCR, web scraping, account login, fuzzy matching, and financial advice. A reusable Python script or larger dataset can be quoted separately.
FAQ
How do you handle duplicates and unclear data?
Duplicate rules are agreed before work starts. Exact matches are reported separately. Conflicting records, ambiguous dates, and missing facts are flagged for your review instead of guessed or silently deleted. Original values remain in the audit log.
