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 address

Benefits 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

User Avatar
Flag of INDIA

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?

User Avatar
Flag of PAKISTAN

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,版权归原作者所有。

阅读原文 ↗

用 HomepageTab 新标签页关注 RSS,打开浏览器就能看到更新。

安装 HomepageTab