Đã hoàn thành

Sort and reformat excel spreadsheets and remove double ups.

1. We need this job started as soon as it’s assigned and completed within 48 hours of being assigned. If you can’t do this and if you are a poor communicator, please don’t bid for the work.

2. We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in 18 Excel documents. In the name of each excel document is the country it’s from. Estimated entries are USA 19,000, Australia 7000 and Canada 5000

3. We need 3 documents, one for each country. One page per document

4. Each of these documents is currently formatted differently so the information is in different columns and they are in different stages of completion.

4. We need to combine these lists into a master list. One for each of the 3 countries with all the information in matching columns.

6. The information we require is the Business name, email address, website, street address, suburb, state, postcode/zip, mailing address, phone number, contact person, contact person’s mobile phone, contact persons position, company type.

Not all this information will be available for every entry, but the available information must be included. Only information for the columns above is required, others information can be ignored.

7. We want one entry per physical address or unique business, all the double up’s need to be removed. Where only email addresses are present, include them if they are not already in listed on another line.

11. For both Australia and the USA, there is an unsubscribed list which must be filtered out of the email column only. The email address should be substituted with “unsubscribed”

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Tìm kiếm web, Web Scraping

Xem nhiều hơn: designing excel spreadsheets, bowling tournament excel spreadsheets, reformat excel spreadsheet, how to find duplicate values in excel using formula, excel remove duplicates keep first, formula to find duplicates in excel, how to identify duplicates in excel, remove duplicates google sheets, remove duplicate rows in excel, excel remove duplicates not working, how to find duplicate values in different excel sheets, convert pdfs excel spreadsheets, proficient excel spreadsheets, business plan free excel spreadsheets, creative excel spreadsheets, reformat excel spreadsheet database format, bookkeeping excel spreadsheets, reformat excel files, accounts receivable excel spreadsheets, basic job description excel spreadsheets

Về Bên Thuê:
( 14 nhận xét ) tuggerah, Australia

ID dự án: #20700379

Được trao cho:

leelakalidas32

I have read your project details and i think i am the right person which you are looking for.i have done many same project, you can check my [login to view URL] is my guarantee,if you want free samples then ping me back. Thêm

$60 USD trong 2 ngày
(399 Đánh Giá)
7.3

22 freelancer đang chào giá trung bình $45 cho công việc này

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD trong 2 ngày
(309 Nhận xét)
7.3
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formu Thêm

$60 USD trong 7 ngày
(107 Nhận xét)
6.9
deepabittu

hello sir i have 5+ member team i am done many project with good result. i am ready now for this work and give you good result. pls view my profile with good feedback...

$60 USD trong 2 ngày
(314 Nhận xét)
6.8
mateenbhatti94

Dear sir I have check the all points and get you need in 48 hours but i can get you in just 6 hours.I will get you three documents one for each country from 18 sheets. I have been in this industry for 1 year and such Thêm

$60 USD trong 1 ngày
(75 Nhận xét)
6.1
shahidul566

Hi dear, I have experience to work with large excel file to set up vLookup, sorting, removing duplicate, matching value and creating graf. Also I can write small macros. So I am willing to work for your project to arra Thêm

$30 USD trong 1 ngày
(15 Nhận xét)
5.2
alexwmsoft

100% Completion Rate and 5 Stars Dear, employer. My name is Lee, I am an experienced web developer, and web scraping expert. I have good experiences in web scraping using PHP, Python, Java and so on. I read your job Thêm

$40 USD trong 7 ngày
(5 Nhận xét)
4.6
BHARATBEURA

HI, MYSELF BHARAT, A WORKING PROFESSIONAL HAVING MORE THAN 5 YEARS OF EXPERIENCE IN THIS FIELD AND I ASSURE YOU THAT I CAN MAKE YOUR PROJECT SUCCESSFUL WITHIN THE TIME LIMIT.  I AM EFFICIENT IN MICROSOFT OFFICE TOOLS Thêm

$60 USD trong 2 ngày
(33 Nhận xét)
4.9
writingapp

Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$40 USD trong 2 ngày
(6 Nhận xét)
3.8
m941

Dear Sir I have experienced in data entry, data mining, data scrapping, internet research, web search, Microsoft-excel, Microsoft-word, google spreadsheet, google docs, PDF conversion in all format and other tasks easi Thêm

$30 USD trong 2 ngày
(8 Nhận xét)
2.8
rajnish93mj

Dear Sir, I have read all your details that you have mentioned. I have more than 5 years of experience in Data entry and fast typing (60+ speed without errors) and i have completed Similar Task for my client so i know Thêm

$20 USD trong 1 ngày
(7 Nhận xét)
3.1
saravana318

I can filter the document and make 3 master list dear hiring manager, I have gone through your project description and I'd like to assist you through the project right now 1. I can create master file for each coun Thêm

$60 USD trong 2 ngày
(7 Nhận xét)
2.0
oepl1112

I am an excel expert and I have lot of time free to send in your project. Please let me help you and lets start a work relationship

$20 USD trong 2 ngày
(0 Nhận xét)
0.0
MatKjeldsen

Let's get started. Having dealt with data entry and Excel sheets for the past 5-8 years, I am more than capable to handle your request. I'll keep communication lines open throughout the process, and will finish it with Thêm

$50 USD trong 2 ngày
(0 Nhận xét)
0.0
Ali1114

Hy! I am a very hard working and competent [login to view URL] all the abilities required to accomplish this job. I have adequate experience in data entry data analysis,data mining,data processing ,Content writing ,blog/par Thêm

$20 USD trong 1 ngày
(0 Nhận xét)
0.0
wasidakhtar000

i will do ......................................................................................................................

$40 USD trong 7 ngày
(0 Nhận xét)
0.0
akashasahoo8

Please hire me for data entry jobs

$45 USD trong 10 ngày
(0 Nhận xét)
0.0
luke25k

Hi there i will separate data country wise ..send me all document .. i will do it less then 48 hours .. thanks

$40 USD trong 7 ngày
(0 Nhận xét)
0.0
mbilal50

Hola. Puedo ayudarlo al precio más bajo posible y con un resultado del 100%. Por favor contácteme para más discusión. Gracias.

$40 USD trong 7 ngày
(0 Nhận xét)
0.0
ajmuli

Cheaper at high quality

$45 USD trong 5 ngày
(0 Nhận xét)
0.0
ThisIsPouya

Hello, Please take a look at my profile for my qualifications. I have a lot of experience with MS Office products specially data management and refinement in Excel. Let me know if you interested in an accurate work. Thêm

$40 USD trong 2 ngày
(0 Nhận xét)
0.0