Data Entry Collection - Taking Organizational Contacts, Putting Them On Excel Spreadsheet in Formatted List

Completed Posted Jul 20, 2013 Paid on delivery
Completed Paid on delivery

Purpose: create a formatted excel spreadsheet database / list of contacts that will be used to import into an address book software.

The project involves a two steps:

- copy and paste a directory of company (list) from a website to an excel spreadsheet

- format/organize the excel spreadsheet .xls

The website is a city's Chamber of Commerce website with a list of all registered businesses in our city. On the directory page, there are 405 A-Z sub-directories (e.g. accountants, plumbers, designers, construction, etc), with typically 1-5 companies per subdirectory (some up to 15). I would estimate 1,000 - 1,500 companies, but this is just an estimate. (I would post the website, but not sure if allowed to on this site).

Each of the 405 sub directories can be copied at one time from website to spreadsheet - then you need to format from there. I will explain below. One company may be under several different directory - no duplicates are required and should be deleted by you.

The information on the website is formatted differently than how it will be with the spreadsheet when formatted. Attached is an example of before and after to get an idea of how things need to look in the end also.

Specific steps:

- For each alphabetic / business category (A-Z) directory on the website, copy all the businesses in each category (e.g. accountants) into an excel spreadsheet

- transpose the data from column to row (the software needs it this way)

- format text in "phone" row. e.g. change phone from "Ph: XXX-XXX-XXXX" to just "XXX-XXX-XXXX" (software doesn't want "Ph:")

- delete fax (don't need this)

- add website if there is an existing link. There is a link to the site, but I need the [url removed, login to view] to be in its own column (see attached for example)

- if there is no street address, the city/province will be pasted into the "street" column. LEAVE THIS AS IS. NO NEED TO MOVE THESE - WILL SAVE YOU TIME.

- Ensure all entries are consistent in how they are lined up - e.g. all phone should be in same row.

Simple data entry with formatting in bulk.

Thank you for your proposal. I would do a similar repeat of this for a much larger city near us in 2 months also and would use same person for that job if they did a good job. Saves me time and convenience and I appreciate that.

Data Entry Excel

Project ID: #4745590

About the project

17 proposals Remote project Active Jul 24, 2013

Awarded to:

afua23

I can get this done for you. I am really good at this.

$25 CAD in 3 days
(13 Reviews)
3.5

17 freelancers are bidding on average $61 for this job

pandeypriya2003

Please check inbox. Thanks

$53 CAD in 3 days
(510 Reviews)
7.5
Innovative116

Hi. I am highly interested in the project. Please check private message for more details. Thank you

$70 CAD in 1 day
(117 Reviews)
7.0
fastwork

Hi, Ready to start immediately. Please refer PMB for further details.. Thanks..

$166 CAD in 3 days
(22 Reviews)
5.5
difan016

Expert team here Regards, Sultan

$44 CAD in 3 days
(175 Reviews)
5.5
sammahmud

Hi, I am interested in this project and assure you that if given me this opportunity, I will prove my efficiency, reliability, and 100% accuracy. Please check your PMB. Thanks

$34 CAD in 1 day
(63 Reviews)
4.8
srinichal

expert in scraping and can deliver the project

$315 CAD in 3 days
(10 Reviews)
4.7
faialeem

Please consider and provide site link in PMB , Yes it is allow here

$35 CAD in 3 days
(22 Reviews)
4.5
Ibrahim185

ready to start

$49 CAD in 3 days
(28 Reviews)
4.0
SoltKemecsei

Hello, I'm interested in your project. I can deliver the database during the day in a nice, professional Excel sheet (Business Category, Business Name, Business Activities, Address, City, State, ZIP, Phone, Website UR More

$25 CAD in 1 day
(14 Reviews)
3.8
Vagtepes

I am interested

$35 CAD in 2 days
(7 Reviews)
3.2
jkumarsanson

Hello sir, I am kindly interested in this type of project works I will perfectly finish the work within the stipulated time kindly give me an offer to work for you I expect your cordial relationship in the due course More

$28 CAD in 2 days
(9 Reviews)
2.9
geoagras

Hello I am new freelancer with plenty of time available and very eager for work. I'm interested in your project and I wish to have the chance to work for you. Thank you!

$45 CAD in 4 days
(1 Review)
1.3
kajamohiuddeen

Ready to start. Please let me know.

$25 CAD in 3 days
(0 Reviews)
0.0
Ocean2Three

Hello ! Ready to help. Please see PM.

$25 CAD in 2 days
(0 Reviews)
0.0
camcdowell

I am familiar with Excel. I am conscientious and detail oriented.

$30 CAD in 3 days
(0 Reviews)
0.0
mjaw70

Good day employer, I fully understand your requirements and can provide you with the accurate database as you desire. I look forward to working with you on this project.

$25 CAD in 3 days
(0 Reviews)
0.0