
Closed
Posted
Paid on delivery
I have an Excel workbook with well over 10,000 rows that needs a careful duplicate purge. The task is straightforward: identify every repeated record according to the criteria I’ll supply once we start, remove the extras, and return a clean file that matches the original structure in every other respect. Please work directly in Excel—Power Query, advanced filters, or VBA are all fine as long as the result is 100 % accurate and no data is lost beyond the intended duplicates. Alongside the cleaned workbook, include a brief summary noting: • the rule you applied to spot duplicates • the starting and ending row counts Accuracy and a quick turnaround are more important to me than fancy presentation, so if you have a solid method for large-sheet de-duplication, this should be a smooth job.
Project ID: 40715371
46 proposals
Remote project
Active 14 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
46 freelancers are bidding on average ₹15,253 INR for this job

Excel Duplicate Purge – 10,000+ Rows, Custom Criteria, No Data Loss, Power Query/VBA, Summary Report Hello, I'm John K. — MSc Economics & Statistician, 15+ years, 1,000+ projects, 4.9⭐. Expert in large-sheet de-duplication and Excel data cleansing. You need duplicates removed from a 10,000+ row Excel workbook based on your supplied criteria. Preserve original structure. No data loss beyond intended duplicates. Work directly in Excel — Power Query, advanced filters, or VBA. Include summary: duplicate rule applied + starting/ending row counts. How I'll approach it: 1️⃣ Review workbook and your duplicate criteria 2️⃣ Apply de-duplication method (Power Query/Advanced Filter/VBA) 3️⃣ Verify accuracy — no unintended data loss 4️⃣ Confirm original structure preserved 5️⃣ Deliver cleaned workbook + summary report What you'll receive: ✅ Clean, de-duplicated workbook ✅ Original structure preserved ✅ Summary noting rule applied ✅ Starting/ending row counts Turnaround: Quick — 24-48 hours. I'm ready. Drop a message to share your workbook and criteria. Looking forward, John K.
₹12,500 INR in 1 day
4.5
4.5

Hello, I can handle the Excel task with high accuracy and full structure preservation. For large datasets like yours (10K+ rows), I typically use VBA or Power Query depending on what best guarantees consistency and traceability. Deliverables: Cleaned Excel file with duplicates removed Short summary including applied duplicate rule and before/after row counts Please share the detailed requirements, and I can start immediately. I look forward to working with you. Kind Regards, Freddy Ho
₹12,500 INR in 2 days
4.6
4.6

Hi, I would first produce a duplicate preview using your exact matching fields and a clear rule for which record to keep. After approval, I can clean up to 50,000 rows in Excel while preserving the workbook layout, and keep removed records in a separate audit copy. ₹12,500 includes the cleaned file, matching/keeper rules and before/after row counts within two days. Please confirm whether case, spaces, blank fields and near-matches should count as duplicates; I will not merge uncertain matches automatically.
₹12,500 INR in 2 days
4.5
4.5

Hello, I have a ready-made solution for removing the duplicates from 10000 rows Excel using Python. And, I am confident that I can complete it in next 24 hours. I hope to receive your message. Thanks, Raj
₹15,000 INR in 1 day
4.1
4.1

I can safely de-duplicate your 10,000+ row workbook while preserving the original structure and ensuring that only records meeting your defined duplicate criteria are removed. I’ll use a controlled, auditable process so accuracy comes before simply reducing the row count. I have gone through the requirements in detail. Once you provide the duplicate-matching rule, I’ll apply it consistently across the dataset using Excel-native tools such as Power Query, Advanced Filter, or carefully controlled formulas/VBA where appropriate. I’ll validate the results before delivery to ensure no legitimate records or unrelated data are lost. Along with the cleaned workbook, I’ll provide a concise summary covering the exact duplicate rule used, starting row count, ending row count, and number of records removed. The original formatting, columns, and workbook structure will otherwise be preserved. I have uploaded samples similar to this project completed earlier in my profile for your reference. With 10+ years of experience, I am a Chartered Accountant (ICAI) and CPA with strong expertise in Excel, data cleaning, reconciliation, and large-scale spreadsheet management. Thank you for considering my proposal. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion I’m ready to process the workbook accurately with a quick turnaround.
₹12,500 INR in 1 day
3.7
3.7

Hi, I can clean your 10,000+ row Excel workbook and remove duplicates accurately while preserving the original structure and all non-duplicate data. I can work directly in Excel using Power Query, advanced filters, formulas, or VBA depending on the duplicate rules you provide. My process will include: • Review of your duplicate criteria • Backup of the original workbook • Duplicate identification based on exact or multi-column rules • Safe removal of repeated records • Preservation of original columns, formatting, and row structure • Checks for near-duplicates if requested • Validation that no unique records are removed • Final row-count reconciliation • Spot checks after cleanup Deliverables: • Cleaned Excel workbook • Starting row count • Final row count • Total duplicates removed • Short note explaining the duplicate rule applied I’m comfortable with large Excel datasets, Power Query, advanced formulas, VBA, data cleansing, and accuracy-focused record management. I can start immediately once you share the workbook and duplicate-matching criteria, and I can provide a fast turnaround. Best regards Ankit
₹12,500 INR in 2 days
3.4
3.4

