I will clean and organize your excel or CSV data
About this Gig
I will clean 1 Excel or CSV file, 1 worksheet, up to 3,000 rows x 20 columns for $15, with 2-day delivery and 1 revision within the agreed scope.
Cleanup includes removing extra spaces, standardizing text/date/number formats, removing duplicates using your confirmed keys and retention rules, flagging missing values and conflicts, and preserving leading zeros in IDs/codes. No manual data completion, research or invented values.
You may also choose up to 3 simple formulas OR 1 simple VBA macro that works only in the current workbook. No internet access, external-file operations or complex system integrations.
Please supply the source file, column meanings, cleanup rules, desired formula/macro behavior and example inputs/outputs. State your Excel version and Windows or Mac. CSV cannot retain formulas or VBA macros; these are delivered in an agreed Excel format. Compatibility is confirmed only for the version/platform actually tested.
Keep your original backup. Delivery includes the cleaned file and a brief summary of changes and unresolved issues. The revision covers the same file, worksheet and agreed rules. Discuss scope changes before ordering.
Platform:
Excel
Development technology:
VBA
Expertise:
Formatting
•
Formulas
•
Macros
•
Cleaning
FAQ
What formulas or VBA macros are included?
Choose up to 3 simple formulas OR 1 simple VBA macro, limited to the current workbook. Please describe the intended result with sample inputs and outputs. Internet access, external-file operations and complex system integrations are excluded.
Which Excel versions and file formats do you support?
Tell me your Excel version and whether you use Windows or Mac. CSV cannot retain formulas or VBA. We will agree a suitable format: .xlsx for formulas or .xlsm for VBA. Compatibility is confirmed only for the version/platform actually tested; untested cross-platform compatibility is not promised.

