HomeОбразованиеRelated VideosMore From: Tutorials Point (India) Pvt. Ltd.

MS Excel - Import Live Data From Web

3708 ratings | 264248 views
MS Excel - Import Live Data From Web Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Html code for embedding videos on your blog
Text Comments (195)
Govind Gagrani (1 day ago)
Dear brother when I am import Data from nsc site by from web it's show one message in Data old up to 2 days and when. I refresh it not come latest Data please help... Before its correct but last 2 days it's come.. Also refresh but not change in data
M. Wasim (1 day ago)
Hellow i ned ylur help in excel
Arun NH (2 days ago)
How can i calculate GOOGLE distance between two points using latitude and longitude
Raunak Nagardhankar (2 days ago)
Awesome and Very nicely explained and kept it very simple for understanding. Thank you very much and keep it up....
Ivo Mekolle (7 days ago)
Nicely demonstrated
jalal tamboli (8 days ago)
just like this can we live export to website
Shivender vishawkarma (9 days ago)
Thx bro soo help full
Sarfaraj Khan (9 days ago)
Sir thank you so much for your lovely effort But sir I have one query I can easily get the live cricket data into my excel sheet But queries is I want to see fully scorecard into my sheets For example which batsman is currently batting, which bowler is bowling, Who bowled last over, and last over something like that Is it possible for us to get fully cricket score data into our sheet
suraj aggarwal (10 days ago)
sir this was really helpful ...god bless you
Neil M (12 days ago)
Request you to make a video on how to create an account on Onedrive and Dropbox, then how to create folders and share the same with others.
Navin Dhanapal (14 days ago)
If cal 9035483135
Navin Dhanapal (14 days ago)
Hi this Navin... what How can I copy the formula/value from one column value to next page row wise I required. Please help on this...
Ismail khan (14 days ago)
sir good evening really impressing lecture ,one thing i want to ask about your one video regarding data validation.my question is that how can we connect data of 3 different sheets in to and i want to scrolling up and down to see each year separate record.Thanks
Irfan Shaikh (18 days ago)
You are best..
Babar Qureshi (19 days ago)
Sir I want to connect my Excel file with SAP live server like stock status report/reflect in my excel. Can you please guide me.
karthik gowda (22 days ago)
Is this possible in Google sheets?
Sandeep Meka (22 days ago)
Hi Sir, How to import nse live data in excel with below 1min auto updation?
Technical Portal (23 days ago)
So much informative video .. thanks for this video .. I'm being inspired to make new videos on my channel also by watching your video .. Keep it Up.. !!
Dipalee Jain (1 month ago)
How to make marksheet,electricity bill,salary sheet in excel
Dipalee Jain (1 month ago)
K. MASTREX (1 month ago)
Do you ever reply back to people queries.
narayan modi (1 month ago)
How format the bank statement in excel sheet
Nabanita Pal (1 month ago)
After pasting the url and clicking on GO in the dialogue box, getting the script running error. I am using excel 2007. Please help me to solve this issue.
shaikh nargis (1 month ago)
hi i am using ms excel 2013 , how to import data from web its showing some error please help me sir
K. MASTREX (1 month ago)
Specify the error...
Gane Ganesh (1 month ago)
Dear sir, can I use this option to secure websites? Like a Individual user id passsword websites. Because it's logout automatically. How can I use such websites?
Sadikur Rahman (1 month ago)
Thanks. Can u provide me auto backup option. It means as for example if I worked in a specific excel file a backup is working to another location with specific refresh time.
Samier Shewale (1 month ago)
how to remove unwanted data, if i removed unwanted data on every refresh unwated data comes back, is there any option apart from hiding
K. MASTREX (1 month ago)
If you remove data after you refreshed from the main sheet then it is removed just till the next refresh occurs. If you want to remove it permanently then you have to go to "Query Editor" to edit your created query. Add some steps at last to remove your unwanted data.
Sushil Kumar (1 month ago)
I have a computer institute, I want to install same type of your touch screen , how to get it, kindly reply me for complete setup cost. Thanks
The Man (1 month ago)
Madrasi/mallu? Ur accent gives u away..🙄
ABDUL RAZZAQ (1 month ago)
venkatesan a (1 month ago)
Your explanation is very good sir.
HINDI TV (1 month ago)
Isko koi lena dena nhi kon kya pooch rha h
Download Free Software www.themesoxygen.com/apps.php
VINOD TOPIWALA (1 month ago)
Please can you make video to print use define report from Excel database ; Thanks
Salar Nazar (1 month ago)
Informative video. But Man it’s “Desktop” not “Dekstop”
Martin Kuliza (1 month ago)
THIS IS FUCKING COMEDY GOLD The First thing the indian says is.... SUPPOSE WE WANT TO GET THE LIVE CRICKET SCORES LMFAO..... THAT'S FUCKING PRICELESS HEHE (yeah,.... Because that's the first thing on everyone's mind..... We want cricket scores, so WE OPEN EXCEL TO DO THAT hehe......... WTF) i'm in fucking stitches.  I'll be honest, i was not expecting him to say that hehe Now i need 5mins to stop laughing before i can actually pay attention hehe
Gani Jeni (1 month ago)
sir my request I'm working in jockey shop I need to know how to send and type excel sheet can you plz tell slowly so tat I cn write it also n it vl b clear for me please sir
kevalc7 (1 month ago)
I need help with this. I do not have 'get external data' tab on a Mac. can you'll please assist?
M.A Kashem Sorder (1 month ago)
kuldeep tewatia (1 month ago)
please provide some data and assignment with answer after every 3-4 videos,,that will be great for learners and will increase your video audience as well,, thanks
Future World (1 month ago)
https://youtu.be/gA3UtRup4fE. formulas of excel
Ayappa svami songs (1 month ago)
Good informational really helpful. Thank you for sharing with us
Jag of All Trades (2 months ago)
How about MAC
Vikram Sharma (2 months ago)
Thanks sir..or ye dislike kaun krtaa hai yaar...hdd hai
dipesh asmani (2 months ago)
how to import live data from NSE for all the scrips ?????
aman sen (2 months ago)
Sir please explain in Hindi language ,
Pratheesh tom mathai (2 months ago)
How to insert different page numbers in MS Excel
vinod tiwari (2 months ago)
Dhilip Kumar (2 months ago)
How to store data in Excel from firebase database . please make a video sir
Matho Mulud (2 months ago)
I have followed the tutorial and tried to retrieve data from the web but cannot export the data for enlightenment .... this link is https://infopemilu.kpu.go.id/pilkada2018/pemilih/dpt/1/MALUKU/MALUKU%20TENGAH
Kay Jam (2 months ago)
Too good sir thx very much
ndelpurg (2 months ago)
great teacher
Sakthivel Vajjiravel (2 months ago)
I want to become like you
Kapil Sachdeva (2 months ago)
How can I import from a map on a website?
Juan Dela Cruz (2 months ago)
Great video! But what if I only want to show the cell which contains the time? I tried to deleted the other rows, leaving only the time, and did refresh, but the whole imported data came back.
Samier Shewale (1 month ago)
same problem m facing, dude did u find any solution?
Nikhil Gohel (2 months ago)
while getting the data from web, we are getting all the data from that table. is it possible to just get the time and no other data.
gururaj patil (2 months ago)
hi, can you help in getting these live data into MS Access, please mail me personally.
Srinivasan N (2 months ago)
When I am entering "go" button, error message is coming "script error" How to solve this?
Dhineshkumar Rajavel (2 months ago)
nice i really liked it but unable to update web data shows some error
Namma uru kaathu (2 months ago)
For very use full
Namma uru kaathu (2 months ago)
Rahul Garad (2 months ago)
Sir, Do u provide classes in pendrive?? If yes, plz give me details
Rashmi Patil (2 months ago)
Hello,sir... meze asi inverntory report banani hai jise stock bhi match ho jaye or final product bhi ( for Exp. muze 1 PEN banaba hai to uske liye lagne wale loose matl or final PEN product tally ho jaye , Jaise tally me BOM hai waise excel me kaise karu ?? pls suggest me or excel me format kar ke dijiye ... kindly request
Calvin Wiseman (2 months ago)
Awesome video...
Zsolt Nagy (2 months ago)
wow thank you...that helped me quite a lot
Salman Khan (2 months ago)
I tried few times but it hang my laptop so what to do to solve this problem,is this happening for laptop capacity or anything else?
Sajid Editing Zone (2 months ago)
disply ta jaitai touch kortasan oita ki jinis
Aashish Meshram (2 months ago)
Suphal Kumar (2 months ago)
Nice collection Sir
pyraniha sakthivel (2 months ago)
hi sir your explain very good. how to solve this error ''''''' An error occurred in the ‘’ query. Expression.Error: The column 'Date' of the table wasn't found. Details: Date '''''''''
Ravindra Pawar (2 months ago)
Good English speaking please learn videos
Apurba Baruah (2 months ago)
shepherd mukamo (2 months ago)
Is it posible to auto update into the mysql database. Great video
Shantanu Paul (2 months ago)
I have a scaned MCQ question paper in text format. Now I want to get Question, Option1, Option2, Option3, Option4 in excel sheet. How can I do this....?
Lyle Ruthven (2 months ago)
Hi, I have a question about importing tables from the web! My issue is that I’m trying to import a sports standings table and link each teams wins and losses to another table. My issue is that when the standings change the data that I’ve linked becomes wrong as now it’s a new team in the spot that I made the connection with. Is there a way to format web data so that it only refreshes a certain part of the link or freeze the cells so they can’t move??
omar arafat (2 months ago)
thanks ,for good information,
ASHISH KUMAR PATHAK (2 months ago)
On What platform and with what tools is this video made?
Anie Johnson (3 months ago)
Can you please help me import LastPrice and MarketLot data from this site "https://www.nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuoteFO.jsp?underlying=ITC&instrument=FUTSTK&expiry=27DEC2018&type=-"
Digital Electronics (3 months ago)
Sir, very good video, please let me know, how to save them automatically?
KHUSHBU SAINI (3 months ago)
Great job
emad aref (3 months ago)
excellent .
suresh prabhu (3 months ago)
Nitai Barman (3 months ago)
what is this display size and price? please reply!
ping yin (3 months ago)
Curry flavor English
ping yin (3 months ago)
Carl N. Lund (3 months ago)
WOW, I am winning each and very trade with big lot, thanks god to make me reach, follow the instruction and win from here https://t.co/nxrVq1ATMa .
Beytullah Mijnen (3 months ago)
If you are looking passive income safely then start your mission from tonight and get your desire profit by the world best Forex Trading Strategy https://t.co/sNLZ8FBn1T .
Jack A. McLeod (3 months ago)
I am so much impressed with this creative binary trading app (Link Here >> https://t.co/2nQjFFyekI ). Backed with expertise, this robot works splendid and if not much, brings in decent amount of profits. Thanks so much the team for creating such innovative robot. It’s like a boon to the traders in earning consistent profits .
Muthu Kumar (3 months ago)
Sir, How to get live data from NOW stock trading terminal?
casio casio (3 months ago)
Sumnder Makhijani (3 months ago)
Global news for future children worldwide e⛸❤️😊🏸
ab devillier (3 months ago)
waste video
Kathiravan Vaiyapuri (3 months ago)
Great help like me
uzair hasan (3 months ago)
Great Brother
AnandNerre (3 months ago)
Seriously i learnt lot from ur videos, thank you so much
A. K. YouTube people (3 months ago)
Sir it's great thanks you
Ashutosh Singh Rajput (3 months ago)
bhai hindi bola karo yaar
Akhil G (3 months ago)
Hi, i had tried for import data from a website, but it shows some error message, can u please help me out with it...
ASHISH MARWAHA (3 months ago)
Excellent Practical mind.
MY SHOPE (3 months ago)
hi i am using office 365 , how to import data from web

Would you like to comment?

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