Excel Web Scrape

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado Pagado a la 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 Extracción de datos web

Nº del proyecto: #11645958

Sobre el proyecto

54 propuestas Proyecto remoto Activo hace 7 años

54 freelancers están ofertando un promedio de $367 por este trabajo

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 en 10 días
(1346 comentarios)
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 en 5 días
(1128 comentarios)
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, Más

$309 USD en 6 días
(424 comentarios)
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 en 10 días
(411 comentarios)
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). Más

$250 USD en 3 días
(248 comentarios)
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 en 5 días
(335 comentarios)
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 Más

$250 USD en 4 días
(178 comentarios)
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 en 10 días
(116 comentarios)
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, Más

$368 USD en 6 días
(200 comentarios)
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 Más

$400 USD en 10 días
(126 comentarios)
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 Más

$250 USD en 5 días
(12 comentarios)
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 Más

$250 USD en 25 días
(103 comentarios)
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 Más

$300 USD en 5 días
(33 comentarios)
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 en 2 días
(51 comentarios)
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 Más

$250 USD en 2 días
(63 comentarios)
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 Más

$250 USD en 10 días
(76 comentarios)
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 Más

$555 USD en 10 días
(49 comentarios)
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 en 10 días
(24 comentarios)
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 en 3 días
(25 comentarios)
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 Más

$250 USD en 7 días
(6 comentarios)
4.1