Automated data scraping from websites into Excel

Share
Embed
  • Published on Nov 3, 2012
  • Our Excel training videos on RU-clip cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
    For details you can visit our website:
    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:
    www.familycomputerclub.com/scrpae-pull-data-from-websites-into-excel.html
    www.familycomputerclub.com/get-web-page-data-int-excel-using-vba.html
    Interesting Links:
    www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm
    Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V
    If you are from India you can get this book here: amzn.to/2jzJGqU

Comments • 263

  • All About Web Scraping
    All About Web Scraping 4 days ago +1

    good one sir

  • edit1123
    edit1123 Month ago

    Any way copy some email attachment data paste in excel

  • Vikaskumar Singh
    Vikaskumar Singh 2 months ago +1

    Very informative👍

  • All_In_One
    All_In_One 4 months ago

    Dear sir, I need help. We have website name Safer where we have to fetch client records . And we have to print page 1, page 2, then on other link page 3, 4, 5, 6 etc. Can we programme in Macros for it so it can be fetch automatic and print all pages?

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  3 months ago

      This playlist link will help: ru-clip.net/p/PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa
      Or search www.exceltrainingvideos.com

  • sai sunil
    sai sunil 4 months ago

    excellent video can i know how to get data from cric websites for a cric players while in live

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  4 months ago

      Search this playlist. It will help:
      ru-clip.net/p/PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa

  • Steve N
    Steve N 4 months ago +1

    cool

  • Tafazzul Nadeem
    Tafazzul Nadeem 8 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
      Dinesh Kumar Takyar  8 months ago

      These links will help:ru-clip.net/p/PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa
      ru-clip.net/p/PLFoKoDG_7gtLV_wyhSec18KRFZoPMKgaJ

      Or search www.exceltrainingvideos.com/

  • rajiv kukreja
    rajiv kukreja 9 months ago

    how to pull data from Amazon website of products prices and ratings

  • Steve Shi
    Steve Shi 9 months ago

    Good way, and useful. Recently, I also try ScrapeStorm to scrape datas, and find it's good.

  • Rounak Dasri
    Rounak Dasri 10 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
      Dinesh Kumar Takyar  10 months ago

      ru-clip.net/video/Z2iO5kaavwM/video.html
      www.exceltrainingvideos.com/scrape-web-data-with-google-chrome/

  • Touche Softwares
    Touche Softwares Year ago

    Awesome tools! Congratulations and thank you for sharing this.
    anyone have experiance with this tool? Local business extractor

  • FritzHugo3
    FritzHugo3 Year ago

    Great Video, very thx.
    Question: Is it possible to put Data from Excelcells to send it on a Website (formular...)
    eg. The RU-clip uploading Webpages are totaly terrible. Is it possible to write arguments in excel and then send it to RU-clip 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 RU-clip/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 "RU-clip movie maker" but its not what i realy want.

  • Sakil
    Sakil Year 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
    Miranda Liu Year 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
      Dinesh Kumar Takyar  Year 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
    Niraj Karhe Year 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
    Narinder Kumar Year ago

    Thanks a lot Sir

  • Ank Gangheri
    Ank Gangheri Year 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
    AngelicHugs Year ago

    nice video sir please tell me how to extract specific data like product names of any web sites

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  Year ago

      Search my channel, refer to the playlists or search my website www.exceltrainingvideos.com for a solution.

  • Ankur Verma
    Ankur Verma Year 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
      Ankur Verma Year 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
      Dinesh Kumar Takyar  Year ago +1

      Have a look at this playlist: Scraping Data from Web Pages
      ru-clip.net/p/PLFoKoDG_7gtLJmKm2CUYH40cXvbBCbgOa

  • xSiD0x
    xSiD0x Year ago

    Need exactly this for Excel 2016! Could u help?

  • james pruett
    james pruett Year ago

    can you make a selenium->excel tutorial. I like your teaching style!

  • Oana Cristina Palade

    Thanks you saved me too!!

  • Swarnika Studio
    Swarnika Studio Year ago

    nice video

  • AR077
    AR077 Year ago

    what with data that is constantly is changing like a stock ticker?

  • sri dhar
    sri dhar Year ago

    how to open python output in web browser that fetched from excel document

  • Yemi Adenusi
    Yemi Adenusi 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
    Jurij Fedorov Year ago

    I found a simple table with text. The yellow arrow didn't appear :-(

  • Arif Merchant
    Arif Merchant Year ago

    Can you help me to get NSE India Script price live in Excel, Thanks

  • LEARNING & EARNING

    Any one able to extract database from a ecom site

  • Vineet Sagar
    Vineet Sagar 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
    petufo Year ago

    Great video! Thanks. Is there any way how I can scrape HTML files located on my hard drive?

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  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.

  • Kuchiko
    Kuchiko Year ago

    So helpful..! I'll try this ..

  • Aspire Aspire
    Aspire Aspire 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

    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
      Dinesh Kumar Takyar  Year ago

      What have you tried? Search my channel or website www.exceltrainingvideos.com

  • TheScrpk
    TheScrpk 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
    bollam Hudson 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
    Molly Zuniga 2 years ago

    what if just want to put the data on a new row (keep it on the same worksheet)

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  Year ago

      Find the next blank row and place the data there. Search www.exceltrainingvideos.com

  • rayj12001
    rayj12001 2 years ago

    I have many decades in development and need to do this. Very instructive Thank you for this video!

  • Snigdha Gondwal
    Snigdha Gondwal 2 years 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
    Rabia Tasneem 2 years 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
    shuntian wang 2 years ago

    This is very nice ! I learned something thanks!

  • Marcel Whelan
    Marcel Whelan 2 years 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.

  • raju raj
    raju raj 2 years ago

    but I didn't got how u got the source code

  • haleema sadia
    haleema sadia 2 years ago

    sir I need to extract data from university website can you help me with that ... Regards

  • Pulse
    Pulse 2 years ago

    Hi, is there a way to automate this excel macro to run at different times of the day? Example every half an hour?

  • shahab khan
    shahab khan 2 years 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
    Harsh Singh 2 years ago

    How Can Extract Number Of Comments From The Number Of Blog Post URLs?

  • Himanshu Baurai
    Himanshu Baurai 2 years 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
      Dinesh Kumar Takyar  2 years ago

      This link will help: www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/
      Or do a search at www.exceltrainingvideos.com

  • Arun kumar P
    Arun kumar P 2 years ago

    thank you

  • Neeraj Doriya
    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
    Dev Yadav 2 years ago

    great vedio.question how to extract data from multiple pages.like page 1 ,2,3.....

  • Maica Tran
    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
    Vinu Vish 2 years ago

    hi sirhow can i scraping data from following link
    apps.coachfederation.org/eweb/CCFDynamicPage.aspx?webcode=ccfsearch
    please help me sir

  • Paras Thakur
    Paras Thakur 2 years ago +1

    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
      Dinesh Kumar Takyar  2 years ago

      This link will help: www.exceltrainingvideos.com/automate-scraping-of-hyperlinks-from-web-pages-using-excel-vba/
      You can also do a search at www.exceltrainingvideos.com

  • brianxyz
    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
    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
    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
    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
      Dinesh Kumar Takyar  2 years ago

      This link will help: www.exceltrainingvideos.com/tag/find-last-row-column-cell-in-an-excel-worksheet-with-vba/
      For more solutions search www.exceltrainingvideos.com

  • Amitha Mai
    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
    andreikilla 2 years ago

    Thank you for video, would you know how do I avoid scientific notation when doing this process??

  • Yinyan Guo
    Yinyan Guo 2 years ago

    Dear Dinesh, do your method can be used to extract hotel price of some hotels from www.expedia.ca/Hotel-Search?#&destination=Quebec,%20Quebec,%20Canada&startDate=06/11/2016&endDate=07/11/2016®ionId=&adults=2, please let me known. Many thanks

  • Suprabha Pandey
    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
      Dinesh Kumar Takyar  2 years ago

      This link might help: www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/
      Or do a search at www.exceltrainingvideos.com

  • Bob Arnold
    Bob Arnold 3 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
    Diwas DIP 3 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
    Dj MaCz 3 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
    John Coester 3 years ago

    Hello- Can my company hire you to help with gathering data?

  • Taylor Sharrock
    Taylor Sharrock 3 years ago

    Amazing! Thank you!

  • wikiteli
    wikiteli 3 years ago

    Hi Do you have any idea to collect/scrape data from this type of site its contain almost 20,000 agents.

  • John Sundararajan Jayaraj

    very simple and informative video. Thanks for posting

  • K D'Arcy
    K D'Arcy 3 years ago

    Thank you for posting

  • Lorenzo Palumbo
    Lorenzo Palumbo 3 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
    Pablo Evia 3 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
      Dinesh Kumar Takyar  3 years ago

      +Pablo Evia Wow!

    • Pablo Evia
      Pablo Evia 3 years ago

      +Dinesh Kumar Takyar Thanks, I actually included 'On Error Resume Next', and it worked perfectly!

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  3 years ago +1

      +Pablo Evia You can use an If statement like - If URL="" then exit sub

  • Dhanamma Jagli
    Dhanamma Jagli 3 years ago

    very useful

  • The Indian Freelancer
    The Indian Freelancer 3 years ago +1

    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
      Dinesh Kumar Takyar  3 years ago +2

      +ZeroViewsChannel www.exceltrainingvideos.com/scrape-data-automatically-from-websites-into-excel/

  • Thomas Witte
    Thomas Witte 3 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
    Kalyan Teja 3 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) www.synventive.com/ContactUs/Default.aspx?id=330
    www.achaogen.com/
    www.alexza.com/
    ambrx.com/
    Thanks in advance.

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  3 years ago

      +Kalyan Teja This link might help: ru-clip.net/video/BY-1nihCzYU/video.html

  • Open Warner Robins
    Open Warner Robins 3 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
    Mohammed Alam 3 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
    Ricky Stewart 3 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
    Mark Arciaga 3 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
    Jamez D 3 years ago

    Superb! Finally answered my question of ponderous theories!

  • nmlker
    nmlker 3 years ago +1

    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
      Helena Avila Arias 2 years ago

      Did anybody ever find out how to do this?

    • Cristiano Bellavitis
      Cristiano Bellavitis 3 years ago +1

      +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
      Ryan Ip 3 years ago +1

      +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
      Dinesh Kumar Takyar  3 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
    NittanyNation22 3 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
      Dinesh Kumar Takyar  3 years ago

      +NittanyNation22 Check these helpful links:
      www.exceltrainingvideos.com/scraping-web-page-data-automatically-with-excel-vba/
      www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/
      www.exceltrainingvideos.com/scraping-web-page-tables-data-using-vba/
      www.exceltrainingvideos.com/complete-automation-of-getting-web-page-data-into-excel-worksheet-using-vba/
      www.exceltrainingvideos.com/automate-scraping-of-hyperlinks-from-web-pages-using-excel-vba/

  • Vijayalakshmi Sriram
    Vijayalakshmi Sriram 3 years ago

    Very well explained..but will need a bit of practice too!!!

  • Steven Thibault
    Steven Thibault 3 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.

  • UnCommonVision
    UnCommonVision 3 years ago

    Does this also work with Google Sheets or OpenOffice Spreadsheets?

  • Martin Holsinger
    Martin Holsinger 3 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
      Michael Luciano 3 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
      Dinesh Kumar Takyar  3 years ago

      +Martin Holsinger I don't work on a Mac.

  • Mohammed Shehata
    Mohammed Shehata 3 years ago

    Very useful, thanks for sharing,.

    • OthmanEmpire
      OthmanEmpire 3 years ago

      +Mohammed Shehata I agree, thanks for the video indeed

    • Dinesh Kumar Takyar
      Dinesh Kumar Takyar  3 years ago

      +Mohammed Shehata Great that you found the video useful!

  • Jay See
    Jay See 3 years ago

    Great Video! Do you have videos for scraping from asp website and php website? Thanks!

  • sonu ansari
    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
      Dinesh Kumar Takyar  3 years ago

      +sonu ansari Getting data from websites into Excel: www.exceltrainingvideos.com/excel-vba/excel-2007-2010-2013-vba/

  • ATO Tv
    ATO Tv 3 years ago

    Hi Kumar, is there any way to get info from a website that needs logging in?

    • ATO Tv
      ATO Tv 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
      Dinesh Kumar Takyar  3 years ago +2

      +A Khajavi Baj Have a look at this video:
      ru-clip.net/video/kdD2bb4DU6c/video.html

  • WalkingTheDog
    WalkingTheDog 3 years ago

    thank you for this video. this is very helpful. i am just starting with data mining/scrapping work

  • Sam Haider
    Sam Haider 3 years ago

    Hi Dinesh, I need some serious expert help. Can we do a skype chat?
    soban.haider6

  • Amar Habeeb
    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)

  • Raymond Tinney
    Raymond Tinney 3 years ago +1

    Thanks for this, quite helpful

  • Raghu Ram
    Raghu Ram 3 years ago

    thanks dude it helped me

  • Shaik Thanesha
    Shaik Thanesha 3 years ago +3

    Thanks!! am going to apply same logic and try
    Appreciate your support

  • Shaik Thanesha
    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
      Dinesh Kumar Takyar  3 years ago

      +Shaik Thanesha www.exceltrainingvideos.com/how-to-login-automatically-into-website-using-excel-vba/

  • Ajit T
    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
      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
      Dinesh Kumar Takyar  3 years ago

      +Ajit T www.exceltrainingvideos.com/hide-unhide-columns-rows-ms-excel/ Select the 'unhidden' data and delete it!

  • sadmanaryfin imran
    sadmanaryfin imran 3 years ago

    thnx a lot sir