Completed

Scrape spreadsheet data from .asp files and populate in new spreadsheet

There are 3 spreadsheets involved:

Reference Spreadsheet A contains the hyperlinks to the Source Spreadsheet. Source Spreadsheet is online (this is what needs to be scraped) contains data to be scraped and inserted into the Target Spreadsheet C.

Reference Spreadsheet contains a list of hyperlinks to other spreadsheets in column A. The process is:

1) Go to the first cell in column A of Reference sheet A that contains a hyperlink

2) Open the source spreadsheet B in the hyperlink (password required the first time)

3) Scrape data from 8 fields of the source spreadsheet B

4) Populate a new row of the target spreadsheet C with the data

5) Go to the next row of column A in the Reference Spreadsheet

6) Repeat steps 2 - 5

Skills: Excel, Web Scraping, Data Entry, Data Processing, Data Mining

See more: extract data mdb files, scrape data google map, fetch data excel files, excel web query multiple urls, excel get external data from web multiple pages, scrape data from multiple web pages, extract data from website using r, import data from multiple pages of a website into a single excel sheet, power query multiple web pages, how to extract data from multiple web pages, extract data from multiple web pages into excel, extract data html files php, asp files linked mysql thing, asp files upload sql server, scrape data database, scrape data website submitting post data php, mac scrape data web, scrape data asp page iframe, can populate data asp page, asp net sharepoint scrape data

About the Employer:
( 647 reviews ) Fort Collins, United States

Project ID: #21046312

Awarded to:

adey665

“ABC” all data aa per attachment” I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I will show you a sample first. I can start your work right away. Ple More

$100 USD in 1 day
(47 Reviews)
4.7

70 freelancers are bidding on average $127 for this job

jhliuster

Hi sir, I can write a script to scrape data from website, wait for your reply, I can start now. thanks. Regards Jianhua.

$160 USD in 2 days
(609 Reviews)
8.4
Innovative116

Hi there. I checked attach screen shots. Please confirm the amount of rows involved in the task. Rest all understood and can start now. Best, Harish

$150 USD in 1 day
(401 Reviews)
8.4
jaylancer43

Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community ([login to view URL] More

$222 USD in 2 days
(714 Reviews)
8.5
mirniyazuddin92

Hi there, I can scrape spreadsheet data from .asp files and populate in new spreadsheet. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$150 USD in 7 days
(417 Reviews)
8.0
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$180 USD in 4 days
(335 Reviews)
8.0
mantislin

Hi there, This is Lin and I am scraping expert, please check my reviews then you will know. Can we discuss more details about this project? then i can provide demo script or example data for you to check. And we can More

$180 USD in 3 days
(318 Reviews)
7.6
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. More

$80 USD in 1 day
(417 Reviews)
7.4
gangabass

I can create a simple to use scraping script that will process reference sheet, get links for each source sheet and next create a target sheet for you.

$100 USD in 1 day
(377 Reviews)
7.3
devi222

Hi Sir, Iam clear about the task, I can scrape it. Im a Python Programmer. I have created many Bots to scrape the websites like Google, Alibaba(suppliers data), Linkedin, Facebook, Trulia(real estate, homes), [login to view URL] More

$150 USD in 2 days
(234 Reviews)
7.1
Nawaz091993

Greetings! I am an expert Web Scraper and I excel in creating automated scripts to automate all kinds of web and file processes with 100% correctness. Web Scraping is my primary skill and I have seen the attached three More

$100 USD in 1 day
(108 Reviews)
6.9
paulmd369

Sir, could you select me as your employee? I am happy to help you. Waiting for your response. Thank you so much

$100 USD in 4 days
(129 Reviews)
6.5
qhairil

Greeting, Hi there, I am Khairil from Indonesia. I have completely understood the workflow of this job. I have 1 question to be answered in order to enable me give exact time to complete the whole job. How many HHD More

$250 USD in 4 days
(51 Reviews)
6.4
srikartiram

Hello, This is doable to me using VBA / Macros. I can take the data's from the sites that has credentials. Please let me know how many links are there. Thank you, Karthik.

$40 USD in 10 days
(200 Reviews)
6.5
vincentong07

Hi! I'm script developer that can retrieve data and do tasks with automation.100% ACCURATE! Questions: *Can you tell me the website URL (Sample of some hyperlinks) ? i would like to do some test on it *The password fo More

$150 USD in 2 days
(93 Reviews)
6.0
ftp2012

== Best Specialist Data Entry & Web Scraping == I am a Expert pulling data from various websites or files and entering that data into rows in excel file. The proof of my professionalism is the feedback from my clients. More

$95 USD in 2 days
(17 Reviews)
6.1
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$98 USD in 3 days
(111 Reviews)
6.3
tusharhossen123

Hi I would like to work with you. I am able to complete the work easily. If you interested. Please contact me. Thank you

$140 USD in 7 days
(168 Reviews)
5.9
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 10 years of IT experience. I have successfully completed few projects which involved Programming, scri More

$140 USD in 3 days
(44 Reviews)
5.7
vwantmoney1

Dear Client, I have reviewed the project details carefully and has understood the project to populate the spreadsheet with the scraping process. I will start working immediately. I would like to provide you with quick More

$100 USD in 2 days
(66 Reviews)
5.6
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$100 USD in 2 days
(115 Reviews)
5.8