I'm the best hire for this project because I've worked on Excel deduplication pipelines across dozens of client datasets. I know exactly what trips people up when you're working at 10,000+ rows, and I won't just run a "remove duplicates" click and call it done. A surface-level pass misses a lot: rows that match on most fields but differ on one, stale entries that should be kept over newer ones, records where spacing or capitalization differences create false mismatches. My actual approach: 1. Confirm your dedup key columns before touching anything. No assumptions. 2. Sort so the right version of each duplicate surfaces on top (by date, completeness, or whatever rule fits your data). 3. Remove the extras and flag everything removed in a separate audit sheet so you can check the work. 4. Return the file with the exact column structure you started with, ready to use. The 10,000-row scale is no issue. I'll use VBA or Power Query depending on which fits your file structure, and the full run takes minutes. What I need from you: the Excel file and your dedup criteria (which columns define a match, and which version to keep when there's a conflict). I can start immediately and have the cleaned file back to you same day.
₹13,500 INR in 7 days
1.6
1.6

Hi, I can accurately de-duplicate your large Excel workbook while preserving the original structure and all intended records. - Strong experience with Excel and data processing - Apply your supplied duplicate criteria consistently across 10,000+ rows - Use reliable Excel-based methods such as Power Query or advanced filtering - Validate the results to ensure no unintended records are removed - Preserve the workbook structure and data outside the identified duplicates - Provide a concise summary with the duplicate rule applied and starting/ending row counts Reference work is available in my profile.
₹12,500 INR in 1 day
1.1
1.1

Hi, I can handle the duplicate cleanup of your 10,000+ row Excel workbook carefully and without disturbing the original structure. I’ll first confirm your exact duplicate criteria, then use a reliable Excel-based method to identify and remove only the intended duplicate records. I’ll preserve all other data and formatting, and perform a final check to ensure nothing has been accidentally removed. I’ll also provide a brief summary with: • Duplicate rule applied • Starting row count • Ending row count • Number of duplicates removed Accuracy is my priority, and I can start with the workbook as soon as you provide it. Thank you.
₹12,500 INR in 7 days
0.6
0.6

10,000+ rows is no problem and I already have a tested process for exactly this. You tell me the match criteria (which columns define a duplicate, and whether trimmed or case-insensitive matches count), and I return the cleaned workbook with the original structure, formatting and column order untouched, plus a second sheet listing every row that was removed so you can audit it. I verify row counts before and after and reconcile removed plus kept against the original total, so nothing disappears quietly. Fast turnaround: send the file and I'll have it back within 24 hours.
₹12,500 INR in 1 day
0.0
0.0

I DON'T COMPETE ON PRICE. I COMPETE ON RESULTS. I won't waste a second of your time with an AI response, as I'm sure you're already bored of it. So let's talk with facts, actions and implementation. I specialize in ensuring data integrity for large Excel workbooks, effectively handling duplicate removal while maintaining the original structure. Your project requires a careful approach to achieve 100 percent accuracy while using tools like Power Query or VBA, ensuring a seamless experience. With extensive experience in data management and a methodical approach to duplicate identification, I can deliver the results you need quickly and efficiently. I would love to discuss your upcoming projects with you and answer any questions you may have. Kind Regards, Stacey
₹12,500 INR in 7 days
0.0
0.0

I have an Excel workbook with well over 10,000 rows that needs a careful duplicate purge. The task is straightforward: identify every repeated record according to the criteria I’ll supply once we start, remove the extras, and return a clean file that matches the original structure in every other respect. Please work directly in Excel—Power Query, advanced filters, or VBA are all fine as long as the result is 100 % accurate and no data is lost beyond the intended duplicates. Alongside the cleaned workbook, include a brief summary noting: • the rule you applied to spot duplicates • the starting and ending row counts Accuracy and a quick turnaround are more important to me than fancy presentation, so if you have a solid method for large-sheet de-duplication, this should be a smooth job.
₹12,500 INR in 4 days
0.0
0.0

Hi, a careful duplicate purge on a 10,000+ row workbook is exactly the kind of task I do reliably. How I'll handle it: 1) Confirm your matching criteria first: which columns define a duplicate, exact vs. normalised matching (trimmed spaces, letter case, number/date formats), and which copy to keep (first, latest date, most complete row). 2) Build a match key and flag duplicates with formulas or Power Query before deleting anything, so every removal is traceable. 3) Remove the extras and return the clean workbook with the original structure and formatting intact. 4) Add a 'Removed rows' sheet listing every deleted record, with its original row number and the row it duplicated, plus a count summary (rows before, removed, remaining) so you can audit in minutes. Near-duplicates that don't meet your criteria exactly (e.g. typos in names) are listed separately for your decision rather than removed. Please share the file and criteria, and I can turn it around quickly.
₹13,000 INR in 2 days
0.0
0.0

