Excel Contact Entry & Merge
$8-15 USD / hour
Posted 1 minute ago
•
Ends in 6 days
$8-15 USD / hour
I need help turning a stack of customer details—currently scattered across emails, attached PDFs, and the occasional scanned document—into a clean, reliable Excel file. For every contact you locate, capture only the name, email address, and phone number; no extra fields are required. Where things get interesting is duplicate handling: if two records share the same name or phone number, treat them as the same person and merge their information so the finished sheet shows just one consolidated row. If you come across an edge case that could be interpreted two ways, flag it in a separate tab and we can review together. Accuracy is everything here, so I’m counting on sharp data-entry skills, solid attention to detail, and a workflow that might include tools like Excel, Google Sheets, Adobe Acrobat, or any OCR utility that helps pull text cleanly from PDFs and scans. Deliverable: one Excel workbook containing • a master sheet with unique, merged contacts (Name | Email | Phone) • an optional “review” sheet for any records you felt unsure about If this sounds straightforward to you and you have experience extracting data from mixed digital sources while keeping an eye on duplicates, let’s get started.
Project ID: 40829776
About the project
5 proposals
Open for bidding
Remote project
Active 15 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
5 freelancers are bidding on average $12 USD/hour for this job


Turning details from emails, PDFs, and scanned documents into a dependable contact list depends on consistent extraction and careful merge decisions—not just data entry. Matching on either name or phone number can surface duplicates, but conflicting details or shared names should be flagged rather than silently resolved. I’ll capture only name, email, and phone, using OCR where it helps with scans and checking extracted values against the source when text is unclear. I’ll standardize straightforward formatting differences, such as spacing or phone punctuation, before comparing records. Records with matching names or phone numbers can then be consolidated into one master row, carrying across the available contact information. When a match is uncertain or the records conflict in a way that cannot be confidently resolved, I’ll keep the case separate in a review tab with enough source context for you to decide. The workbook will have a clearly labeled master sheet with one row per resolved contact and the requested three columns, plus a review sheet only where there are cases that need your judgment. I’ll check the finished workbook for missing values, repeated contacts that escaped the merge, and accidental extra fields, and keep the original details available for verification during processing. This keeps the result straightforward to use while making uncertain decisions visible instead of hiding them in the data. Will you provide the emails and their attachments together as files, or should the source material be extracted from a mailbox?


Turning scattered emails, PDFs, and scanned documents into a dependable contact workbook requires careful data entry and consistent duplicate handling—exactly the kind of detail-focused work I provide. I can accurately capture only the required Name, Email, and Phone fields while keeping the final Excel file clean and easy to use. My background in workflow automation with Python, n8n, Google Sheets, and document-focused AI systems supports efficient handling of mixed digital sources and repetitive contact processing. I will consolidate records that share a name or phone number, merge available details into one row, and keep genuinely uncertain matches clearly separated in a review sheet rather than making risky assumptions. I am ready to deliver a well-organized workbook with unique merged contacts and careful attention to accuracy. Choose me to turn your scattered customer information into a reliable master contact list.
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