
Closed
Posted
Paid on delivery
My phone book currently lives in a single .xlsx file and holds about 200,000 records. I need that sheet cleaned and standardised in two key ways: 1. Every duplicate number—regardless of whether it carries the +91 prefix or not—must be identified and removed so each contact appears only once. 2. Phone numbers must carry a consistent format for the Indian market. That means adding or stripping “+91” wherever required so each final entry follows one clear rule (I’m happy to agree on the exact rule with you before you start so we’re on the same page). The end result I’m after is a fresh Excel workbook with: • Zero duplicate rows • Uniformly formatted mobile numbers • No broken formulas, blank rows or stray characters If you prefer formulas, Power Query, VBA, or a combination, that’s up to you—as long as the final sheet opens cleanly in Excel without additional steps on my side. Please let me know roughly how long the pass will take once I hand over the file and, if needed, what interim checks or sample outputs you’d like me to review before you run the full 200k-row operation.
Project ID: 40447100
42 proposals
Remote project
Active 4 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
42 freelancers are bidding on average ₹1,568 INR for this job

With my profound experience in data processing, excel manipulation, and python automation, I am your ideal candidate to tackle this large-scale contact cleanup project. I've worked extensively with Excel for data formatting, and can efficiently handle the 200,000 rows with no loss of quality. With your consent, I can implement a clear and consistent phone number rule for the Indian market ensuring a uniform format for all the entries. I believe in automating tasks wherever possible to optimize efficiency, time consumption and accuracy. Importantly, I think it's crucial to keep you updated on every stage of the project. I will provide interim checks or sample outputs for your review before running a full 200k-row operation, which guarantees mutual understanding. In conclusion, I'm not just offering my data entry skills but rather a complete package of precise and automated solutions. My work history has proven efficient management of large datasets with high accuracy while maintaining long-term reliable collaborations. Let me save you valuable time and effort by transforming that messy phonebook into an asset that will enhance your business operations.
₹1,500 INR in 1 day
9.0
9.0

Hello I have several years of experience with Excel Macros and Visual Basic for Applications I am experienced with cleaning data set and I have completed several similar projects recently I estimate it would take 1-2 hours to complete.
₹786 INR in 1 day
6.8
6.8

I am EXPERIENCED and specialized in CLEANING and STANDARDIZING data in Excel spreadsheets. I will eliminate duplicates and ensure each phone number is in a consistent format, then I will add whatever is necessary so that you receive the spreadsheet ready to open and use. Place my bid now and let's get started!
₹4,000 INR in 1 day
6.6
6.6

Hello I can clean and standardize your 200,000-contact Excel file by removing all duplicate numbers (with or without +91), formatting every number consistently for the Indian market, and delivering a clean workbook with no blank rows, broken formulas, or stray characters. I can complete this efficiently using Excel/Power Query/VBA and will share a sample for review before processing the full file. Regards Muhammad
₹1,500 INR in 1 day
5.9
5.9

Hi there, I can clean up your 200,000 records within a few hours according to your requirements and provide the information you need. Thank you, Anowar
₹1,050 INR in 1 day
5.6
5.6

With a stellar reputation in my field, I bring expertise in data analysis, entry and processing which make me perfectly aligned for this project. My Excel skills include knowledge of functions, formulas, timelines and pivot tables required for your Excel cleanup. Moreover, if you can share a sample output or interim checks that you'd like me to work, I can ensure you get the results exactly as per your requirement. Having handled huge amounts of data throughout my career, working on 200k records will be no challenge. My proficiency in Excel Macros and VBA will not only help identify and eliminate duplicate phone numbers but also make it easier to apply the uniform format specifically tailored for the Indian market. Above all, my commitment to quality and on-time delivery gives me an edge over others. I provide samples and unlimited revisions until you are satisfied with the final outcome. So, if you want just one contact per number, uniformly formatted mobile numbers and a sheet that opens cleanly in Excel without any issues, then trust my expertise to get it done swiftly without сompromising quality. Let's work together!
₹7,050 INR in 1 day
5.2
5.2

Hello, I can clean and standardize your 200,000-record Excel phone book efficiently. I will remove all duplicate numbers, including +91 variations, and format all numbers consistently as per your preferred rule. The final file will be clean, organized, and fully Excel-compatible. I can also provide a sample before processing the full file. Feel free to message me to discuss the details. Kind Regards, -Habib
₹700 INR in 2 days
5.0
5.0

Hi there! I can process your data to make it look consistent by removing or adding "+91" wherever necessary. Lets discuss further in chat if you are interested. We can discuss further in chat. Regards!
₹2,000 INR in 2 days
4.8
4.8

Hello there, I can clean and standardize your 200,000-contact Excel file by removing duplicates (including +91 variations) and formatting all numbers into one consistent Indian format. The final workbook will be clean, error-free, and ready to use in Excel without extra steps. Sample review can be shared first, and the full cleanup can usually be completed within 1 day after approval. Thank you!
₹1,300 INR in 2 days
5.0
5.0

Hello, I can clean and standardize your 200,000-record phone book with high accuracy while preserving a stable, Excel-friendly structure. I’ll normalize all Indian numbers into one consistent format, detect duplicates even when numbers appear with/without “+91”, and deliver a clean workbook with no duplicate rows, stray characters, broken formulas, or blank-entry issues. I can use Power Query, formulas, VBA, or a hybrid workflow depending on what keeps the file fastest and most reliable. Before running the full cleanup, I can share a small sample output for approval so the formatting rule is confirmed exactly as you want. Should numbers like “091xxxxxxxxxx” and spaced/dashed formats also be treated as duplicates of the same mobile number?
₹1,100 INR in 7 days
4.5
4.5