Hi, I have carefully reviewed your Excel Duplicate Removal project and would be happy to help you clean and organize your 10,000+ row workbook accurately. With over 30 years of professional experience in accounting, administration, Excel, and data management, I am highly detail-oriented and experienced in working with large and structured datasets. How I will handle your project: Carefully identify duplicate records according to the criteria you provide. Use Excel tools such as filters, formulas, Power Query, or other appropriate methods to ensure accurate results. Remove only the intended duplicates while preserving all valid and unique data. Provide a clean, organized final workbook. Clearly document the rule used to identify duplicates. Report the starting row count, duplicates removed, and final row count. Perform a final quality check to ensure no unintended data is lost. Accuracy is my priority, and I understand the importance of preserving the integrity of your original data. I am available to start immediately. If you'd like, you can share a sample of your file, and I’ll provide a free initial review so you can see how I work before moving forward. Best regards, Nursel Karakaya
₹12,500 INR in 7 days
0.0
0.0

Hello, I understand that you need a meticulous approach to remove duplicates from your substantial Excel workbook while preserving the original structure. My methodology will involve applying your specific criteria rigorously, ensuring that only the intended duplicates are removed, and I can utilize Power Query or advanced filters to achieve this with precision. To tailor the process effectively, could you share more about the criteria you plan to use for identifying duplicates? Additionally, what is your expected timeline for this project? Studio SJ operates on a fixed-price or hourly basis. Is that acceptable for your project? Looking forward to discussing this further. Sone Joubert Studio SJ
₹15,000 INR in 30 days
0.0
0.0

Hi, I read your requirements carefully - deduplicating a 10,000+ row workbook while keeping the original structure intact is exactly the kind of task I handle regularly, using Power Query for a repeatable, auditable dedup process (or VBA if a one-off macro suits better). My approach: load the data into Power Query, apply the exact duplicate-matching rule you confirm, remove only the true duplicates while preserving all other columns/formatting, and deliver the cleaned file plus a short summary - the rule applied and the starting vs. ending row counts, as you asked. Quick question before we start: should duplicates be matched across all columns, or on a specific key column (e.g. an ID)? And would you like the Power Query steps left in the file so you can re-run the same cleanup on future exports, or just a final static workbook? Ready to start as soon as you confirm the criteria and share the file.
₹16,000 INR in 2 days
0.0
0.0

Hello Hiring Manager, I’m a Certified Internal Auditor with more than 6 years of banking audit experience. Reviewing large datasets, identifying duplicates and discrepancies, ensuring accuracy, and documenting findings are some of my strongest skills. I’m comfortable working with large Excel files, and you can be confident that I will carefully follow your duplicate criteria and remove only the repeated records while keeping the original structure unchanged. You can also send me a small sample of the file, and I can review it first. I’m proficient in Excel, very detail oriented, and can start immediately. I hope to have the opportunity to work with you. Best regards, Meerim
₹14,000 INR in 2 days
0.0
0.0

Hello, I can clean your 10,000-plus-row Excel workbook while preserving its original structure. I will first confirm the duplicate key and retention rule, create a backup copy, identify duplicate groups, remove only confirmed extras, and reconcile the starting and ending row counts. I can use Power Query or a controlled script and will provide the cleaned workbook plus a short audit summary. Please share a sample and the exact duplicate criteria so I can confirm the two-day delivery before the project is awarded.
₹12,500 INR in 2 days
0.0
0.0

I can clean the workbook while preserving its existing structure and remove only the records that match the duplicate criteria you provide. I’ll apply the rule consistently across the full 10,000+ rows, verify the result with before/after row counts and spot checks, and return the cleaned Excel file together with a short summary of the duplicate rule used and the final counts. Once you send the workbook and matching criteria, I can complete it within 2 days.
₹12,500 INR in 2 days
0.0
0.0

The task of purging duplicates from your Excel workbook is right up my alley, especially given the size of over 10,000 rows. I've recently worked on similar projects, ensuring accuracy and speed while maintaining the original structure. I will use advanced filters or Power Query to identify duplicates based on the criteria you provide. You can expect a clean file with a summary that includes the rules applied and the row counts before and after. I prioritize clear communication and reliability, ensuring that the process aligns with your goals. What criteria will you use to identify the duplicates? If you choose not to work with me, at least you'll gain insights from my expertise. P.S I look forward to your message Leon Boshoff
₹18,750 INR in 7 days
0.0
0.0

Mainpuri, India
Member since Aug 20, 2026
$250-750 USD
$10-18 USD
₹1500-12500 INR
₹750-1250 INR / hour
$250-750 USD
₹400-750 INR / hour
€12-18 EUR / hour
₹500-4000 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
$15-25 USD / hour
₹1500-12500 INR
€12-18 EUR / hour
₹750-1250 INR / hour
₹1500-12500 INR
$8-15 USD / hour
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
₹1500-12500 INR