Create list of data centers in North America (1,777 items) using manual web scraping/copy-paste into Excel

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I want to create a list of data centers in North America into an Excel spreadsheet. There is a site [login to view URL] that has all the information that can be used as a source. The way the site is structured an automated scraping method is unlikely to work and manual cut and paste is a straight forward method to collect the data. If you use the map feature and zoom into North America area that includes the United States, Canada, and Mexico you should see that it matches 1,777 entries. On the left side is a scroll-able list of the data centers I want to capture. You can change the sorting to "Sort alphabetically".

○ I would like the following fields extracted into a separate column in Excel

§ Data Center Name - This is the blue text above each address. The first entry is "1025Connect".

§ Street Address - This is the 2nd line right below the name above. The first entry is "1025 Old Country Road"

§ City - This is the first part of the 3rd line before the comma - The first entry is "Westbury"

§ State - This is a 2 letter state code after the city - The first entry is "NY"

§ Postal Code - This is the numbers right after a space with the state - The first entry is "11590"

§ Country - This is the part after the Postal Code and the comma - The first entry is "United States"

§ Owned By - You have to open a new page by clicking on the blue Data Center Name link and there is a field "Owned By" that is in blue - The first entry is "1025Connect"

§ Verified - On the page with the "Owned By" there is a blue badge with a check-mark next to the data center name. If this graphic exists then indicate "Yes" in this data field otherwise "No". -The first entry does not have the badge so the correct data is "No"

§ UUID - On the page with the "Owned By" this is a button that said UUID. If you click on it, it expands and gives the option to copy the UUID. Paste this data into the spreadsheet. The first entry is "d3668c07-ecd9-48eb-8962-a752b2e79d6b"

Description - On the page with the "Owned By" there may or may not be a lengthy paragraph description below the address. There may be a blue "Read more" that you should click on to see all the text. Copy all the text. - The first entry does not have a description.

Some minor adjustment may need to be made for locations in Canada and Mexico but this is a small number of entries.

The final list should match the 1,777 entries and be verified for correct transcription.

Excel Web Scraping Data Entry Data Processing Data Mining

Project ID: #24350202

About the project

88 proposals Remote project Active 4 years ago

Awarded to:

asadkhan3533

Hello, Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$350 USD in 7 days
(465 Reviews)
7.6

88 freelancers are bidding on average $344 for this job

jeweljitu

Dear Employer, I am a manually data searching and validation expert. I can create a list of data centers in North America 1777 item list manually scraping. I am ready to do the few samples for you. waiting for y More

$500 USD in 7 days
(1370 Reviews)
9.0
Innovative116

Hi there. I checked website. Copying about 1777 locations into spreadsheet in explained data format will be done within 4 days of project awarding. Please check my feed backs for my expertise in data base compilation p More

$550 USD in 4 days
(453 Reviews)
8.6
Ibrahim185

Hi, I checked the website and required fields. I can create a list of data centers manually in North America into an Excel spreadsheet including all fields. I will do few samples at first. you can check similar data More

$300 USD in 7 days
(981 Reviews)
8.4
motiur03

Dear Hiring Manager, I am writing in response to your advertisement Create a list of data centers in North America (1,777 items) using manual web scraping/copy-paste into Excel. I am a top-rated freelancer in Freelan More

$250 USD in 3 days
(397 Reviews)
8.1
mantislin

Hi there, I am scraping expert, I have did more than 500+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/script for you More

$500 USD in 6 days
(382 Reviews)
7.9
mirniyazuddin92

Hi there, I can create list of data centers in North America (1,777 items) using manual web scraping/copy-paste into Excel. Can we talk?? thanks

$250 USD in 5 days
(443 Reviews)
8.1
shoguna2m

Hello, my name is Andres. I lead te data analysis and research team here in our team. We can help you extracting the data accurately according to your instructions within a week and the quote proposed. Let me know if w More

$400 USD in 5 days
(172 Reviews)
7.7
jasminseo6

Hi Dear client, Data Entry & web scraping expert team here and we will start your work right now and will show you sample work on some entries and will work with your 100% satisfaction. We will scrape all info like, n More

$251 USD in 2 days
(175 Reviews)
7.3
bd100m

Hi, I am interested to do this. I am available to do this project. Send me a message for more discussion. I am available now. Thanks

$600 USD in 6 days
(158 Reviews)
7.2
TonmoyRoy111

Dear client I understand the scope of work involved in the project. I love perfection in work so I ensure that the work will be spot on. Kindly contact me. I can provide sample work to assess the quality. Roy

$300 USD in 7 days
(455 Reviews)
7.3
dablu11

All will made manually also checked the website and understand the task. Must submit all 1,777 entries accurately. Reply me for sample.

$250 USD in 7 days
(276 Reviews)
7.1
onlinejob247

Assalamualaikum, there! How are you? I’ve checked the project details. I have huge experience in working with these projects. Okay, If you give me a chance I will work manual web scraping/copy-paste into Excel 1,777 e More

$250 USD in 5 days
(155 Reviews)
6.8
sultanang464

Hi There, I can input your 1777 entries into an excel sheet with 100% accuracy. I already adjust in map with 1777 items. just message me to show some free samples. Please ping me back if you want to hire me now. I c More

$450 USD in 4 days
(193 Reviews)
6.7
plabon979207

Hello There I have read your project description and I am Interested in doing your Project. I have 8 years of experience working in Data Entry, Web Scraping, Web search and Typing Jobs. I have previously worked in data More

$400 USD in 4 days
(199 Reviews)
6.7
mateenbhatti94

Dear sir I will get the 1777 entries from the website into excel sheet. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always work More

$250 USD in 1 day
(125 Reviews)
7.0
farhad31

Hi, I am expert in manual data entry into excel. I can manually scrap 1777 entries into excel from North America. Ready to discuss more.

$250 USD in 3 days
(238 Reviews)
6.4
Devrits

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. *: I can do Data RESEARCH from any platform for certain subjects More

$250 USD in 1 day
(84 Reviews)
6.3
Junaid221

Totally understood. So there are 1777 entries that we need to fetch and organize them in excel sheet. I'll do that in timely fashion. Feel free to contact. Thanks! Junaid U

$250 USD in 3 days
(101 Reviews)
6.1
kayemhussain

Dear hiring manager,, I read job description and I am offering my services on short notice in your project time. I can even work on urgent basis and complete your project soon..contact me for more information. Th More

$300 USD in 3 days
(63 Reviews)
5.9
w3saddam

Dear hiring manager, I am interested in your project. Yes, I am available right now to do your job. I think I am the suitable person for this position. Please don’t be fell hesitate to invite me. I am expert in data e More

$270 USD in 6 days
(85 Reviews)
5.6