Create Excel Database by manual searching

Completado Publicado Dec 7, 2011 Pagado a la entrega
Completado Pagado a la entrega

Create 2 'Master' Excel files by searching and downloading Excel files from a website. This will not take more than 3-4 hours at the VERY most

The winning bid will have this COMPLETED in 1 day

Here are the steps:

• Goto [login to view URL]://[login to view URL]

• Login with

o Library Card Number = 042647880

o PIN = 1871

(I) From Available Databases, Click "US Businesses / Employers USA - 14 million businesses - Search". For the database “US Businesses / Employers USA”, there will be 12,973 total results to download and combine into 1 Excel file, 25 records at a time, which is 520 file downloads using the following steps 1-4:

(1) Create Search Criteria:

a. Select Custom Search

b. Click "Business Type" from left-side navigation

- Select Checkbox for "Major industry group"

- select "+" to expand "Retail Trade (52-59)" (NOTE - do not check the box)

- select "+" to expand "58 Eating and Drinking Places" (NOTE - do not check the box)

- Check the box for "5812-Eating Places"

c. Click "GeoGraphy" from left-side navigation

- Select Checkbox for "Metro Area"

- From Metro Area menu at the bottom of the page:

- Select Iowa from the drop-down for State

1. Select "Des Moines-West Des Moines "

- Select Nebraska from the drop-down for State

1. Select "Omaha-Council Bluffs"

2. Select "Lincoln"

- Select Kansas from the drop-down for State

1. Select "Kansas City, MO-KS"

2. Select “St Louis, MO-IL”

d. Click Green link "VIEW RESULTS "

(2) Download Results - Save the results into an Excel file:

a. Select checkbox to left of ‘Company Name’, so that all 25 records are selected

b. Click "Download"

c. Select "Excel"

d. Select "Detailed"

e. Click “DOWNLOAD RECORDS”

f. Save XLS file

(3) Continue with the Download Results process – combine all results into 1 Excel file:

a. Click "Back"

b. UNSELECT ALL RECORDS – De-Select checkbox to left of ‘Company Name’, so that all 25 records are unselected

c. Goto the NEXT page (click the Right arrow once)

d. Select checkbox to left of ‘Company Name’, so that all 25 records are selected

e. Click "Download"

f. Select "Excel"

g. Select "Detailed"

h. Click “DOWNLOAD RECORDS”

i. Combine these 25 results into 1 XLS file

(4) CONTINUE thru Page 251, UNTIL ALL 6260 records are downloaded

(II)

Click Home or go back to this URL [login to view URL]

• From Available Databases, Click "US New Businesses - 4 million businesses - Search". For the database “US New Businesses”, there will be 1844 total results to download and combine into 1 Excel file, 25 records at a time, which is 74 file downloads using the SAME ABOVE steps 1-4

Entrada de datos Excel Extracción de datos web Búsqueda en la web

Nº del proyecto: #1330031

Sobre el proyecto

11 propuestas Proyecto remoto Activo Dec 7, 2011

Adjudicado a:

sheenakakkar

Hi, I am ready to start immediately.. Please check PMB.. Regards Sheena

$30 USD en 1 día
(14 comentarios)
5.6

11 freelancers están ofertando un promedio de $35 por este trabajo

abdussamad

Please check pm

$30 USD en 1 día
(41 comentarios)
5.9
ExactSystems

Please see detail on PMB regards

$50 USD en 1 día
(3 comentarios)
4.5
abdunnoor99

Expert is here. View PM for details.

$30 USD en 1 día
(13 comentarios)
3.9
Engineer85

Hi, I am interested in doing this project. Have tried your given steps and can complete the work in next 4 hours. Thanks.

$50 USD en 1 día
(12 comentarios)
4.4
aliasneo38

READY TO ROLL OUT RIGHT AWAY.

$30 USD en 1 día
(5 comentarios)
2.9
Sushantind

Dear Sir, We are ready to start the work. Check your personal message.

$40 USD en 1 día
(3 comentarios)
2.1
mondalali100

I can do it very well. Please inform me. Thank you

$30 USD en 1 día
(0 comentarios)
0.0
yellowman57

Hello sir, i want to work with you. if you give me the opportunity, i assure you i will complete my job within one day. commitment and honesty are my investment.

$40 USD en 1 día
(0 comentarios)
0.0
Careuwell

Hello sir, Ready to work. I just refer all the steps. Please check pm

$30 USD en 1 día
(0 comentarios)
0.0
delwar018

Dear Sir Thank you for posting this nice job. I understand your information fairly. To justify my work quality I attached a file as a sample according to your information. Please see that. I will delivery my work on Más

$30 USD en 1 día
(0 comentarios)
0.0