Import Data from the Web into Excel

14 Comments on “Import Data from the Web into Excel”

1. what to do if we get an error saying that no data to extract?pls advise

2. A very good video like your accent

   I need help here on the same website
   http://www.soccerstats.com/timing.asp?league=spain

   The problem is excel only gets the data on the "Total " tab, while I need two separate tables for "HOME"and "AWAY"enter image description here

   Excel cannot identify Home or Away tab i click. It just give me the data under the "total" tab.

   How can I get the data under the tab of home and away in this web Plesae ?

3. Hi, thanks for the video. General question regarding time series data. Say for example you have stock market data coming in by the 1 minute interval. Instead of overwriting the excel box, is there a way to create a log for each minute occurrence, thus giving you a one day minute chart by the end of the day?

4. What if the data table you want is not recognized by excel i.e. doesn't have a yellow arrow-box in the corner. I can paste the entire webpage, but I don't want all the junk surrounding it – just the table of statistics. Every time I hit refresh the rest of the page shows back up in excel.

5. What if there are several pages? Like i have link to click next and i have let's say 20 pages, can i automate whole procces?

6. how do you bring data from a spreadsheet cell to an html textarea?

7. Great video, I read the comments and I was wondering if you had an answer for the reason boxes don't show up for some people? I only get boxes to show up at the top left of a site to import the entire page when I only want certain data. This happens for every site I try on my PC. Do you know why this might be? Thanks.

8. im having an issue importing the fantasypremier league website i cant import specific tables instead it only gives me one option that is to import the entire website how can i solve this please help ASAP :(

9. I'm using Fan Graphs but it doesn't let me select the chart on the site. How do I work around this?

10. Until they add in the ability to import specific CSS divs and enclosed content, this feature is outdated and useless to me. If this were an Adobe app, such a feature would have been added in years ago!

11. Computergaga, great video, very informative!

12. is there a way to do this from google sheets?

13. Thx 4 video, its helpfull

14. i really don't understand how can it be that there is no comment on such an awesome vedio. hello sir, i really don't know how to thank u. so awesome u'r upload is. really awesome.

Comments are closed.