How to Create a Web Query in Excel to Get Current Data

Video quality	The size	Download

Information How to Create a Web Query in Excel to Get Current Data

Title	:	How to Create a Web Query in Excel to Get Current Data
Lasting	:	6.12
Date of publication	:
Views	:	264 rb

That's a lot of tool bars
Comment from : Aaron

It's a pity of that annoying clicking in the background It made me stop watching this interesting video
Comment from : Hans Ket

I can't take any computer advice from a guy with 50,000 spyware toolbars, sorry brotatobrbrbr brjdiscount
Comment from : mrXzec

How to import this deta in our website ?
Comment from : Rajnikant Singh

Your toolbar gave me AID's
Comment from : Tommy12Inch

Video Starts @ 1:02 (Spare yourself from the Toolbarfs) (realize also that you can follow along without sound I did); The main reason you came here Ends @ 2:16 ; "Edit Query" Context Menu @ 2:30 ; Another context menu option "Data Range Properties" appears @ 3:28 ; Stretching for time by informing people that hyperlinks are a thing @ 4:15, followed by repeating everything he did in the first half ALL OVER like EVERYTHING (Basically if you watched paste 4:15 you re-watched the video unnecessarily)brbrSummary:brStart: 1:02brNormal User Video Ending: 2:16br"Advanced" (not really) Context Menu Tip 1: 2:30br"Advanced" (not really) Context Menu Tip 2: 2:30brAlternative Ending: 4:15
Comment from : GamingPadCentral

Does this not work anymore? Web query no longer shows a view of the website
Comment from : Jesse Newton

those toolbars wtf
Comment from : Nexus

Thanks How do you create the same Web Query on Office 365? The tool bar and the buttons are different there
Comment from : visuarchie

i want to refresh automatically data without opening file can u help me
Comment from : Sushan Tiwari

I am usually searching for the daily exchange rates for foreigners currency from difference web sites and that is take a lot of time !! Is there anyway to choose one item only from the schedule imported to excel sheet , could be USD and on the second line in excel sheet I put a source for update for the same item chosen but from another Webpage or another site to have finally ten difference update for one item (ex: USD ) from 10 or 20 difference sites
Comment from : Muhammed Saadi

TIGER WOODS!!!
Comment from : Hayden Smith

The toolbars though
Comment from : Helius

Somehow I get script error
Comment from : O H

How can I automate excel sheet to download a zipped folder containing csv file and and extract the csv file into a sheet The data changes everyday and so does the folder name and file name Your support would be much appreciated Thankyou BJ
Comment from : Bhaskar Jalan

how to give a cell reference in place of the addressi hv a cell lets say A1 which has url,now i want that cell to be called each timeplzzz if anyone knows kindly rply
Comment from : Rohit Patnaik

Great information Thanks for sharing
Comment from : Eric Hamilton

This is the most useful video I have ever watched!
Comment from : Mike Monticue

how can i do this same exact thing, but download the csv table from yahoo finance direct to excel? "+Danny Rocks"
Comment from : nyc2cuse

Good Lord man! Tool bars are known poison and you went and got the value pack from Costco I wouldn't trust you to pet sit my pet rock
Comment from : Dave Newman

i cant get, the whole thing is that when i copy the url after to that says an dialog box brin that it says an error occured in the script on this page brin brief is says 'parrent()get()' is null or not an objectbrcan you please brief and resolve my problem???????????
Comment from : Pintu Pramanik

I'm amazed by the amout of toolbars you have
Comment from : Henrique Giacometti

