How to Create a Web Query in Excel to Get Current Data
Loading...
Loading...
4:02
Using Excel as a Databaseby HugoPhongPresents4,272 views- 5:42
Export data directly into Excel from a web page in IE7by bytebodger17,156 views
- 1:43
Too Sexy - Citibank Fired NYC Bankerby WithoutDeviation704,773 views
- 2:06
Using Excel 2007 to grab live data from the web x264by AperioITA5,761 views
- 1:37
Converting Excel into HTML for your websiteby boyddesign770 views
- 1:00
Extract Data From Web Macroby tristanbaluyut3,139 views
- 4:13
How to transfer data from internet into Excelby jksynergyworks15,488 views
- 4:18
Extract Data from Web Pages into XML, Excel (CSV), RSSby YummyVegetables1,058 views
- 5:42
MS Excel :How To Import Data From Web to Excel (English)by excelmadeasy599 views
- 4:09
Excel 2010 Web Collaborative Authoringby ipalangio1,112 views
- 9:20
scrazzy.com - a Google and Bing search helperby scrazzydotcom811 views
- 6:54
Creating Database Queries with Microsoft Excel & Sage MAS 90 ERP Part 1by InfoSystemsMgnt629 views
- 5:24
Query Builder and Excel Demoby sunsetreports579 views
- 2:48
New Database Query Excelby zacharybk10,353 views
- 4:32
Using Web queries in Excel 2010by innovativeteach845 views
- 5 videosQuery
- 2:40
Retrieving Web Service Data into Excel (Part 1 of 2)by SpreadsheetWEB3,331 views
- 8:05
Creating Database Queries with Microsoft Excel & Sage MAS 90 ERP Part 4by InfoSystemsMgnt389 views
- 1:38
Como usar ms query excelby hirokaishi3,467 views
- 8:51
Obtaining Stock Prices in Excelby bigpicturetraining10,756 views
- 7:16
Excel VBA Pull Data From A Websiteby DontFretBrett5,565 views
@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
DannyRocksExcels 6 months ago
IS it possible to fetch non tabular data from a web query. Html pages (frames) without tables
msbharanicharan1984 6 months ago
@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
DannyRocksExcels 9 months ago
hi danny,
i am trying to apply the same technique for a website., but its not updating. the values are blank. i think they are java script tables, not html tables. can u help please.
arunprsdvr 9 months ago