Update Customer Contacts Between Sheets
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted51 minutes ago
I have two spreadsheets that hold overlapping customer records. The master sheet is missing some up-to-date contact details, while a second file contains the correct information. Your task is to take the name, phone number, and email from the second file, match each record to the master sheet by Customer ID / account number, and then overwrite the outdated fields.
You may work in Excel or Google Sheets—whichever you’re most comfortable with—so long as the final deliverable is an updated version of the master file that opens without issues in both environments.
Acceptance criteria:
• All contact fields (name, phone, email) updated wherever a matching Customer ID is found.
• No accidental changes to any other columns or formatting.
• A simple change log (tab or separate file) listing each Customer ID you updated, with old and new values.
• A brief note on any Customer IDs found in one sheet but not the other.
Once everything is confirmed, send back the revised master sheet and the change log. I’ll handle the rest.
You may work in Excel or Google Sheets—whichever you’re most comfortable with—so long as the final deliverable is an updated version of the master file that opens without issues in both environments.
Acceptance criteria:
• All contact fields (name, phone, email) updated wherever a matching Customer ID is found.
• No accidental changes to any other columns or formatting.
• A simple change log (tab or separate file) listing each Customer ID you updated, with old and new values.
• A brief note on any Customer IDs found in one sheet but not the other.
Once everything is confirmed, send back the revised master sheet and the change log. I’ll handle the rest.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.