
Closed
Posted
I’m working with an Excel worksheet that has grown messy over time and now contains unwanted, exact duplicates. I need a careful clean-up focused on three key columns—Name, Email, and Phone number—so the finished file is accurate, tidy, and easy to maintain. Here’s what I’m after: • Scan the spreadsheet for rows where any of those three columns are an exact match to another row. • Remove or merge the duplicates (we can decide together which approach is safest for my use case). • Return the cleansed workbook plus a short log or second sheet that lists what you removed or changed, so I have a full audit trail. You’re welcome to use your preferred Excel tools—Power Query, formulas, VBA, or a mix—as long as the final deliverable is a single, duplicate-free .xlsx file that preserves all original formatting and formulas outside the affected rows. If this sounds straightforward to you, let’s get the file cleaned up right away.
Project ID: 40652354
26 proposals
Remote project
Active 4 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
26 freelancers are bidding on average ₹883 INR/hour for this job

I'd love to work on your project. I can deliver a clean, high-quality solution with fast communication and on-time delivery. Let's discuss the details!
₹1,000 INR in 40 days
8.6
8.6

Hey there Glane here, I can clean the workbook by checking Name, Email, and Phone for exact duplicate matches, safely removing or merging duplicate records based on the agreed rule, and preserving the existing formatting and formulas outside the affected rows. I’ll also add a clear audit log showing each duplicate removed or changed, so every modification is traceable. The final deliverable will be a clean, duplicate-free .xlsx ready for ongoing use.
₹1,250 INR in 40 days
5.9
5.9

I can clean your Excel workbook by identifying exact duplicates based on Name, Email, and Phone, while preserving your existing formatting and formulas. I’ll safely remove or merge duplicates and add a clear audit log showing every change made. I can deliver a clean, duplicate-free .xlsx file with accuracy and attention to detail.
₹1,000 INR in 40 days
5.2
5.2

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
₹750 INR in 40 days
3.4
3.4

Hi, I can clean your Excel worksheet by finding exact duplicates based on Name, Email, and Phone number, then removing or merging them safely with a clear audit trail. My approach will be to first review the workbook, formulas, formatting, and duplicate rules. Then I’ll identify rows where Name, Email, or Phone exactly matches another row, confirm the safest remove/merge method, and clean the file without disturbing unaffected formulas or formatting. I’m comfortable with Excel, Power Query, formulas, VBA if needed, duplicate detection, data cleaning, audit logs, and careful workbook handling. Deliverables: * Clean duplicate-free XLSX file * Exact-match duplicate check * Name, Email, Phone validation * Removed/merged duplicate records * Original formatting preserved * Existing formulas protected * Change log/second audit sheet * Final quality review I’ll focus on accurate cleanup, full traceability, and a tidy workbook that is easy to maintain after delivery. Best regards Ankit
₹750 INR in 40 days
3.4
3.4

Dear Tusar, I am confident in delivering a meticulous and technically robust cleanup of your Excel worksheet focused on deduplication across the Name, Email, and Phone number columns. Leveraging advanced Excel tools such as VBA macros and Power Query, I will implement a precise scanning method to identify exact duplicates, ensuring accurate removal or consolidation of redundant entries based on your preferred approach. My solution will preserve all original formatting and formulas outside the impacted rows, maintaining workbook integrity. Additionally, I will provide a comprehensive audit log in a separate sheet detailing every removal or change, enabling full traceability of the data cleaning process. With my extensive background in data analysis, cleaning, and automation, I guarantee a final duplicate-free .xlsx file that is not only tidy and reliable but also easy to maintain for ongoing use. I am ready to start immediately and deliver within your budget range in INR. Looking forward to collaborating on this essential project. Best regards, Marwan
₹750 INR in 40 days
1.8
1.8

This project immediately caught my attention because it is exactly the type of work I do best. Your need for a careful clean-up of the Excel worksheet, focusing on "clean, professional, user-friendly" data, aligns perfectly with my expertise. I have extensive experience in data deduplication and cleaning, especially with key columns like Name, Email, and Phone number. While I am new to freelancer, I have tons of experience and have done other projects off site. If this sounds like what you're looking for I'd love to hear more about your project. Regards, Warrick Van Eeden
₹750 INR in 7 days
1.2
1.2

I can carefully clean and organize your Excel workbook while preserving its original formatting, formulas, and structure. I will review the Name, Email, and Phone columns to identify exact duplicate records and safely remove or merge them based on your preferred approach. I will ensure no valid information is accidentally lost and maintain data consistency throughout the process. Along with the cleaned, duplicate-free .xlsx file, I will provide a clear audit log or separate worksheet documenting every duplicate removed or change made. I can use Excel formulas, Power Query, VBA, or a combination of tools as appropriate. I am ready to begin immediately.
₹1,000 INR in 30 days
0.2
0.2

