Excel Expert Needed for Bulk Data Processing, Formatting, and Cleanup

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have several very large spreadsheets that need to be audited, cleaned, and uniformly formatted. The job revolves around identifying and fixing discrepancies quickly while keeping every entry accurate. You’ll be diving into thousands of rows, using VLOOKUP, XLOOKUP, and any other advanced functions you find useful to reconcile records, highlight mismatches, and verify totals.

I care a lot about proper formatting—leading zeros must stay intact, text-to-number issues have to be resolved, and custom field structures need to remain consistent from sheet to sheet. Throughout the process I expect frequent spot-checks to confirm that formulas are returning the correct values and that no data has been lost or overwritten.

Deliverables:
• One consolidated, fully audited workbook (or the same number of source files if you prefer) with clean, consistently formatted data.
• A short changelog or summary that explains what was fixed, the formulas employed, and any remaining anomalies I should be aware of.

If you’re quick with large datasets, meticulous about accuracy, and comfortable leveraging Excel’s full toolbox to track down errors, this project should be straightforward.
visual basic data processing excel excel vba excel macros data analysis data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.