Transfer Customer Contacts into Sheets

$15-25 USD / hour

Posted 1 minute ago

•

Ends in 6 days

$15-25 USD / hour

I have a collection of customer contact files—some in Excel, others in CSV, and a few scattered Google Sheets—that all need to be merged into one clean, well-formatted Google Sheet. Your task is straightforward: open each source file, copy or import every record, and make sure the details line up consistently across the new sheet. The core fields I must see are the customer’s name, phone number, and email address; if you notice extra columns that repeat across the files, feel free to include them as optional columns after checking with me. Accuracy matters more than speed. I’ll share the files through Google Drive, and you can work directly in a shared Sheet so we both see progress in real time. A quick daily note on what you completed is all the status reporting I need. Deliverables • One Google Sheet containing every imported contact, with no duplicates • Uniform formatting for names (First Last), phone numbers (international format), and email addresses (lowercase, no spaces) • A short “Import Log” tab that lists each source file and the row count you added from it Once the final sheet passes a quick spot-check for consistency and completeness, I’ll mark the project complete and release payment.

Project ID: 40821462

About the project

17 proposals

Open for bidding

Remote project

Active 6 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

17 freelancers are bidding on average $18 USD/hour for this job

User Avatar
Flag of TURKEY

Hi there, I see you're looking to consolidate various customer contact files into one well-organized Google Sheet. I have extensive experience with Google Sheets and data processing, which makes me well-prepared to handle the tasks you've outlined. I'll ensure every record is accurately imported, formatted uniformly for names, phone numbers, and emails as specified. Additionally, I will create an 'Import Log' to track the row counts from each source file for your review. I appreciate that accuracy is paramount, and I will provide daily updates to keep you informed of my progress while working directly in the shared Sheet. Please let me know if you have any specific preferences for the optional columns that may be included. Regards, Ali

User Avatar
Flag of PAKISTAN

Hi, I can merge your Excel, CSV and Google Sheets files into one clean Google Sheet with no duplicates and an Import Log tab. I'll open each source file from the shared Drive folder, map name, phone and email into uniform columns (First Last, international format, lowercase), and flag any extra repeated fields before adding them. The Import Log tab will list each file and its row count as I go. My profile for reference: https://www.freelancer.com/u/wasimameen Roughly how many source files and total contact records are we working with? Wasim Ameen

User Avatar
Flag of BRAZIL

Hello, merging Excel, CSV, and Google Sheets contacts into one accurate, duplicate free customer list is exactly the kind of cleanup where consistency matters more than rushing. I understand the real challenge is not simply copying rows. Names, international phone numbers, lowercase emails, repeated columns, and duplicate records must all be standardized without losing source traceability. I can use Excel for structured cleanup and Data Processing methods to normalize fields, compare records, identify duplicates, and preserve the required name, phone, and email columns. I will also maintain an Import Log with each source filename and the number of rows added, so every result is easy to verify. Data Entry will be handled carefully with spot checks for incomplete or conflicting contact details. Web Scraping is not required for this workflow, but my related data handling skills support reliable consolidation across varied file formats. I will keep the shared sheet organized and provide the requested daily progress note. Once the files are available, I can begin with a small sample import so the formatting rules are confirmed before processing everything. Gabriel

User Avatar
Flag of UKRAINE

Hello, I understand you need all contact files merged into one clean, consistent Google Sheet with duplicates removed and an import log added. I’m confident I can handle this carefully and accurately. With experience in data management, Web Scraping, and Google Sheets workflows, I can make sure the records are organized properly and easy to review. I’d approach it like this: • Review each Excel, CSV, and Google Sheets source • Merge everything into one shared sheet • Standardize names, phone numbers, and emails • Remove duplicates and check for missing or inconsistent values • Add an Import Log tab with source file names and row counts If you have any specific rules for duplicate handling or optional columns, please share them so I can match your preferences exactly. I can also work directly in the shared Google Sheet and provide daily updates as requested. I’m ready to start and keep the process clear, accurate, and easy to track. Best regards, Ruslan

User Avatar
Flag of UKRAINE

Hi there, Could you share whether any files contain merged cells, hidden rows, or mixed phone formats that need manual cleanup? Also, should duplicate contacts be removed by exact match only, or merged when name and email are close but not identical? The main task is to normalize several source files into one clean Google Sheet without losing records. A careful import process, then validation of names, phone numbers, and emails, will keep the final sheet consistent and easy to review. The biggest risk is duplicate or conflicting contact data across Excel, CSV, and Sheets. I would handle that by checking each source against a consistent set of rules, logging every import, and flagging edge cases before finalizing them. Daily updates can be kept short and clear while the sheet is updated in shared access, so progress stays visible in real time. Before handoff, I would do a spot-check for formatting, row counts, and missing fields to make sure the sheet is complete. Best, Hlib

User Avatar
Flag of INDONESIA

pulling all those scattered excel, csv and google sheet contacts into one clean sheet is work i'm happy to take on i can do this for you, and i'll go slow and careful since you said accuracy matters more than speed i'll stay on it until the sheet looks right to you roughly how many contacts are we talking about across all the files? happy to chat more whenever suits you Sela

User Avatar
Flag of PAKISTAN

Merging scattered sources is where duplicates and mismatched formats creep in, so I'd import every record, standardise names, phones and emails as you specified, and keep an Import Log tab showing row counts per source file. Accuracy over speed, with a quick daily note on progress. Regards, Muhammad Taha

User Avatar
Flag of PAKISTAN

Hello, Accurate data entry and database management are the core skills I can apply to consolidate your Excel, CSV, and Google Sheets contact files into one reliable master sheet. I can carefully transfer every record, align names, phone numbers, and email addresses consistently, and keep the final data organized for easy use. My database management experience is well suited to checking for duplicate contacts, maintaining consistent fields, and preparing the requested Import Log with each source file and its imported row count. I can also use my web scraping and data-handling background to work methodically through multiple source formats while prioritizing completeness and accuracy over speed. I’m ready to manage this contact consolidation carefully and deliver a clean, well-formatted Google Sheet with clear progress updates. Choose me to keep your customer data organized and dependable. Thanks!

User Avatar
Flag of PAKISTAN

Hi, Roughly how many contacts and files are involved, and which country format should the phone numbers follow? I’d merge everything into one clean Google Sheet with no duplicates, standardised names, phones and emails, and an import log showing the row count from each file. https://www.freelancer.com/u/alyan056 Alyan

User Avatar
Flag of UNITED STATES

Hello, The main challenge when combining customer contacts from multiple Excel, CSV, and Google Sheets files is ensuring that every record is preserved while identifying duplicates and inconsistent formatting. A single customer appearing under slightly different names or phone formats can easily lead to duplicate entries or missing information. I'd consolidate all your source files into one shared Google Sheet, standardizing names, converting phone numbers to international format, and normalizing email addresses to lowercase without spaces. I'll also carefully compare records before removing duplicates so that different customers are never accidentally merged. I'll preserve useful additional fields where appropriate and organize everything into a consistent structure that's easy to search, filter, and maintain. You'll also receive an Import Log tab showing each source file and the number of records added, making the entire process transparent and easy to verify. I'll provide brief daily progress updates as requested. Best regards, Victor

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