I will clean and standardize your excel or CSV data using clear rules
About this Gig
Turn messy Excel or CSV data into consistent, usable files using clear, agreed cleanup rules.
I can trim spaces, standardize text and date formats, rename columns, remove exact duplicates using agreed keys, and flag missing or invalid values.
For this Gig, one item means one INPUT data row, excluding the header. Limits apply across all files combined, before any rows are removed. Each file must contain one flat data table with up to 25 columns.
Basic: 100 rows, 1 file and 2 rules.
Standard: 2,500 rows, 1 file and 4 rules, plus validation and exceptions reports.
Premium: 10,000 total rows, up to 3 files and 6 rules, plus reports, a reusable Python script and run instructions.
All packages include cleaned output, a change summary and one in-scope revision. Original files stay unchanged.
No fuzzy matching, manual research, enrichment, macros, dashboards or repair of formulas and complex formatting.
Send an anonymized sample before ordering so we can confirm the scope and delivery. Larger or different jobs can be quoted separately.
FAQ
What counts as one item and one rule?
One item is one input data row, excluding the header, counted across all files before cleanup or duplicate removal. One rule is one agreed transformation or validation with defined columns and expected results.
What is included in the reusable script?
Premium includes a Python script and run instructions for repeating the agreed cleanup on the same input structure. You need an environment that can run Python. New columns, layouts or rules may require a separate update. Formulas, macros and complex workbook formatting are outside scope.
What does a revision cover, and can you handle larger jobs?
One consolidated list of adjustments within the agreed rules and dataset scope. Corrections needed to meet the agreed scope are included. New files, rules or larger datasets need a separate quote. Send an anonymized sample before ordering for work outside the packages.
