
Completed
Posted
Paid on delivery
I’m maintaining three separate Excel files that store customer data. None of them currently contain email addresses or phone numbers. I also have a master Google Sheet—kept in native Google Sheets format—that does include those missing contact fields. Here’s what I need done: • For every row in each Excel file, match against the Google Sheet on first name, last name, middle initial, and date of registration. • When a match is found, pull across any email and/or phone number that exists in the Google Sheet and append it to the corresponding row in the same Excel file. • The three Excel files must remain completely independent; do not merge them into one workbook. • If the Google Sheet holds multiple identical matches, keep the existing row intact and simply enrich it with the extra contact details—no overwriting of other fields. • All other data in the Excel files must stay exactly as-is. Acceptable approaches include Power Query, VBA, Apps Script, or another repeatable method—whichever you prefer, so long as I receive: 1. The three updated Excel files with the new contact columns populated. 2. A brief note or script that allows me to rerun the sync in the future if needed. Accuracy is vital; a quick cross-check report of records that could not be matched would be appreciated.
Project ID: 40494122
50 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I can handle this data enrichment task accurately while keeping all three Excel files completely separate and unchanged except for the addition of the new contact columns. I have experience working with Excel, Google Sheets, Power Query, VBA, and data matching workflows involving multiple identifiers and duplicate handling. My approach would be to create a repeatable matching process using first name, last name, middle initial, and registration date to reliably identify records between the Excel files and your master Google Sheet. When matches are found, I’ll append the available email addresses and phone numbers into new columns without modifying or overwriting any existing data. If duplicate matches exist in the source sheet, the original row structure will remain intact exactly as requested. I will also provide: • The three updated Excel files • A reusable script/process note so you can rerun the sync later • A separate unmatched/cross-check report for records that could not be confidently matched Accuracy and data integrity will be my priority throughout the process. Ready to start as soon as you share the files and sheet structure.
$75 USD in 7 days
3.3
3.3
50 freelancers are bidding on average $104 USD for this job

HI there already i have checked project details job is clear so please contact me then i will show you sample, thank you
$50 USD in 1 day
8.7
8.7

Hello there, I am experienced in web scraping and building scripts or a Windows desktop application using Python. I am also experienced in large data scraping from a given website, bypassing IP, Captcha, and anti-bot or cloud flair protection. Please message me to discuss this project in detail. Best Regards Enamul
$50 USD in 2 days
8.2
8.2

Having spent several years in the data analysis space, this project aligns perfectly with my analytical skills, specifically data entry and processing. With an extensive background in utilizing Excel and Google Sheets for various data-focused tasks, I am very comfortable handling the complexity of your request. My mastery of advanced Excel functions like Power Query and VBA, as well as experience in Apps Script, gives me the flexibility to offer you the most efficient solution tailored to your needs. In terms of your main requirement, I'm well versed in merging and syncing data from various sources using multiple matching criteria - precisely what you need for this task. I can assure you that your three Excel files can stay separate while still being linked reliably to the master Google Sheet. Additionally, I understand the value of holding onto the original data integrity in such projects. You can trust me to handle your contact records with precision and care. And for future use with no reliance on external help, I’ll create a simple script that lets you rerun this sync whenever necessary. Ultimately, my primary focus is exceeding your expectations by delivering accurate results and building long-lasting client relationships.
$250 USD in 1 day
7.7
7.7

Hi, I can help enrich your three Excel files by matching records against your Google Sheet and appending the available email and phone information while preserving all existing data exactly as it is. With 10+ years of experience in Excel, Google Sheets, data matching, Power Query, VBA automation, and data migration projects, I have completed numerous similar record-enrichment tasks in which accuracy and data integrity were critical. For this project, I will: • Match records using: * First Name * Last Name * Middle Initial * Date of Registration • Pull available: * Email Address * Phone Number Deliverables will include: • Three updated Excel files with populated contact columns • A summary report showing: My approach prioritizes accuracy and traceability, ensuring that every enrichment is based on the matching criteria you specified and that the integrity of your original datasets is maintained. I am available to start immediately and would be happy to review sample files before beginning. Looking forward to working with you. Best regards, Ujjwal
$70 USD in 1 day
7.6
7.6

Hello, I have thoroughly reviewed the project requirements and understand the need to sync contact details from a master Google Sheet to three separate Excel files based on specific matching criteria. Let's chat and discuss it further. To handle your project, I will start with creating a VBA script that will automate the process of matching and updating contact details in the Excel files based on the specified criteria. By utilizing VBA, I can ensure a seamless and efficient synchronization process while maintaining the independence of the three Excel files. The deliverables for this project will include the three updated Excel files with the new contact columns populated and a reusable VBA script for future syncs. Before signing-off my bid, I would like to ask a question, i.e., would you like to receive a detailed report of records that could not be matched during the synchronization process? Best Regards, Aneesa.
$100 USD in 1 day
7.0
7.0

