Format 500-Company Contact Database
Budget: €12 – €18 EUR
I have a spreadsheet holding names, emails, phone numbers, and company addresses for 500 firms. Everything is already there and already separated into columns—I simply need it turned into a clean, presentation-ready contact database.
Your task is to:
• open the existing Excel file
• check the four columns (Company Name, Contact Name, Email, Phone, Address) for consistent capitalization, spacing, and obvious typos
• normalise phone numbers to one format and make sure every email cell is recognisable by Excel as an email link
• flag any duplicates you notice so I can decide what to keep
• return the finished workbook in .xlsx
No data scraping or research is required; it is pure formatting and quality control. If you prefer to handle the touch-ups with formulas, Power Query, or a quick VBA routine, that’s fine—as long as the final sheet is tidy, uniform, and ready for import into a CRM.
Your task is to:
• open the existing Excel file
• check the four columns (Company Name, Contact Name, Email, Phone, Address) for consistent capitalization, spacing, and obvious typos
• normalise phone numbers to one format and make sure every email cell is recognisable by Excel as an email link
• flag any duplicates you notice so I can decide what to keep
• return the finished workbook in .xlsx
No data scraping or research is required; it is pure formatting and quality control. If you prefer to handle the touch-ups with formulas, Power Query, or a quick VBA routine, that’s fine—as long as the final sheet is tidy, uniform, and ready for import into a CRM.
Related categories:
Data Processing
Data Entry
Excel
Web Scraping
Microsoft Office
Excel VBA
Excel Macros
Database Management