Find Jobs
Hire Freelancers

Google Sheets/Excel Data Manipulation

$8-15 USD / hour

Closed
Posted over 5 years ago

$8-15 USD / hour

I will provide a list of “raw” data that contains the a list of real estate properties and their owners. I want to be able to mail these owners, but only one letter per owner. At a high level the owners are people and businesses. I will use one type of mail letter template for the people owners and a different type of mail letter template for business owners. I do not want to Mail owners that live outside of the US Mail an owner/address more than once I want to format the names so that they are first name last name, not initials, or middle names, etc. Please let me know if you can do this in google sheets/excel, and i can send you a sample to try out. I've attached a sample of the data, on the raw tab, and the headers in the clean tab. Please also respond with how you would do this in excel google sheets/briefly. Please also provide an estimate of how long this spreadsheet would take you to complete.
Project ID: 18641026

About the project

16 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
16 freelancers are bidding on average $12 USD/hour for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$12 USD in 40 days
4.9 (454 reviews)
8.3
8.3
User Avatar
Hi, I can follow your instructions and fill the info for "clean data" sheet. After doing few samples, I can estimate the exact time. Let's discuss and start. Thanks
$8 USD in 40 days
4.9 (981 reviews)
8.3
8.3
User Avatar
Hello sir, I have reviewed your requirement and attached sample file. I can do this job for you as per your requirement. I will use few excel tools to format the data in the way you want. To ensure that I can do this job I have prepared few samples for you. Can you please reply to my bid so that I share the sample file and process to complete this job with accurate results. Looking forward to your reply. Thanks Brad
$8 USD in 15 days
4.7 (438 reviews)
7.9
7.9
User Avatar
hello? How are you? I have good skills in this g sheet . So i can help you if you want. Hope to work with you. Thank you.
$16 USD in 13 days
4.9 (119 reviews)
6.9
6.9
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$15 USD in 20 days
5.0 (36 reviews)
6.7
6.7
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Looked at the workbook attached. Please provide the two email templates. I see, this project would take 10 man hours of work and 3 days deadline Willing to take up your project. Thank you, Regards.
$15 USD in 10 days
5.0 (150 reviews)
6.8
6.8
User Avatar
Hey ! Easy task for me as i am good at excel formulas ! Can you please message me with what i am expected to do ? You want me to fill in the clean data tab right in the excel file right ? Hope to hear from you soon :) Thanks, Ravindu
$11 USD in 40 days
5.0 (65 reviews)
6.4
6.4
User Avatar
Hi., Greeting from SHANS INFOTECH. After reviewing the details of your project, I understood and highly interested in your project. I ensure you that you will be 100% satisfied with our work. Client Satisfaction is my first priority. I look forward to your reply. Warm Regards SHAN
$15 USD in 20 days
4.9 (132 reviews)
6.6
6.6
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$11 USD in 30 days
4.6 (102 reviews)
6.2
6.2
User Avatar
Pleasure to help you. Google spreadsheet is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$10 USD in 40 days
4.8 (75 reviews)
5.6
5.6
User Avatar
Hello, My name is Liana and I'm very interested in your project. I have done similar projects before and I'm confident I can help you out. I have checked the raw data and understood fully the instructions you gave. If given a chance, the first thing I'd do is separate businesses and individuals. Then split the first and last names of the individuals. It may take a few hours to finish the project. I'm also ready to start right away. Thanks and looking forward for your positive response. Kind regards, Liana
$8 USD in 10 days
5.0 (19 reviews)
4.4
4.4
User Avatar
Dear, I would like to apply as a data entry specialist freelancer in your job post. I think I am the right person for this job because I am focused only on data entry jobs and sales.I know how to sell in a different business surrounding, and I have knowledge of following mail in case not responding to first one. I already had two project work, similar to this job (check my portfolio), it also includes exploring and finding right information online, and that is another my quality - work intelligence. My five years in college plus my work experience as shown in my profile have helped me develop mastery in Word and Excel. As proof, I got high marks in both tests in oDesk and Upwork. As a data entry specialist, I also am detail-oriented. Rest assured all the data will be accurately entered, I can guarantee a better quality of work done, better than some of more expensive freelancers. My goal is you to be satisfied with my work and thus open the door to future cooperation. About the job: As you mentioned, there is one mail for people owners and other for business owners. First of all, I would separate people from business, and then contact them. I am looking forward to discussing with you about this job post. Please feel free to contact me. Thank you for your time and consideration. Best regards, mag. oec. Toni Iličić
$8 USD in 20 days
5.0 (3 reviews)
4.0
4.0
User Avatar
Hello there. My name is Nicos and I am US native (born and raised in VA). I believe that I can do this project for you in an excellent time manner. I know that the skill set that you requested was for python, which I have some experience in; however, since you are dealing with Excel and you sent an xlsx file, I can actually do this in PowerShell (a Microsoft Windows scripting language) with ease and precision. I am a government contractor with 10+ years of IT experience. I can provide you my resume if you request it. A task like this is very common in my field and I have had lots of previous tasks dealing with data manipulation, processing and formatting. When dealing with Excel or Google Sheets, doing a lot of data manipulation can easily become time consuming and difficult, which leads to most likely mistakes occurring. Based on some of your requirements, I would import the file in PowerShell, rearrange the US-based customers first, find all of the unique entries based on the customer/owner's name (this will remove duplicates), populate the fields into the desired template and can send that to back in either a csv, html, however you want it to come back. Down the road, if you wanted me to create a many Windows desktop program to streamline this, we can cross that bridge. I estimate that I can get this project done between 10-20 hours and if it comes up less then the minimum, I will notify you. Thank you for taking the time to read this and I wish you well!
$16 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
"Hi You are looking for an experienced person to work your current project. We're well experienced in this area. We will try my best to provide you top-notch quality. We can assure you the quality. Knock me for further details. Regards"
$8 USD in 40 days
5.0 (2 reviews)
0.0
0.0
User Avatar
I would like to kindly express my interest in the advertised role. This is what I do and I only deliver results I'd be happy with for my own business. I've built a very strong reputation because of my commitment, passion and drive to deliver results and achieve success for my clients. My work experience and skills will provide the ideal stepping stone for not only ensuring my clients expectations are met, but also to add value to my clients business and success. I am a business admin professional who is organized, thinks outside the box and a real go getter. Please rest assured you will not be disappointed in my services Please kindly note: * I am available to start immediately * Reliable phone, internet and own office setup * 20 years Business Administration experience It would be an absolute pleasure to be considered for this role and happy to discuss further if need be
$22 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Aldie, United States
4.8
4
Payment method verified
Member since May 17, 2015

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.