Web Quary stoped to work, herebrWhat can I do to fixa that, please?
Comment from : Marcelo Ribeiro

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 :(
Comment from : The NetFreak

My problem: I don't have yellow arrows next to any tables (just one at the top of the entire page) but a friend does He can import that specific table but I cannot Any help as to why?
Comment from : NittanyNation22

I can't take any computer advice from a guy with 50,000 spyware toolbars, sorry brotato
Comment from : jdiscount

Also can you share how to update your browser in Excel because I have sites (ESPN) that it claims the browser is out of date I am using excel 2007
Comment from : Joe Knoepke

Can you please share with me why sites for me (what you are showing in the examples) are giving me script errors and/or no yellow tabs? I am growing really frustrated with this process because it just doesn't seem to work for me
Comment from : Joe Knoepke

Danny, is there a way to query the web for addresses to a list of known companies? I have a list of 49 breweries in Massachusetts - they only list the company names - I want to get their addresses so that I can see more accurately where they are located and assess which ones my company might reach out to regarding our servicesbrbrIs there a way in Excel to program a cell to get external data - (something like "go to googlecom, search for text in cell A2, import address, company url, and phone # into respective columns in Excel sheet")?
Comment from : Adam Gibbons

what about https data from specific fieldID into excel?
Comment from : Ugis SurnameS

Those toolbars
Comment from : Original Poster

Hi DannybrGreat video, but I can see, that you have the exact same problem as I have When you grab the sports results, the standings turn in to dates You can see in your colimns H,I and J, that the data is converted to dates Changing the rows to text, does not help, since Excel have recogniced the dates first, and will turn the text into datevalues Do you have any idea as how to work that out, so instead of eg mar-01, it would show 3 - 1?
Comment from : Benjamin Fick

What the hell is that noise in the background? It's really off putting
Comment from : Zeelo Laing

Danny, i tried to do what was on the video but the data is pasted vertically on my worksheet (one column)
Comment from : Francis M

Danny Rocks rocks!
Comment from : Phoenixspin

Dude, your toolbar is insane!!
Comment from : Philippe Wisniewski

I am trying to download the data from an httpS site Is it possible that this won´t let me download the data using the Data – Get External Data from web command But when I click on the import button, when it tries to paste information, error message is that the query is empty Any ideas? Thank you!
Comment from : Gatis Felices

thank you Danny :)bri got a question, what if the website requires a password? brsay the data i need is on a different link that requires access, does it work?bri tried it once, so i had my credentials entered and it works if i keep excel opened, but if i close excel and reopen it again, and refresh the data, excel gets stuck in a loop and doesnt get it anymore :(
Comment from : Random Internet Viewer

great video but those toolbars are absolutely hilarious!
Comment from : dr3am000

holy crap this owns
Comment from : mattdh12

Thank you for your feedback Danny Rocks The Company Rocks
Comment from : Danny Rocks

Nice tool bars!!! Where did you get them all?
Comment from : Richard Reyes

great tutorial is there a way to create a web query from web data, which is not html linked or live? I would like to copy large amounts of data from a web page and have it filled into a spread sheet It does not need to update automatically
Comment from : theychosen1

Thank you! I am pleased that you enjoyed my Excel tutorial Danny Rocks The Company Rocks
Comment from : Danny Rocks

Very good tutorial
Comment from : tally online classes

Thanks for your feedback Danny Rocks The Company Rocks
Comment from : Danny Rocks

There are so many comments already on this topic but DEM TOOLBARS
Comment from : rogster99

Okay so I want to go to webpage- its a uk webpage called edubase - enter a postcode and get the reulting table whichI can do from what you showed me but what if I wanted to change the psotcode and get the new table each time? Is there a way to automate this in excel so maybe if I have all the postcodes in a list on the spreadsheet I could loop through each postcoe and get the resulting web table?
Comment from : OriginalJoseyWales

@Danny Rocks Still a great video regardless of the number of toolbars It's always great to learn something new Thank you!
Comment from : Dot Hack

Thank you for your feedback Danny Rocks The Company Rocks
Comment from : Danny Rocks

0:27 - the moment when you see he has 8 toolbars installed
Comment from : Dot Hack

if you would demonstrate how to get twitter search results of a word tweeted in a certain area, say Brussels, from a certain date to another date using the web query in excel it be absolutely great because I've trying this for a month with various methods and it didn't work
Comment from : atmapurusha

At 02:18 I just want the stock quote! Not the whole table How can I achieve this?
Comment from : DamonArizona

how do you this on excel for mac i haven't been able to figure it out?
Comment from : JozuShaka

Hi Wayne - Thanks for your feedback I agree with you I have cleared away the extraneous toolbards Danny Rocks The Company Rocks
Comment from : Danny Rocks

Nice video but your browser is full of useless tool bars And it looks very ugly and unprofessional Also i see two of them that logs and tracks your browsing and sends it back on the net
Comment from : HooKed One

Hi, Great presentation skills Thanks What should be done if the data in the web page runs to several pages ? How do we extract data from website if the same runs to several pages ?
Comment from : Srinivasa Sarma

My pleasure I am happy that you found this tutorial helpful Sincerely, Danny Rocks The Company Rocks
Comment from : Danny Rocks

thank you very much very very helpful
Comment from : alisalih

Thanks for adding your comment I went back and took a look at this video and I agree, when I filmed this tutorial, I was not paying as much attention to the number of Internet Browser Toolbars that had been installed Thank you for bringing this to my attention Danny Rocks The Company Rocks
Comment from : Danny Rocks

0:36 do you really need that many toolbars? It's covering like half the screen How does that not bug the hell out of you?
Comment from : Xerriva

hi danny, I am using Microsoft Excel for Mac 2011, I can't find the "From Web" tab in the sheet, I can see "Text", "Database", HTML" and "FileMaker" Any suggestions When I click the HTML it's not going to any web page Thanks for your information and appreciate your time and help
Comment from : dingdoorz

My pleasure! Thank you for adding your comment I am happy that you found my tutorial helpful Danny Rocks The Company Rocks
Comment from : Danny Rocks

Thank you! I am pleased that you enjoyed my tutorial Danny Rocks The Company Rocks
Comment from : Danny Rocks

Super
Comment from : zuluvadharah

@msbharanicharan1984 No, this is not possible on a public website You need to look for the HTML Table Tags that are defined with Yellow Boxes with Black Arrows Some websites - usually intranemts - may allow you to import XML Data More of these are showing up I wish that I had a better answer for you at this time Danny Rocks The Company Rocks
Comment from : Danny Rocks

IS it possible to fetch non tabular data from a web query Html pages (frames) without tables
Comment from : Bharani charan

@arunprsdvr Can you tell me the website that you are trying to search for this information? You can send the URL to my email address - danny @ thecompany rocks dot com (YouTube sometimes frowns on including email addresses and URLs in responses Danny The Company Rocks
Comment from : Danny Rocks