Hi, I can clean and standardize your 200,000-record phone book accurately and deliver a fresh Excel workbook with zero duplicate numbers. I have strong experience in Excel data cleaning, Power Query, formulas, VBA, duplicate detection, and large dataset handling. I’ll normalize all Indian mobile numbers by removing stray characters, standardizing the +91 format rule, and detecting duplicates whether numbers appear with or without the country code. Before processing the full file, I can share a small sample output for your approval. The final workbook will contain uniformly formatted numbers, no duplicate rows, no blank rows, and a clean structure ready to use in Excel. Ready to start immediately once the file and preferred number format are confirmed.
₹1,500 INR in 1 day
4.7
4.7

I read your project requirements and would be thrilled to collaborate with you. Let’s connect to discuss further
₹1,050 INR in 1 day
4.2
4.2

I'll use VBA and deliver a clean and proceed xlsx file according to the requirements with both prefixed all by +91 and without it. I'll also deliver a report by highlighting the duplicates and phone numbers with stray characters or invalid character length.
₹1,000 INR in 1 day
3.5
3.5

Hello! I see you’re looking for a data cleaning expert who can clean your excel dataset. As a freelancer, this is my area of expertise! Based on what you have mentioned in the project description, this process can easily be done by writing a simple Python script, and then expecting it as an excel file. I will write a complete Python script, by importing the raw excel file and performing data cleaning inside Python. Then, when the cleaning is done, I will export the new file as a separate CSV or excel file. So the final deliverable will be a clean excel file with all the data cleaning done. This will hardly take 2-3 hours. Im even willing to do a sample 1000 entries first, free of cost, before starting the project so you can have an idea of what Im offering. Let’s discuss further details in chat. Regards, Taha
₹1,050 INR in 7 days
3.5
3.5

I can finish it with very simple formulas. Just to give you an idea here is how it can be done. If +91 prefix is there leave it as it is otherwise add +91. Then replace spaces in the number and trim any leading/trailing spaces. Now the data is ready for deduplication.
₹750 INR in 1 day
3.4
3.4

Hi, I can efficiently clean and organize your 200k contact list by removing duplicates, fixing formatting issues, and ensuring the data is accurate and well-structured. I’ll handle the task carefully while maintaining consistency and quality throughout. Ready to start immediately. Best regards.
₹1,000 INR in 1 day
3.0
3.0

Hi Sir/Ma’am, I have over a decade of experience working with Excel VBA and can clean up your file promptly. Please share your raw data, and I will process it immediately and return the cleaned version. The cleanup will include: - Removal of all duplicate numbers, regardless of country‑code prefixes - Consistent formatting of all contact numbers - Elimination of any blank or broken rows Please feel free to reach out if you’d like to discuss any details further. I’m available to begin immediately and will ensure delivery within your required timeframe. I look forward to the opportunity to work together. Best regards, J. Shain
₹1,000 INR in 1 day
3.2
3.2

Hi There, I will clean and standardize your 200,000-contact Microsoft Excel file by removing all duplicate phone numbers (with or without the +91 prefix), formatting every number into a consistent Indian mobile format, and eliminating blank rows, stray characters, and any data inconsistencies. Using advanced Excel techniques such as Power Query and formulas, I will deliver a fresh workbook that opens cleanly and requires no additional steps on your side. I can provide a sample output for your review before processing the full file and expect to complete the entire cleanup within a few hours after receiving the data. Thanks & Regards Hafiz Muhammad Iqbal V
₹1,050 INR in 7 days
3.1
3.1

With my extensive background in data entry, processing, and proficiency in Excel usage, I am confident in delivering the best results for your project, Excel Cleanup for 200k+ Contacts. Your need for a systematic approach to eliminating duplicates and standardizing phone numbers aligns perfectly with my skill set. Using a careful combination of formulas, Power Query, and if necessary, VBA, I can efficiently identify duplicates regardless of the presence or absence of the "+91" prefix and remove them from the sheet. Additionally, I can accurately format the contacts according to consistent Indian market rules. Rest assured that I won't leave any room for broken formulas, blank rows or stray characters. The promise I make to every project is one of 100% accuracy while ensuring on-time delivery. My intention is to provide you with a clean, organized output that opens effortlessly in Excel without any additional steps required on your end. Let me back my words up with action by providing a free sample for you to review before executing the full operation. Choosing me means choosing dedication, precision, and effective communication for your project needs!
₹600 INR in 1 day
3.2
3.2

Hi, I read through your requirements carefully, and I can clean and standardize your 200,000-record phone book efficiently while preserving the integrity of the Excel file. What you’ll get: * Complete duplicate removal, including numbers with/without +91 * Uniform Indian phone number formatting across all records * Clean workbook with no blank rows or stray characters * Safe handling of formulas and workbook structure * Final Excel file ready to use immediately I can use Power Query, Excel formulas, and VBA where needed to ensure the process remains fast and reliable for a large dataset like this. I’ve completed similar projects with 5⭐ feedback for accuracy and delivery. I can provide a small cleaned sample first for approval, then complete the full workbook within 1 day after file access. Budget: ₹1,300 INR Please send me a message so we can get started immediately.
₹1,300 INR in 2 days
2.4
2.4

Sonipat, India
Payment method verified
Member since May 27, 2023
₹600-1500 INR
₹600-1500 INR
$2-8 CAD / hour
₹12500-37500 INR
$30-250 USD
$10-30 USD
$30-250 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
€30-250 EUR
₹12500-37500 INR
$750-1500 AUD
$30-250 USD
$15-25 USD / hour
$10-30 USD
$2-8 CAD / hour
$10-30 USD
₹12500-37500 INR
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR