Find Jobs
Hire Freelancers

Excel File Needs Reformatting of Data in Appropriate Columns

$10-30 USD

Completed
Posted almost 5 years ago

$10-30 USD

Paid on delivery
Excel files has 8,617 names and addresses. It also has up to ten phone numbers for each household. The phone fields are labeled Phone 1, Phone 2, Phone 3....Phone 10. For each phone number the next column indicates whether the number is a landline, mobile or VoiP. Phone 1 for example mixes landline, mobile and voip in the same column. The type of phone number has to be separated into different columns by type of number: Landline1, Landline 2, Mobile 1, Mobile 2 as examples. While maintaining the integrity of all data, separate all phones by type so phone and type can be upload into CRM for all 10 phone numbers.
Project ID: 19365172

About the project

36 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, i've looked at the file and i see up to 10 phone numbers (of 3 types). If you wish to work with me, i would like to see sample of an output done for the very first line, so i can see the actual desired format that is needed for the CRM upload. Thanks, Milan
$30 USD in 0 day
5.0 (753 reviews)
7.5
7.5
User Avatar
I can make a small macro in Excel to arrange all the phone numbers into columns "Landline1", Landline2".... and "Mobile1", "Mobile2"... "Voip",
$10 USD in 1 day
4.5 (50 reviews)
5.0
5.0
36 freelancers are bidding on average $37 USD for this job
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel sheet with your data where phone numbers are put logically, aka Landline 1, Landline 2, then the mobile phones, etc. I will charge you $30 and can deliver within one day (a single milestone to release once you're satisfied with the final result). I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$30 USD in 1 day
5.0 (565 reviews)
8.6
8.6
User Avatar
Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel. After the phone numbers will be separated then only the columns header will show if the number in that column is mobile phone number or land line phone number , right? Regards.
$25 USD in 1 day
5.0 (187 reviews)
7.0
7.0
User Avatar
Hello, I will be moving all phone numbers into appropriate columns by type Landline/ Mobile/ VoIP. I’m available now. Best regards, Duong
$30 USD in 1 day
4.9 (62 reviews)
6.5
6.5
User Avatar
Hi there, I have read and seen your excel file and understand that you require to separate the columns of Phone numbers (1,..10) in to Landline/Mobile. The columns should be marked as Landline 1..2.. and mobile 1.. 2 and so on. I am a professional freelancer having advance skills in MS Excel and can complete your task in a timely manner. Request you to please visit my profile/portfolio page to know more about me. Get me on the freelancer chat to discuss it further. Thanks.
$50 USD in 1 day
4.9 (52 reviews)
6.3
6.3
User Avatar
Hi there hope you are good we have data entry team and we can do this project so just ping me......................................and let's start your project thnks
$30 USD in 1 day
4.9 (144 reviews)
5.6
5.6
User Avatar
Hi Client, I can manage this task of separating into columns & formatting phone numbers for the excel spreadsheet with 8,617 names and addresses as per your requirement. Let's discuss further. - I can manage lead generation, web researching and lead list building - I can manage online data collection & data mining - I can manage online/offline data entry tasks - I can manage WORD/EXCEL/ACCESS tasks efficiently thanks.... Uday
$50 USD in 2 days
4.8 (84 reviews)
5.9
5.9
User Avatar
Hi, I went through the file and your brief. You basically want to separate the numbers based on their type (landline, mobile,etc). So would you like to add the columns in the same table as before or you would like to remove phone 1,phone2,etc and have landline1,landline2,mobie 1,etc instead Hope to chat with you soon mate Thanks Sajid Khan
$25 USD in 1 day
4.2 (63 reviews)
5.7
5.7
User Avatar
Hi Lovedproperties, My name is Garbo, Excel automation freelancer. I am very interested to your project. I have checked your attachment file and able to grouping phone number by phone type in very soon. I will create vba script to list out phone number and group it based on phone type as per you need. I look forward to working with you soon as I am available now. Best Regards, Garbo
$25 USD in 0 day
4.9 (27 reviews)
4.3
4.3
User Avatar
Hello dear, I am expert in MS Excel, Word, any type of Data Entry Work and Web Research. I am read your project and understood your requirement. I will transfer data from word to template accurately, timely and within your budget. I am also ready to give you sample work. I am only accept work if you are satisfied with sample work, because your satisfaction is more important for me. Let me know if you have any questions. Regards,
$15 USD in 0 day
5.0 (2 reviews)
2.6
2.6
User Avatar
Dear Sir/Madam! If you're searching an experienced typist to type your document, with a rapid turnaround, then you've found TranslatorGurus. We have provided our clients with thousands of articles, eBooks, technical documents, website content pages, and blog posts typing over the last 5 years. So feel free to contract with us for high quality and hassle free typing with your best price. Kind Regards, Mime
$10 USD in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
I am good at excel and I am a professional employee from a reputed company. I have a lot to connections to get the work done within a mean time. I would be happy to get work like this Relevant Skills and Experience I am good at macros, Database and advanced excel with extensive experience of 5+ years which I would consider myself and will be able to complete the current task in max one to two hours.
$20 USD in 1 day
5.0 (4 reviews)
2.1
2.1
User Avatar
I can do it.
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Good Day. I will do my best to complete the job ahead of time. Looking forward to work with you Sir. Have a great Day. :-)
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Excel is my game Excel is my game
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi this is Balakrishna I am a data entry operator i will be assisting you if you give me opportunity to work with you
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir My Lead Generation and Linkedin Work Experience I have been working for 4 years long. I will collect lead generation company name, first / last name, job title, e-mail address, phone number, website, industry, state / city, zip code, country, linkedin profile, profile link screenshots. I can collect them with these own tools. I am qualified for this work, so I am very interested in doing this. I'm a committed, trustworthy self-starter. My goal is to provide high quality services and be interested in building lasting relationships with clients. Thank you
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hai , I have years of experience in data entry and processing. I want to do my first job with you. I have a well knowledge in excel advanced function and formulas. I will finish my work with high quality and accuracy within a time bound. I am waiting for your positive reply...... Thank You, Regards, Sakila.K
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I checked on your excel file and I can do this project in more or less 24 hours. I just need some more details/clarifications on how the headers are going to be for each phone number type.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have expertise in the data processing, data formatting/reformatting, data entry in excel sheet to help you successfully complete your project. My proposal: 25$ to complete the job. Time frame: 1 day
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, sir I am have experience data entry related for some jobs so I can help you for any point do you want
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Washington, United States
5.0
4
Payment method verified
Member since May 11, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.