Excel Web Scrape

Cancelado Postado há 7 anos Pago na entrega
Cancelado Pago na entrega

1. On worksheet 1, I would be able to manually type in a single URL (into cell A2) and then activate the VBA script.

Example: [login to view URL]

2. The script would then scrape the HTML code on this page to look for any <a href> URLs that match a pattern based on the original URL, which would remove the .html at the end and replace it with a /).

Example to match: /en/services/finance/

3. The script would then return those values to the spreadsheet, then go and visit each of those new URLs and do the same thing.

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

4. Then repeats until no more URLs found (ensuring that no duplicates are included in the list, otherwise it may fall into a loop).

5. The end results would be to display all of the found pattern-matched URLs (in order) into worksheet 2.

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

Let me know what it would cost to develop.

Excel Captura de dados na web

ID do Projeto: #11645958

Sobre o projeto

54 propostas Projeto remoto Ativo em há 7 anos

54 freelancers estão ofertando em média $367 nesse trabalho

TypingxpertRehan

Hi, I have a few questions about your project. Please send me a message so that we can discuss more about details like price, task, duration thanks

$263 USD in 10 dias
(1346 Comentários)
9.4
cgullapalli

Hi, I am good at Excel and vba. I would like to discuss further the scope of work. Looking forward to discuss in the chat.

$750 USD in 5 dias
(1128 Comentários)
8.3
mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Mais

$309 USD in 6 dias
(424 Comentários)
8.1
Khurramz

Hi! It can be done in VBA but the speed might be very slow but in case of C#, python or php the process will be fast. Please let me know your preferred language and I can help you.

$750 USD in 10 dias
(411 Comentários)
7.8
PigtailXL

Hello Sr. I'm Jorge from Argentina, a responsible person who have wide experience working with Web Data Extraction (Scraping) projects, with different tools and one of those is Excel and VBA (Macro's development). Mais

$250 USD in 3 dias
(248 Comentários)
7.6
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$257 USD in 5 dias
(335 Comentários)
7.3
aarifakhtar

Hi: I have a quick question: Do you want the script in VBA specifically or would python work too? Python is more adept in web scrapping than VBA. hence, I would suggest Python. The output would still be in Excel. Pleas Mais

$250 USD in 4 dias
(178 Comentários)
7.1
katilinas

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$250 USD in 10 dias
(116 Comentários)
6.6
Anamika97

Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day, Mais

$368 USD in 6 dias
(200 Comentários)
6.5
dpune

Hi, I have more than 14 years of Web Automation and VBA/Excel exp and I am expert in this kind of work. Please send me more details about the work. It will help me estimate time and cost. I have completed mo Mais

$400 USD in 10 dias
(126 Comentários)
6.3
ginne24

I have a wide experience in Data Entry/Web Researcher from my previous jobs. I can make sure to be a great asset in your team/company as I am reliable and I always make sure to be available and present depending on you Mais

$250 USD in 5 dias
(12 Comentários)
5.7
Gonesh

Dear Sir, I have perused your job offer. I have interesting to perform said assignment. I am data entry specialist. I have five years professional experience in this field. I am also typing specialist. My typing spee Mais

$250 USD in 25 dias
(103 Comentários)
5.9
DelowarHossen

Hello, I read your post very carefully and understand what you need for this project. I expert of web scraping, data mining and able to scrape any specific information from any website even from restricted site. Alread Mais

$300 USD in 5 dias
(33 Comentários)
5.8
markelof

Hello, I can create it for lower price $100. I have a lot of experiences with Web Scraping. As you can see on my freelancer profile. Contact me for more details. Thanks in advance.

$250 USD in 2 dias
(51 Comentários)
5.4
Taisho

Hello, I can prepare such VBA macro in max 2 days. The task looks quite easy for me. I will ensure that no URLs from buttons appear (like social media share URL). Please have a look in my portfolio where I have 2 V Mais

$250 USD in 2 dias
(63 Comentários)
5.4
muradeltaher

Hi there, I’d like to be considered for your position. For 11 years I’ve worked in Engineering and so I am accustomed to working with all sorts of products and services, and in a variety of industries. I have a de Mais

$250 USD in 10 dias
(76 Comentários)
5.0
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Mais

$555 USD in 10 dias
(49 Comentários)
4.7
bob1982

Hi, i am very good in php/mysql/css/bootstrap/jquery/web scraping/excel vba i have read the description and quite sure i am able to do the work with desired accuracy hope to hear from you soon

$555 USD in 10 dias
(24 Comentários)
4.9
poduzov

Hello That's easy. $80. Excel VBA script is not the best and most effective tool for this, but if you insist, this can be done in Excel. Best regards, Dennis Poduzov

$277 USD in 3 dias
(25 Comentários)
5.1
tomkusvw

Hi! My name is Tomasz Kustra, and I am from Poland. I am interested in this project. Here is example of web scraping in Excel completed by me earlier https://www.freelancer.com/projects/Excel/Find-Information Mais

$250 USD in 7 dias
(6 Comentários)
4.1