With my over 16 years of experience in data analysis, I am more than equipped to handle your project proficiently and accurately. My expertise in Excel and Google Sheets allows me to implement efficient solutions using Power Query, VBA, or Apps Script tailored to your specific needs - in this case, syncing your contacts across the different platforms without compromising any existing data. I have a strong grasp on automating manual work, be it through Macros or Google Apps Scripting - which lends itself perfectly to your project requirements. Additionally, I prioritize data integrity and understand the importance of accurate reporting. With every sync operation, I will provide a cross-check report of records that could not be matched, so you have complete visibility of any inconsistencies. Beyond this project, I am well-versed in many aspects of Microsoft Office suite beyond Excel like Microsoft Word and Access - rounding out my data management capabilities. Furthermore, my proficiency in Processing, Analysis, and even PDF solutions adds another dimension of potential value to our partnership. My goal is not just to complete this job satisfactorily but also to improve your workflows and ultimately enhance your business as a whole. Let's chat and make that happen!
$50 USD in 1 day
6.8
6.8

Hi, I can accurately match the records from your three Excel files against the Google Sheet using first name, last name, middle initial, and registration date, then populate the available email and phone fields while preserving all existing data. You will receive the three updated Excel files, a list of unmatched records for review, and a reusable script or process so the synchronization can be run again in the future. Best regards, Md Shamim
$30 USD in 1 day
5.7
5.7

Hi there, ★★★ Excel Expert ★★★ 6+ Years of Experience ★★★ I can update your Excel files with the missing contact details from your Google Sheet by matching the specified fields. This will include: - Matching rows based on first name, last name, middle initial, and date of registration. - Pulling email and phone numbers from the Google Sheet into the corresponding Excel files. - Ensuring that all other data remains unchanged. - Providing a brief note or script for future syncs. I will use a structured approach with Excel formulas or VBA to ensure accuracy and efficiency. Ready to start once you provide access to the Excel files and the Google Sheet. Thanks!
$130 USD in 2 days
5.8
5.8

✅ Hello, I’m Naresh. With extensive experience in Excel, Google Sheets, Power Query, VBA automation, and data reconciliation, I can accurately enrich your three Excel files with email addresses and phone numbers from the master Google Sheet while preserving the integrity of all existing data. ➡️ I can deliver: ✔ Accurate matching using First Name, Last Name, Middle Initial, and Registration Date ✔ Population of available email and phone fields without modifying any existing data ✔ Three independent updated Excel files (no workbook consolidation) ✔ Handling of duplicate matches according to your requirements ✔ Validation checks to minimize false matches and data inconsistencies ✔ A reconciliation report identifying unmatched records and any ambiguous matches requiring review ✔ A repeatable solution (Power Query, VBA, or documented process) so future synchronizations can be performed easily ✔ Clean documentation explaining the matching logic and refresh process My focus will be on accuracy, auditability, and maintaining the original structure of your files while ensuring the highest possible match rate. Please open the chat for further discussion. Thanks & regards, Naresh
$200 USD in 1 day
5.5
5.5

Hi, I can update all three Excel files by matching records against your Google Sheet and enriching them with the available email addresses and phone numbers while preserving the original data structure. Thanks
$30 USD in 1 day
4.8
4.8

Hello, I can help you accurately sync your three Excel files with the master Google Sheet while keeping each workbook completely independent and preserving all existing data. I will create a reliable matching process based on first name, last name, middle initial, and date of registration. When a match is found, the corresponding email and phone number will be appended to the correct row without overwriting any other fields. To ensure the process is repeatable, I can implement this using Power Query or a structured script-based method so you can easily rerun the sync in the future. I will also provide a brief instruction note explaining how to refresh the data. In addition, I will generate a cross-check report listing any records that could not be matched, so you have full visibility and confidence in the results. Accuracy and data integrity will be my top priorities throughout the process. I’m ready to review the files and begin right away.
$99 USD in 2 days
5.0
5.0

I have carefully read your job description and understand you Need a Sync Contacts Across Sheets I have done many projects previously, you will never lose the deadline and we will never disagree about money at all. By hiring me, you will have a quick response, high quality, and great communication.
$70 USD in 1 day
5.0
5.0

Hello, I hope you're doing well. After carefully reviewing your requirements, I'm confident in my ability to meet them with the utmost accuracy in the shortest time possible as I have worked on similar projects where I delivered 100% quality. Chat me up let us discuss your project in detail and get started right away. Thank you.
$30 USD in 1 day
5.0
5.0

