Contact Data Compilation & Cleanup
Budget: $250 – $750 USD
I need an Excel expert to consolidate and clean up my contact data from various tabs into one comprehensive and well-formatted spreadsheet.
This project involves:
- Compiling around 5,000 names and their associated contact info (email, phone numbers, addresses, comments, etc.) into a single tab.
- Formatting the data with advanced techniques, using custom categories or notes as necessary.
- Adding specific columns to the compiled list, including tags/labels for grouping contacts and the date of last contact.
- Removing exact duplicates, while ensuring that the formatting of the final spreadsheet includes basic elements (name, email, phone, etc.) to intermediate (including comments and addresses) and advanced formatting (with custom categories or notes).
The perfect candidate for this job should have:
- Extensive experience with Excel, particularly in data consolidation and cleanup.
- Strong attention to detail to ensure all data is accurately compiled and formatted.
- Ability to create advanced formatting and custom categories as required.
- Experience in adding specific columns or categories to a dataset.
- Skill in identifying and removing duplicates effectively.
Please note, the final spreadsheet will need to be of a high standard, with no duplicates, and all data accurately captured and well formatted.
This project involves:
- Compiling around 5,000 names and their associated contact info (email, phone numbers, addresses, comments, etc.) into a single tab.
- Formatting the data with advanced techniques, using custom categories or notes as necessary.
- Adding specific columns to the compiled list, including tags/labels for grouping contacts and the date of last contact.
- Removing exact duplicates, while ensuring that the formatting of the final spreadsheet includes basic elements (name, email, phone, etc.) to intermediate (including comments and addresses) and advanced formatting (with custom categories or notes).
The perfect candidate for this job should have:
- Extensive experience with Excel, particularly in data consolidation and cleanup.
- Strong attention to detail to ensure all data is accurately compiled and formatted.
- Ability to create advanced formatting and custom categories as required.
- Experience in adding specific columns or categories to a dataset.
- Skill in identifying and removing duplicates effectively.
Please note, the final spreadsheet will need to be of a high standard, with no duplicates, and all data accurately captured and well formatted.