Excel Text Data Cleaner Needed
Budget: ₹100 – ₹400 INR
I have a text-heavy Excel workbook that must be cleaned before it feeds our reporting dashboards. Your job is to open the file, remove every duplicate entry, fix obvious data-entry mistakes (misspellings, shifted columns, stray characters), and bring all fields into a consistent format so downstream formulas run without errors.
The sheet is entirely text, so attention to case, spacing, and hidden non-printable characters is critical. When you finish, I expect:
• A pristine, duplicate-free workbook ready for import
• A short change log noting the main error patterns you fixed and any rows you flagged for my review
If you prefer Power Query, VBA, or reliable add-ins, feel free—just keep the final file in .xlsx with no macros left behind. This batch is around 20,000 rows; once we’re happy with the results, similar files will follow.
The sheet is entirely text, so attention to case, spacing, and hidden non-printable characters is critical. When you finish, I expect:
• A pristine, duplicate-free workbook ready for import
• A short change log noting the main error patterns you fixed and any rows you flagged for my review
If you prefer Power Query, VBA, or reliable add-ins, feel free—just keep the final file in .xlsx with no macros left behind. This batch is around 20,000 rows; once we’re happy with the results, similar files will follow.
Related categories:
Data Processing
Data Entry
Excel
Virtual Assistant
Excel VBA
Excel Macros
Data Analysis
Data Management