Hi, I can complete this accurately. I'll match records using first name, last name, middle initial, and registration date, then populate email and phone fields while keeping all three Excel files separate. I'll also provide a rerunnable script/process and a report of unmatched records. Looking forward to discussing the details.
$100 USD in 3 days
4.9
4.9

Hi there, With M Mobasher from the expert team at Aesthetic Logic, this project will get nothing less than superior, precise results. Even though my profile highlights a broad range of skills and experiences in different fields from design to blockchain development, data work is also at the core of what I do day in, day out. I've spent considerable time working with data, analyzing, processing, and delivering accurate results - some on large-scale systems for multinational companies. For your specific project, my expertise in Data Analysis, Data Entry, Data Processing and Excel are particularly valuable. Whether it's using Power Query or VBA, I'm experienced and comfortable with various approaches that could get the job done seamlessly. Additionally, having worked extensively with Google Sheets native format and being fluent in Apps Script make me suited for providing a solution script that will allow you to rerun the sync as needed. My commitment to accuracy is unwavering, so you can fully trust me to preserve your data integrity throughout the process.
$140 USD in 3 days
4.4
4.4

Good to see this project, We will match each row across your three Excel files to the master Google Sheet using first name, last name, middle initial, and date of registration, then populate email and phone columns accordingly. Our approach: a Python script that handles fuzzy edge cases (extra spaces, date format mismatches) and outputs an unmatched records report for review. A couple of quick things to confirm: 1) Are the column headers consistent across all three Excel files? 2) Should the rerunnable script connect to Google Sheets via API or work from a downloaded CSV? The number quoted here is a starting estimate. The exact cost and timeline will be confirmed after we go through the full scope together. Looking forward to talking through the details. Faizan
$90 USD in 5 days
3.7
3.7

Hi, I can enrich your three separate Excel files by matching each row against the master Google Sheet using first name, last name, middle initial, and date of registration, then appending the email and phone fields without changing any existing data. I have done similar spreadsheet cleanup and customer data sync projects using Excel, Google Sheets, Power Query, VBA, and Apps Script, including fuzzy checks, duplicate handling, unmatched record reports, and repeatable sync scripts. For this project, I would keep all three Excel files independent, add the required contact columns, preserve the original formatting and data, and provide a simple rerun method so the same process can be repeated later. I will also include a cross check report showing matched, unmatched, and duplicate match records for review. Best regards, George
$100 USD in 7 days
3.6
3.6

Hello, As a result of a detailed review of your project requirements, I fully understand you need a reliable data-matching workflow to enrich three separate Excel files using a master Google Sheet, while preserving file independence and ensuring zero data loss or overwriting. I have strong experience working with Excel automation, Google Sheets integration, and structured data reconciliation using Power Query, VBA, and Google Apps Script for repeatable, audit-safe workflows. I bring expertise in Excel, Google Sheets, Data Processing, Data Integration, VBA, Data Analysis, and Data Management automation. For this project, I will implement a matching system based on first name, last name, middle initial, and registration date, ensuring precise row-level matching. The solution will safely append email and phone data from your Google Sheet without altering any existing fields. I have a couple of quick questions: • Is the registration date format consistent across all files (e.g., YYYY-MM-DD), or does it vary between sources? • Would you prefer a fully automated refresh button inside Excel, or a script-based approach you can run manually when needed? I would be glad to discuss further details and I am ready to start immediately. Best regards, Carlos
$30 USD in 3 days
3.8
3.8

Hello, I’ve reviewed your requirements and understand you need a precise cross-file matching process between three Excel workbooks and a master Google Sheet to enrich customer records with email and phone data. I can match your 3 Excel files with your Google Sheet using name + registration date and append only email and phone without changing any existing data. All files will stay separate, and I’ll also provide a reusable method (Power Query or script) plus a list of unmatched records for verification. Best Regards, Noor Fatima
$30 USD in 1 day
3.7
3.7

Hi! I would love to help out with this Excel project. I am detail oriented and have completed similar projects before. Please feel free to reach out if you would like to discuss any additional requirements.
$80 USD in 1 day
3.4
3.4

St. Thomas, Virgin Islands, U.S.
Payment method verified
Member since Mar 19, 2015
$10 USD
$10 USD
$30-250 USD
$10-30 USD
$15-25 USD / hour
₹12500-37500 INR
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
$30-250 USD
₹12500-37500 INR
$250-750 USD
₹100-400 INR / hour
₹12500-37500 INR
€12-18 EUR / hour
$250-750 USD
$15-25 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹1500-12500 INR
₹1500-12500 INR
$30-250 USD
$5000-10000 USD
₹1500-12500 INR