HomeОбразованиеRelated VideosMore From: Dinesh Kumar Takyar

Automated data scraping from websites into Excel

1603 ratings | 514168 views
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can scrape, pull or get data from websites into Excel by performing a few simple steps. 1. record a macro to find out how one or many tables or data can be scraped from the website 2. Study the code carefully 3. Create an Excel sheet containing the links that get you the data from the appropriate web pages 4. Automate the process using a loop that creates a) New worksheets b) Automatically changes the link to the web pages that have the required data You can view the complete Excel VBA code here: http://www.familycomputerclub.com/scrpae-pull-data-from-websites-into-excel.html http://www.familycomputerclub.com/get-web-page-data-int-excel-using-vba.html Interesting Links: http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Html code for embedding videos on your blog
Text Comments (262)
Tafazzul Nadeem (2 months ago)
How to save data from a websit into different excel files and saving it into a folder continuously with a given frequency so as to create a data set folder? Thanks
Dinesh Kumar Takyar (2 months ago)
These links will help:https://www.youtube.com/playlist?list=PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa https://www.youtube.com/playlist?list=PLFoKoDG_7gtLV_wyhSec18KRFZoPMKgaJ Or search https://www.exceltrainingvideos.com/
rajiv kukreja (3 months ago)
how to pull data from Amazon website of products prices and ratings
Dinesh Kumar Takyar (3 months ago)
https://www.youtube.com/watch?v=BY-1nihCzYU&index=6&list=PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa
Steve Shi (3 months ago)
Good way, and useful. Recently, I also try ScrapeStorm to scrape datas, and find it's good.
Dinesh Kumar Takyar (3 months ago)
https://youtu.be/Z2iO5kaavwM
Rounak Dasri (4 months ago)
Hi can you help me scrapping data using crome. I need to enter data in input fields, click on buttons and pull out result. The website is no longer supported by iexplorer due to updated html version on the page. Thus need to scrape using Chrome or Firefox
Dinesh Kumar Takyar (4 months ago)
https://www.youtube.com/watch?v=Z2iO5kaavwM&feature=youtu.be https://www.exceltrainingvideos.com/scrape-web-data-with-google-chrome/
Touche Softwares (6 months ago)
Awesome tools! Congratulations and thank you for sharing this. anyone have experiance with this tool? Local business extractor
FritzHugo3 (6 months ago)
Great Video, very thx. Question: Is it possible to put Data from Excelcells to send it on a Website (formular...) eg. The YouTube uploading Webpages are totaly terrible. Is it possible to write arguments in excel and then send it to Youtube for chance videoname or Thumbnail or from private to public... and all the other arguments like in the Browser. First Browsers are allways slower, every one f*****g click you must wait. You cant save anythink to make a pause or for a backup. You must click three different sites and musst scroll to see everythink at a glance (and there are realy enouth space on it, terrible designed!) I dont understand why a so big concern like YouTube/Google have not a client uploadtool, realy i cant understand it. I know there are a short list for tools but realy the free versions have no realy options to type the arguments and i havent the money to spent 30€for a mini little better version. I have the best free tool "YouTube movie maker" but its not what i realy want.
Sakil (6 months ago)
Thnx....but sir in my case: there are three checkboxes on the webpage and wbile selecting any of checkbox the url of the page remains same and as url remains same,i m unable to import tables corresponding to all three checkboxes. ... please if possible suggest me..
Miranda Liu (7 months ago)
Hi, Sir. May n know why i cannot access the website when i pasted the website link by followig your steps?
Dinesh Kumar Takyar (7 months ago)
Maybe the website has been redesigned. In that case you'll need to check the website's html code and act accordingly. Or, you may need to recheck your code.
Niraj Karhe (7 months ago)
I have the list of 100 hyperlink in Excel need to extract the data from the website All are the same website (same pattern), just need to extract the name from them. please help
Narinder Kumar (8 months ago)
Thanks a lot Sir
Ank Gangheri (10 months ago)
How to download bulk account detail of people into excel... Plz help me m a banker and i have to download almost 25000 people detail.. M tired of downloading it one by one using there account no of this 25000 people.
AngelicHugs (10 months ago)
nice video sir please tell me how to extract specific data like product names of any web sites
Dinesh Kumar Takyar (10 months ago)
Search my channel, refer to the playlists or search my website https://www.exceltrainingvideos.com for a solution.
Ankur Verma (11 months ago)
Thanks for the video. It was really helpful. I have one question related to it. I have to extract the data from 10 different links of same website. Can you please explain how can I connect all the 10 macros and for automation so that all my data get extracted from the web once I run the macro
Ankur Verma (11 months ago)
Dinesh Kumar Takyar yes sir I have seen this video but multiple data gets extracted in same tab. please share the solution
Dinesh Kumar Takyar (11 months ago)
Have a look at this playlist: Scraping Data from Web Pages https://www.youtube.com/playlist?list=PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa
xSiD0x (11 months ago)
Need exactly this for Excel 2016! Could u help?
james pruett (11 months ago)
can you make a selenium->excel tutorial. I like your teaching style!
Oana Cristina Palade (1 year ago)
Thanks you saved me too!!
Swarnika Studio (1 year ago)
nice video
bay (1 year ago)
what with data that is constantly is changing like a stock ticker?
sri dhar (1 year ago)
how to open python output in web browser that fetched from excel document
Yemi Adenusi (1 year ago)
Hello Dr, I need your service in building an automated data scrapping software into excel and much more on automated programmed systems for online services. Kindly send me a message on how to reach you
Jurij Fedorov (1 year ago)
I found a simple table with text. The yellow arrow didn't appear :-(
Arif Merchant (1 year ago)
Can you help me to get NSE India Script price live in Excel, Thanks
LEARNING & EARNING (1 year ago)
Any one able to extract database from a ecom site
Vineet Sagar (1 year ago)
Dinesh Ji I’m working on data analytic website focused on energy sector. Looking for expert in data analytics. Can you please share your coordinates. My no. Is 7932810081
petufo (1 year ago)
Great video! Thanks. Is there any way how I can scrape HTML files located on my hard drive?
Dinesh Kumar Takyar (1 year ago)
That's much easier. Use the same code without going to the website. Just give the path to your file on the hard-disk.
Gennevieve Acain (1 year ago)
So helpful..! I'll try this ..
Aspire Aspire (1 year ago)
sir, thanks you for your tutorial. Now i am using with to help my task. one question if you may answer, can we add time limit in this VBA so if one page is not responding for example in 1 minute, the page will be passed and move to another web page. I have an experience scraping for example 100 web pages, but suddenly it stuck at a web page in the middle so the script fail to scrape data and fail to move to another web page. If only I can limit how long the script trying to scrap data, for example 1 minute only, it will very useful for many of us. thanks before hand. Hope you in good health always.
Saurab Mithbavkar (1 year ago)
Sir I am looking to pull data like name and contact no from a website where i have to click on contact to get the no. like this there are 1380 pages with 10 entries each. can it be done using this process
Dinesh Kumar Takyar (1 year ago)
What have you tried? Search my channel or website https://www.exceltrainingvideos.com
TheScrpk (1 year ago)
Thank you for the video Sir! Really helpful. I, however, want the results in the adjacent row of each website instead of a new worksheet. Can you please provide your valuable inputs? I think the Destination will need to be changed.
bollam Hudson (1 year ago)
Hello Dinesh.. it was a fantastic video . Your daily teachings making me to learn more and more .. Dinesh - a quick question for you I have got a portal it's oracle and I am trying to pull the data using VBA can you please advise on it ? ..
Molly Zuniga (1 year ago)
what if just want to put the data on a new row (keep it on the same worksheet)
Dinesh Kumar Takyar (1 year ago)
Find the next blank row and place the data there. Search https://www.exceltrainingvideos.com
rayj12001 (1 year ago)
I have many decades in development and need to do this. Very instructive Thank you for this video!
Snigdha Gondwal (1 year ago)
how to scrape data from a website based to data in excel sheet. like, i have an excel sheet of more than 1000 ip addresses and i want to obtain country, zone, state etc from a website for all the ip addresses
Rabia Tasneem (1 year ago)
now, if i want to present this data in the form of an article or report. how would i do that using excel.
shuntian wang (1 year ago)
This is very nice ! I learned something thanks!
Marcel Whelan (1 year ago)
Hi Dinesh, handy trick. Is there a way to automate the extraction so that the data from each page populates underneath itself? If I want to query 1000's of pages and I don't want data from each page to populate into a new worksheet as I will have to go into each one and copy and paste them to consolidate the data.
Dinesh Kumar Takyar (1 year ago)
Search https://www.exceltrainingvideos.com for a solution.
raju raj (1 year ago)
but I didn't got how u got the source code
Dinesh Kumar Takyar (1 year ago)
Watch the video again carefully.
haleema sadia (1 year ago)
sir I need to extract data from university website can you help me with that ... Regards
Pulse (1 year ago)
Hi, is there a way to automate this excel macro to run at different times of the day? Example every half an hour?
Dinesh Kumar Takyar (1 year ago)
Yes
shahab khan (1 year ago)
Hi Sir, can u help me out with white pages. com I want to pull out name, address, phone no, from white pages. com to excel. Can u please help. Waiting for your next video.. Thanks.
Harsh Singh (1 year ago)
How Can Extract Number Of Comments From The Number Of Blog Post URLs?
Himanshu Baurai (1 year ago)
can i fetch the price of products with this method from any e-commerce site or the shipping price of the products if i have the product ids
Dinesh Kumar Takyar (1 year ago)
This link will help: http://www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/ Or do a search at http://www.exceltrainingvideos.com
Arun kumar P (1 year ago)
thank you
Neeraj Doriya (2 years ago)
sir i want to know how to scrape data on any website behind captcha and login by python
Dev Yadav (2 years ago)
great vedio.question how to extract data from multiple pages.like page 1 ,2,3.....
Dinesh Kumar Takyar (2 years ago)
Search http://www.exceltrainingvideos.com
Maica Tran (2 years ago)
hi Sir, everything is great to me, except the writing code in VBA.. I dont know how to start with this.. how can i know what i should write? could you please advise? I have different website and i need to get contact details from each website.. Appreciate for your help
Vinu Vish (2 years ago)
hi sirhow can i scraping data from following link https://apps.coachfederation.org/eweb/CCFDynamicPage.aspx?webcode=ccfsearch please help me sir
Paras Thakur (2 years ago)
Hello sir - I need to extract phone numbers ,facebook likes,vat number and copyright from a site and populate automatically in to excel . I have different urls in excel & it has to go and search the website is it possible?. . Can i seek your guidance on this. Thanks in advance and expecting postive revert back from your side
Dinesh Kumar Takyar (2 years ago)
This link will help: http://www.exceltrainingvideos.com/automate-scraping-of-hyperlinks-from-web-pages-using-excel-vba/ You can also do a search at http://www.exceltrainingvideos.com
brianxyz (2 years ago)
Your video would be so much more useful if you would maximize your windows. All of the scrolling was very off putting.
Peter Giroux (2 years ago)
OK so I just saw your example using Internet explorer which should solve the cookie problem, but know I just remembered that the results page opens in a new window. So is it possible to examine that newly opened page as well? I know its a little oof topic now!
Peter Giroux (2 years ago)
Thanks for a great tutorial. But how do you handle a website that requires cookies to be enabled.
Yogi Soni (2 years ago)
Worksheets.Add(after:=Worksheets(Worksheets.Count)).Name = x if I need to paste another URL data into next column, what will be the code. Thanks in Advance Sir
Dinesh Kumar Takyar (2 years ago)
This link will help: http://www.exceltrainingvideos.com/tag/find-last-row-column-cell-in-an-excel-worksheet-with-vba/ For more solutions search http://www.exceltrainingvideos.com
Amitha Mai (2 years ago)
Hello sir - I need to extract phone numbers from a site and populate automatically in to excel based on Company Name. I have Company name in excel & it has to go and search the website and fetch the phone numbers of that company from that website. If the value not found it must throw an error. Can i seek your guidance on this. Thanks in advance and expecting postive revert back from your side.
andreikilla (2 years ago)
Thank you for video, would you know how do I avoid scientific notation when doing this process??
Yinyan Guo (2 years ago)
Dear Dinesh, do your method can be used to extract hotel price of some hotels from https://www.expedia.ca/Hotel-Search?#&destination=Quebec,%20Quebec,%20Canada&startDate=06/11/2016&endDate=07/11/2016&regionId=&adults=2, please let me known. Many thanks
Suprabha Pandey (2 years ago)
i import some products to a new site, now i need to check the products which are left, so is it possible to import all product details from category page into excel and i need only limited details like their sku price title swatches and colors
Dinesh Kumar Takyar (2 years ago)
This link might help: http://www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/ Or do a search at http://www.exceltrainingvideos.com
Bob Arnold (2 years ago)
Thank-you. I particularly like the speed of your demonstration with rhetorical questions to make sure we understand. I'm curious about the characters in the url which you are not allowed to mention - perhaps you could give us a broader hint. Your demo has saved me a lot of time.
Diwas DIP (2 years ago)
hello Dinesh. Can you please help me with the additional codes if i want my sheet named as the state names?
Dj MaCz (2 years ago)
Hello Dinesh If i only have column A only with 4 Url, without column B after i use the VB code, it stuck here With ActiveSheet.QueryTables.Add(Connection:=mystr, Destination:=Range("$A$2")) any reason? is it because of the Column B is not applicable?
John Coester (2 years ago)
Hello- Can my company hire you to help with gathering data?
Sean Low (2 years ago)
+rajesh negi I rather hire your mum
Rajesh Negi (2 years ago)
hire me
Taylor Sharrock (2 years ago)
Amazing! Thank you!
wikiteli (2 years ago)
Hi Do you have any idea to collect/scrape data from this type of site its contain almost 20,000 agents.
wikiteli (2 years ago)
Yes any idea +Ananthakumar E 
Ananthakumar Eswaran (2 years ago)
wikiteli
very simple and informative video. Thanks for posting
K D'Arcy (2 years ago)
Thank you for posting
Lorenzo Palumbo (2 years ago)
Hi, I'd like to import data protect with ssl certificate. Can i import data from https automatically? Thank's for your answer.
Pablo Evia (2 years ago)
Hi Dinesh, Many thanks for your video. Actually I am trying your code for extracting some information I am interested in. The problem, however, is when there is some non-existent webpage from which the program is trying to pull information. In that case, the code stops working. How this could be avoided? Thanks in advance!
Dinesh Kumar Takyar (2 years ago)
+Pablo Evia Wow!
Pablo Evia (2 years ago)
+Dinesh Kumar Takyar Thanks, I actually included 'On Error Resume Next', and it worked perfectly!
Dinesh Kumar Takyar (2 years ago)
+Pablo Evia You can use an If statement like - If URL="" then exit sub
Dhanamma Jagli (2 years ago)
very useful
The Indian Freelancer (2 years ago)
Very useful. I wish you could give us the entire code. But I think I can do the rest of it from here. Thanks a lot!
Dinesh Kumar Takyar (2 years ago)
+ZeroViewsChannel http://www.exceltrainingvideos.com/scrape-data-automatically-from-websites-into-excel/
Thomas Witte (2 years ago)
Thank you very much for this tutorial. I recently had to start using the Win version of Excel since the OS version does not support getting data from the web and this was very helpful. However I ran in to one small issue. The data I am scraping is updated after each game and there is a date/calendar drop down menu on the page. I often want to test my simulation with old data - say from 2012 - which I can select with the calendar drop down... However it that field is not editable. Is there a way to edit the date somehow?
Kalyan Teja (2 years ago)
Sir I have seen your videos. I have question, your video shows how to get details from a one website, my question is it possible to get details from multiple websites?Eg. I am trying to caputure the company contact details from the list of websites mentioned below. (1:52:08 PM) http://www.synventive.com/ContactUs/Default.aspx?id=330 http://www.achaogen.com/ http://www.alexza.com/ http://ambrx.com/ Thanks in advance.
Dinesh Kumar Takyar (2 years ago)
+Kalyan Teja This link might help: https://youtu.be/BY-1nihCzYU
Open Warner Robins (2 years ago)
what if you want to scrape data that hasn't appeared yet? for instance, what if a new table is added to a website every month and you want to scrape the new data, versus checking and replacing existing information with updated data. I'm not looking to replace with newer data, I'm looking to scrape new content.
Mohammed Alam (2 years ago)
Hi Mr.Dinesh, This was great. Is it possible to create a macro/module to filter a date(field) in an web page and retrieve data to excel using web query? For example : If we have a webpage with date field like Date From:________ Date To________, can we automate the date field using macro/module to fixed the date from as TODAY() and Date To as TODAY()+2 . Which means every time I open my excel workbook it should refresh automatically and fetch data from today plus two days and display in a table? Appreciate your help.
Ricky Stewart (2 years ago)
Hi Dinesh, I am trying to import products from a vendors website and pull it into a CSV file with image url location, price, descriptions from the site, etc. How can I do that? There are several items on each page and it does not have the yellow arrow box? Thank you kindly!
Mark Arciaga (2 years ago)
I'm having trouble with the syntax. What's the syntax after mystr = Cells(x,1)? Worksheets.Add(After:=worksheet(worksheets)...
Jamez D (2 years ago)
Superb! Finally answered my question of ponderous theories!
nmlker (2 years ago)
Hello Dinesh, Thank you for the tutorial. I am trying to extract data from a website with multiple pages and want to save it in 1 worksheet. However, your code creates multiple worksheets. I've tried to alter it by uncommenting the worksheets.add line and referencing another cell (such as $b$1) but with every run the cells are overwritten. How can I adjust the code so with each run the scraped data will be added? Thanks in advance
Helena Avila Arias (2 years ago)
Did anybody ever find out how to do this?
Cristiano Bellavitis (2 years ago)
+Dinesh Kumar Takyar Thank you for posting this, it is the most useful VBA/Excel tutorial I found online. I have a similar problem to the one +Ryan Ip had. Could you please elaborate on your answer? Everything works but instead of creating multiple sheets I would like the data to be in a single sheet. First download in A2, then A187, A372 and so on. Also, I was wondering whether it is possible to insert the name (e.g. Alabama, California etc) on A1, A186, A372. Thank you in advance
Ryan Ip (2 years ago)
+Dinesh Kumar Takyar. Hi Dinesh and thank you for responding. What I did was: 1. Extra "y" integer that adds with ever iteration a number of rows. So I would get "Destination:=Range("B" & y)) with the querytables.add command. Unfortunately with every loop the previous y-rows are empty. The excel sheet gets the data from the website. It places row 1-y on the sheet. Then the next loop the previous rows are being emptied (or it looks like that).
Dinesh Kumar Takyar (2 years ago)
+nmlker Instead of using an absolute reference like $B$1, use a relative reference like B1 and code to change the reference as the data extraction proceeds.
NittanyNation22 (2 years ago)
There are websites where there are no yellow arrows so I can't import that particular table. I only have 1 at the top of the page and my only option is to import the entire page. Would you know why? If the "table" isn't actually a "table" but in some other format, is there still a way to import it?
Dinesh Kumar Takyar (2 years ago)
+NittanyNation22 Check these helpful links: http://www.exceltrainingvideos.com/scraping-web-page-data-automatically-with-excel-vba/ http://www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/ http://www.exceltrainingvideos.com/scraping-web-page-tables-data-using-vba/ http://www.exceltrainingvideos.com/complete-automation-of-getting-web-page-data-into-excel-worksheet-using-vba/ http://www.exceltrainingvideos.com/automate-scraping-of-hyperlinks-from-web-pages-using-excel-vba/
Vijayalakshmi Sriram (2 years ago)
Very well explained..but will need a bit of practice too!!!
Steven Thibault (2 years ago)
How can you output to different columns on 1 sheet? I don't want a thousand different sheets for each link! It would be way better to have it all in different columns on a single sheet.
Helena Avila Arias (2 years ago)
Did you ever find out how to do it?
UnCommonVision (2 years ago)
Does this also work with Google Sheets or OpenOffice Spreadsheets?
Martin Holsinger (2 years ago)
I'm using excel on Mac. I cannot find a way to import data from Web. (external source) Do you have any advice on how to do this?
Michael Luciano (2 years ago)
+Martin Holsinger As far as I'm aware, you won't be able to do this. You can run macros, but lots of functionality isn't yet added. I suggest installing parallels and running excel on a windows emulator machine.
Dinesh Kumar Takyar (2 years ago)
+Martin Holsinger I don't work on a Mac.
Mohammed Shehata (3 years ago)
Very useful, thanks for sharing,.
OthmanEmpire (2 years ago)
+Mohammed Shehata I agree, thanks for the video indeed
Dinesh Kumar Takyar (3 years ago)
+Mohammed Shehata Great that you found the video useful!
Jay See (3 years ago)
Great Video! Do you have videos for scraping from asp website and php website? Thanks!
sonu ansari (3 years ago)
Hi dinesh...I have scene many video related to vba.please teach us how we can extract data from website from starting...
Dinesh Kumar Takyar (3 years ago)
+sonu ansari Getting data from websites into Excel: http://www.exceltrainingvideos.com/excel-vba/excel-2007-2010-2013-vba/
Amir Toronto (3 years ago)
Hi Kumar, is there any way to get info from a website that needs logging in?
Amir Toronto (3 years ago)
+Dinesh Kumar Takyar Thanks Kumar, I am already impressed by your generosity in sharing these information,god bless you.  I was able to write my code in a way it opens the browser,input username and password and click the sign in, now I need to find a way to search for a word let's say "Machine" in different sections of the website(multiple clicks) and return correspondence value. Generally do you recommend VBA for these type of scraping as it just simulate human actions on a browser (I am not sure if there is a way not to connect through browser)? If not, are you familiar with any other programing language for data scraping?
Dinesh Kumar Takyar (3 years ago)
+A Khajavi Baj Have a look at this video: https://www.youtube.com/watch?v=kdD2bb4DU6c
Walking The Dog (3 years ago)
thank you for this video. this is very helpful. i am just starting with data mining/scrapping work
Sam Haider (3 years ago)
Hi Dinesh, I need some serious expert help. Can we do a skype chat? soban.haider6
Amar Habeeb (3 years ago)
Hi Sir. Thanks for your videos. Can I have a video where we can use macros to open the list of websites and unlock them with the passwords assigned to them and download excel reports from those websites using the criteria mentioned in the excel file (like specific date, report, category etc)
Dinesh Kumar Takyar (3 years ago)
+Amar Habeeb Watch the web scraping videos.
Raymond Tinney (3 years ago)
Thanks for this, quite helpful
Raghu Ram (3 years ago)
thanks dude it helped me
Shaik Thanesha (3 years ago)
Thanks!! am going to apply same logic and try Appreciate your support
Shaik Thanesha (3 years ago)
Hello sir!! i have a Q, i use webpage where i have to login with id an password and copy A2 from excel sheet and paste in search box in web page and hit enter and copy the data which it display and paste in the excel sheet after A2 (i mean in B2). can you please let me know the code please
Dinesh Kumar Takyar (3 years ago)
+Shaik Thanesha http://www.exceltrainingvideos.com/how-to-login-automatically-into-website-using-excel-vba/
Ajit T (3 years ago)
Sir,How to delete hidden rows in Excel 2010. I have a data which have a hidden and not visible.But when i copy and paste special it appears in the sheet.How to delete it?
Ajit T (3 years ago)
Sir,I can see the row and column numbers they are not hidden but hidden data is not visible.But when I do copy and paste/special then hidden data gets copied.
Dinesh Kumar Takyar (3 years ago)
+Ajit T http://www.exceltrainingvideos.com/hide-unhide-columns-rows-ms-excel/ Select the 'unhidden' data and delete it!
sadmanaryfin imran (3 years ago)
thnx a lot sir
nanang mardiono (3 years ago)
Dear Mr Dinesh Can we import data from different sheet of excel with imacros for otomation? tks
Dinesh Kumar Takyar (3 years ago)
+nanang mardiono Please have a look at this web link:http://www.exceltrainingvideos.com/tag/get-data-from-multiple-worksheets-in-multiple-workbooks-into-master-workbook-with-vba/
Trần Thanh Bảo (3 years ago)
Very helpful video,i need to get a URL link in website,not only table,i mean something like "www.xxxx.com",not "website",any one have solution for that? And one more question,the users have comment in this video look like from indian, why not you guy comment in Indian instead English(no offense,it is very convenient for me or others but it is confused)
0110patriot (3 years ago)
Great tutorial thanks a million for teaching us how to automate scraping data via Excel !!
Sherard Horne (3 years ago)
I know that this is an old post, but how do I scrape the data to one tab or into one file instead of multiple tabs. Also, when I look at the source code, it doesn't give a .html extension. Can you help me with figuring this out?
Marulam Tobing (3 years ago)
Very useful. Thank you.
College Ranking System (3 years ago)
how can we get the data from only review section of a particular website ?? and their are multiple pages in review section within a paricular page so how it is possible ?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.