Copy certain data from multiple pages on a site

J

jvc85

New Member
Joined
Oct 22, 2017
Messages
1
Hello everyone, i would like to know if there is any way to copy specific data needed from multiple pages on a site.

This are 3 examples of the pages I need to scrap de data from:

https://www.fundoodata.com/companies-detail/Akshaya-Furniture-Pvt-Ltd/65014.html?&pageno=298
https://www.fundoodata.com/companies-detail/Akshaya-Lakshmi-Comfort/104445.html?&pageno=299
https://www.fundoodata.com/companies-detail/Akshaya-Motors/114111.html?&pageno=300

And I only need to copy from each page, this data:

Company name
Contact number
Website

it should be formatted like this:

CompanyPhone numberwebsite

<tbody>
</tbody>

Caan anyone help me?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You must log in or register to reply here.

Similar threads

F
  • Solved
Webscraping a site with no element ids and returning data
Replies
6
Views
1K
fizzydrink
F
M
  • Question
Scrap data from website multiple pages
Replies
1
Views
370
mji007
M
J
  • Question
Web Scraping - Multiple Pages from a Single URL but URL does not change
Replies
7
Views
784
SQUIDD
S
J
  • Question
VBA get data from a web page
Replies
3
Views
2K
Kyle123
Kyle123
N
  • Question
Using VBA to copy data from Webpage table to excel
Replies
2
Views
7K
New_Grasshopper
N

Forum statistics

Threads
1,215,106
Messages
6,123,120
Members
449,096
Latest member
provoking

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top