I will clean and standardize your excel or CSV data
Excel and CSV Cleanup, Simple Websites
About this Gig
I will clean one Excel (.xlsx) or CSV sheet using agreed rules.
Each package covers 1 sheet and up to 10 columns. Limits count input data rows before cleaning; the header is excluded.
Basic: up to 100 rows, exact duplicate removal and trimming unwanted spaces in agreed text columns.
Standard: up to 300 rows, plus agreed date, text and number standardization.
Premium: up to 500 rows, plus before/after counts and a separate anomaly list.
Exact duplicates are rows identical across all original columns. I keep the first copy and remove later copies before standardization. Suspected duplicates created by standardization are retained and flagged for your confirmation.
Missing, invalid or ambiguous values are kept and flagged, never guessed or filled. Your source file remains unchanged. Each order includes a cleaned file and a short change note.
Delivery: Basic 3 days, Standard 4 days, Premium 5 days. Each includes 1 revision within the agreed scope.
Not included: complex formulas, macros, scraping, manual research, missing data recovery or data splitting.
Please message me with an anonymized sample and your rules before ordering.
My Portfolio
FAQ
How are rows and items counted?
For this Gig, 1 item means 1 input data row. The header is excluded. Limits apply before cleaning, including duplicate and incomplete records. Each package covers 1 sheet and up to 10 columns.
What counts as an exact duplicate?
All original column values must match. I keep the first copy and remove later copies before standardization. Key-based or fuzzy matching is not included. Duplicates that appear only after standardization are retained and flagged for confirmation.
What text cleanup does Basic include?
Basic removes exact duplicate rows and trims unwanted leading and trailing spaces in agreed text columns only. It does not convert dates, number formats or text case. Standard and Premium add these changes only under agreed rules.
How do you handle missing or ambiguous values?
I leave them unchanged and flag them. I do not delete rows simply because they have missing or abnormal values, invent replacements or guess ambiguous dates. Premium includes a separate anomaly list; all packages flag unresolved issues.
Which files can I send?
Send one .xlsx or .csv file containing a plain data table and specify the sheet. These packages do not cover macros, complex formulas, charts or preserving an existing workbook layout. Please ask first about other file types.
Will IDs and leading zeros be preserved?
Tell me which columns contain IDs, account codes or ZIP codes. I preserve existing text identifiers and leading zeros in the delivered file. Zeros already lost in your source cannot be reliably recovered. Import CSV identifier columns as text when opening in Excel.
What will I receive?
All packages include the cleaned file in one agreed format, XLSX or CSV, and a short change note. Premium also includes before/after row counts, exact duplicate removal counts and a separate anomaly list with source-row references.
What does one revision cover?
One revision applies to the original file and agreed rules. New data, extra sheets, more rows or new rules need a separate scope agreement. No unlimited revisions or rush delivery. Errors in applying the agreed rules are corrected free of charge and do not count toward the included revision.
Can you split data or recover missing information?
Data splitting and missing data recovery are not included. These packages also exclude complex formulas, macros, web scraping and manual research. Please send an anonymized sample before ordering so I can confirm the fit.
Do you use AI tools?
Yes. I use AI assistance to write and maintain the scripts that apply the agreed cleaning rules, and I check the results before delivery. Please tell me before ordering if you have restrictions on AI tools.
