Update Customer Contacts in Sheets
Budget: ₹100 – ₹400 INR
I have a master Google Sheet that stores all of our customer contact details. I’ll supply a fresh CSV that contains the latest email addresses, phone numbers, and physical addresses for many of those records.
Your job is to load the CSV, match each row to the correct customer in the Sheet (the unique key is the customer-ID column already present), and overwrite the three fields—email, phone, and address—where changes exist while leaving all other columns untouched.
Please keep formulas and data validation rules intact, and make sure there are no duplicate rows once the import is complete. Accuracy is essential; a quick spot-check on at least 20 random records after the update will be part of acceptance.
When you’re done, share the updated Sheet link and a brief change log (just the customer-ID and the fields you modified) so I can review before closing the project.
Your job is to load the CSV, match each row to the correct customer in the Sheet (the unique key is the customer-ID column already present), and overwrite the three fields—email, phone, and address—where changes exist while leaving all other columns untouched.
Please keep formulas and data validation rules intact, and make sure there are no duplicate rows once the import is complete. Accuracy is essential; a quick spot-check on at least 20 random records after the update will be part of acceptance.
When you’re done, share the updated Sheet link and a brief change log (just the customer-ID and the fields you modified) so I can review before closing the project.
Related categories:
Visual Basic
Data Processing
Excel
Data Analysis
Google Sheets
Database Management
Data Management