When duplicate rows share the same email but a trailing space in the name column, a simple exact match will miss them. I'll trim whitespace and compare the three key columns case‑insensitively before flagging any repeats. Then I'll either delete the extra rows or consolidate them based on what we decide, preserving all other formatting. A common pitfall is letting a macro overwrite hidden formulas that depend on those rows, which can break downstream calculations. I'll copy the sheet, run the deduplication on the copy, and write a log sheet that records original row numbers and changes. Ready to start immediately and deliver a clean .xlsx with a full audit trail.
₹1,000 INR in 40 days
0.0
0.0

Send me the file and I'll return it cleaned with the audit sheet today, before you award anything. If it's what you wanted you award, if not you've lost nothing. On the remove-or-merge question my default is the safe one: nothing gets deleted outright. Duplicate rows move to a second sheet with the reason and the row number they came from, and the main sheet keeps the first occurrence. The audit trail lives inside the same workbook, and if a "duplicate" turns out to be a genuine second record you can put it back in a minute. One thing worth deciding before we settle on exact matching. In real files email and phone duplicates are usually not exact: trailing spaces, capitals in emails, phone numbers written with and without the country code or with dashes. I compare on a normalised copy of those three columns so those get caught too, while the visible values in your sheet stay exactly as you typed them. If you'd rather keep it strictly exact-match, that's a one line change. Formatting, formulas and everything outside the affected rows stay untouched. I work on a copy and hand back your original next to the cleaned file. My rate sits at the bottom of your range and the reason is plain: I'm new on this platform, so a real review is worth more to me right now than the hourly figure.
₹750 INR in 8 days
0.0
0.0

I can carefully clean your Excel file by identifying exact duplicates based on Name, Email, and Phone Number. I’ll remove/merge duplicates safely, preserve formatting and formulas, and provide a clear audit log of all changes. I’m ready to start immediately.
₹750 INR in 40 days
0.0
0.0

With well over a decade of valuable experience in data entry, analysis, and data management, I am confident that I can tackle and complete your Excel Data Deduplication & Cleaning project to the highest standard. Having worked extensively with various types of data, I have honed my skills in ensuring accuracy, maintaining data integrity, and eliminating duplications effectively. My expertise includes using tools such as Power Query, formulas, VBA, and my profound knowledge of Excel to execute meticulous cleaning processes. Your three key columns—Name, Email, and Phone number—will receive focused attention until all unwanted duplicates are removed or merged based on the safest approach for your use case. One of my main strengths is implementing technologies to streamline operations while ensuring data accuracy. I will not only return to you a tidy and easy-to-maintain workbook but also provide a log or second sheet detailing what has been removed or changed—a full audit trail for you. Let me streamline your Excel worksheet in a speedy yet accurate manner so that you can focus on your more pressing tasks
₹800 INR in 40 days
0.0
0.0

Hi, I can help clean and deduplicate your Excel worksheet while preserving the existing formatting and formulas. I will carefully identify duplicate records based on Name, Email, and Phone Number, remove or consolidate them according to your preferred rules, and provide a separate log of all changes made for easy verification. I can work with Excel formulas, Power Query, or VBA where appropriate to ensure the process is accurate and efficient. I am available to start immediately and will carefully validate the cleaned file before delivery. Thank you, and I look forward to working with you.
₹900 INR in 10 days
0.0
0.0

Hi, I can clean and deduplicate your Excel workbook while preserving the existing structure, formulas, and formatting outside the affected records. My approach will be careful and fully traceable: • Identify exact duplicates across Name, Email, and Phone fields • Review potentially ambiguous matches before removing or merging records • Apply the agreed deduplication rules consistently • Preserve existing workbook formatting and formulas • Create a separate audit sheet showing every row removed, merged, or modified • Perform a final validation to ensure no unintended data has been lost I work with Python, pandas, and Excel data-processing workflows, which allows me to combine automated duplicate detection with manual verification where needed. Before making any irreversible changes, I would confirm with you how records matching on only one field (for example, identical names but different contact details) should be handled. Rate: ₹900/hour Estimated delivery: within 24 hours for a standard-sized workbook. I’m available to start immediately. Best regards, Romain Gac
₹900 INR in 40 days
0.0
0.0

