Update Customer Contacts Between Sheets

via Freelancer ·

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.
visual basic data processing data entry excel data analysis data integration google sheets data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.