I will clean and organize your excel or CSV data

China

I speak Chinese

Architectural Designer

I bring 15 years of professional experience to architectural, scene, and spatial design, supported by 3D modeling, visualization, and presentation production. My core capabilities include architectura...
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