Hi, This is exactly the type of Excel data cleanup I specialize in, and I can start working on this right away. Your requirements are perfectly clear. Here is my step-by-step plan for your file: 1. Identify & Isolate: I will scan and flag all rows containing exact matches in the Name, Email, and Phone number columns. 2. Review & Decide: Before deleting anything, I will consult with you on the flagged rows so we can safely decide whether to merge the data (if other columns contain unique info) or completely remove them. 3. Clean & Audit: I will deliver the finalized, duplicate-free .xlsx file with all your original formatting and formulas completely untouched. I will also include a separate 'Audit Log' sheet detailing exactly which rows were removed or merged for your records. I am highly detail-oriented and ready to get started. Please feel free to share the file (or a small sample if you prefer), and we can get this cleaned up today. Best regards, Parth
₹1,000 INR in 40 days
0.0
0.0

I can clean your Excel workbook by identifying exact duplicates based on Name, Email, and Phone, while preserving your existing formatting and formulas. I’ll safely remove or merge duplicates and add a clear audit log showing every change made. I can deliver a clean, duplicate-free .xlsx file with accuracy and attention to detail.
₹1,000 INR in 40 days
0.0
0.0

I've 2 years experience in data processing for managing users for B2B company in Indonesia and Singapore. Mainly I use formula and power query in my project.I've successfully utilized Power Query and formula for data processing in my previous projects, and I believe these skills are highly relevant to efficiently managing duplicate data entries. Working with a B2B company allowed me to develop an acute attention to detail which is crucial for sifting through extensive datasets, like the one you have, and identifying those vital duplicates in the specified columns. My approach to a smooth and thorough cleanup would be to carefully scan and compare each row to detect any matchings using the specified columns. I believe my experience in handling data with an eye for clean organization and maintaining formatting, combined with my willingness to collaborate with clients, make me an ideal candidate for this task. Let's work together on getting your workbook back to its original tidy state!
₹1,000 INR in 40 days
0.0
0.0

**Job Proposal** Dear Hiring Manager, I am interested in your Excel duplicate-cleaning project. I can carefully review the **Name, Email, and Phone Number** columns, identify exact duplicate records, and clean the workbook while preserving the existing formatting and formulas. I can: * Scan the specified columns for exact duplicate values * Safely remove or merge duplicate rows based on your preferred approach * Preserve formatting and formulas outside the affected records * Use Excel formulas, Power Query, or VBA where appropriate * Create a clear audit-log sheet showing removed or modified records * Verify the final workbook to ensure duplicates have been properly handled * Return a clean, organized **.xlsx** file ready for ongoing use I have strong experience with **Excel, data entry, data processing, data cleaning, and spreadsheet management**. Accuracy and maintaining the integrity of your original workbook will be my priority. I am available to start immediately and can clean and return the workbook efficiently with a clear audit trail. Best regards, **Md. Zahirul Islam**
₹1,000 INR in 40 days
0.0
0.0

I've been waiting for an opportunity like this - a chance to prove my intricate understanding of Excel's power and potential. As someone who hails from an engineering background, I have an inherent love for streamlined, methodical processes that save time and effort. Over the years, I've honed my skills in Excel, particularly in cleansing data and eliminating duplicates, making your project description something I feel aptly qualified for. In my current role as a Product Manager, automation and optimization reign supreme. I've handled copious amounts of data in messy formats, only to fine-tune them into shining examples of efficiency. Data privacy being paramount, I assure you a meticulous approach that includes removing or merging duplicates (as mutually decided upon), while providing a comprehensive log or sheet detailing the changes made. Your data is of utmost importance to me, as much )I guarantee that the final deliverable will be a single duplicate-free .xlsx file that preserves all original formatting and formulas outside the affected rows. In short, choosing me for your project means signing up for precision, proficiency, and perfection. Let's get your worksheet cleared of clutter so that you can finally focus on what really matters - extracting accurate insights from clean data!
₹750 INR in 40 days
0.0
0.0

Hi, this looks straightforward and I can start right away. My approach: scan the Name, Email, and Phone columns for exact duplicate matches, remove/merge them using the safest method for your data, and preserve all original formatting and formulas outside the affected rows. I'll deliver a single cleaned .xlsx plus a second sheet listing every row removed or merged, so you have a full audit trail. On the open question about partial matches (same field but different other data) - I'd suggest flagging those for your review rather than auto-merging, to avoid losing information, but happy to follow your preference. Ready to begin as soon as you confirm.
₹800 INR in 8 days
0.0
0.0

Rewa, India
Member since Aug 17, 2026
$15-25 USD / hour
₹100-400 INR / hour
₹5000-9000 INR
₹600-1500 INR
₹750-1250 INR / hour
$22-40 USD / hour
₹12500-37500 INR
₹37500-75000 INR
₹750-1250 INR / hour
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹400-750 INR / hour
$30-250 USD
$8-15 USD / hour
$10-30 USD
$250-750 USD
₹750-1250 INR / hour
₹100-400 INR / hour