Create Excel Database by manual searching
$30-50 USD
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
Nº del proyecto: #1330031
Sobre el proyecto
Adjudicado a:
11 freelancers están ofertando un promedio de $35 por este trabajo
Hi, I am interested in doing this project. Have tried your given steps and can complete the work in next 4 hours. Thanks.
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.