Excel Data Entry & Cleanup
Budget: ₹750 – ₹1,250 INR
I have several batches of mixed numeric and text information scattered across text files, old e-mails, and a few odds-and-ends formats. My immediate need is straightforward: get every single record entered into a master Excel workbook accurately, then tidy it so the sheet is ready for formulas, filters, and pivot-table analysis.
Here is what the job looks like from my side:
• Consolidate the raw files into one workbook, respecting any original column order that matters and flagging inconsistencies you discover.
• Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers.
• Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later.
I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable.
Deliverables I expect at hand-off:
1. A single, well-structured Excel file containing all entered data.
2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values).
3. The summary/report tab described above.
Accuracy matters more than speed, but I would like the first draft within a week so I can review and give feedback. If this goes smoothly there will be extra datasets waiting.
Here is what the job looks like from my side:
• Consolidate the raw files into one workbook, respecting any original column order that matters and flagging inconsistencies you discover.
• Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers.
• Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later.
I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable.
Deliverables I expect at hand-off:
1. A single, well-structured Excel file containing all entered data.
2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values).
3. The summary/report tab described above.
Accuracy matters more than speed, but I would like the first draft within a week so I can review and give feedback. If this goes smoothly there will be extra datasets waiting.