Consolidate 24k Company Excel Records
Budget: $250 – $750 CAD
I have roughly 24,000 company entries scattered through several Excel workbooks my five team members created over time. While many fields line up, some files introduce extra or reordered columns, so the structure is a mix of consistent and inconsistent layouts. I need one clean, well-structured master sheet that lists every company once, sorted and de-duplicated, with these columns only: Company Name, Address, Phone Number, Email, and Person of Contact.
You may rely on Excel, Power Query, VBA, or a quick Python script—whatever speeds things up without sacrificing accuracy—but the final deliverable must be a single Excel file ready for day-to-day use.
Key points I will check before approving:
• All 24,000+ rows accounted for with no duplicates.
• Uniform formatting for phone numbers and emails.
• Blank or ambiguous entries flagged in a separate tab so I can review them quickly.
• Columns appear in the exact order specified.
Let me know how long you’d need and any questions about the source files so we can get started right away.
You may rely on Excel, Power Query, VBA, or a quick Python script—whatever speeds things up without sacrificing accuracy—but the final deliverable must be a single Excel file ready for day-to-day use.
Key points I will check before approving:
• All 24,000+ rows accounted for with no duplicates.
• Uniform formatting for phone numbers and emails.
• Blank or ambiguous entries flagged in a separate tab so I can review them quickly.
• Columns appear in the exact order specified.
Let me know how long you’d need and any questions about the source files so we can get started right away.
Related categories:
Python
Data Processing
Data Entry
Excel
Data Cleansing
Data Analysis
Data Integration
Data Management