MS Excel - Import Live Data From Web to Excel

Hello, this video will look at how we

import

data

from different resources like internet which is web based and we will also look at how to

import

from Notepad. Let's look at the first one, suppose you want to get

live

cricket. scores in your Excel without opening the browser, this is possible. If you want to check the Finance shared values ​​in your Excel without opening the browser, it is also possible, let's see how we can do it. You need to have the URL of some website, which is dynamically changing, let's see now if I open a browser, I have the name of a website which is a quiet date and time and if you see the current time which is running right now, it's sure 1920 156 seconds, this number this time is changing automatically if you see what I'm going to do is change this

data

.

I want to get this data into my Excel, so the first thing is you need to have the URL. I'll just copy the ctrl C URL, copy the ctrl C URL and minimize it. and now what I'll do is I'll go to a blank sheet where I want to paste it and I can go to this insert tab or I can go to this data tab and you'll see there's an option to get external data. I can get external data. data from different resources one is Microsoft Access from the web from text, so I will select from the web now it will give me a browser.

This is a private browser for Microsoft Excel. I need to paste the URL and click on this Go button so first I need to remove this junk link which is given here and I will paste it using control V which is a website that I have and after I click on Go and it loads, it takes time to load here, yes once its done what will happen? Do you see the offset, so it's at the same time 19 23 0 1 that's changing the data now? So what I can do is pick it up now. It says that there is a single line wherever this type of checkbox appears. click on that, click on the checkbox next to the table you want, now on some websites you can get little boxes like this.

I'll just click on that now, if you see this data will be imported into my Excel, the

live

data will be imported like This is like this on some websites, little boxes appear and you get that kind of check box from it. You can select it and use it right now. I have this one, so I've selected the second thing: you have to click import, right. I'll just click on this import and it will import right after that dialog box, it will ask you what location you want to store. Do you want to store to this location which is the existing one, which is dollar for dollar or do you want to paste to the new one? worksheet right now I want to paste it here because it's a blank worksheet and I click OK and it's getting data from that website so you'll see it's data that I have and I'll show you some data that's dynamic here changing time of the data. and date, time and date, okay and I'll check it.

There is a time that is changing. Yes, so I have it. I will maximize. I have that time that is changing. Now, if you see that the time is 1923 54, that 7:00 p.m. 7:00 37 23 p.m. now look at this 723 p.m. so if I go to this data tab and click on refresh, it has an option like refresh, so see the time will change 723, it will change refresh, then you will see this sum option, you will get it, you will see this change from 1923 to 1924. and 40 again, you keep updating, it will change, see 48, so now I have to do it manually.

Is there any setting that I need to get live scores like I said or lifespan that is changing now so I can do it? If you hold your cursor, you will see that there is a properties button that cannot work if I hold my cursor here, that is, in this place, these properties will be disabled and if I hold my cursor here, it will be enabled. I'll just click on this properties dialog, this dialog if You see, here it's written something like refresh every 60 seconds by default. I'll click on that place that I don't want. I can't wait 60 or 60 minutes.

I have to wait a minute, that's the maximum. I can wait and I'll click. Well now the time is 19 24 48, if we just wait for a minute you will see the time change automatically so you can get the live cricket scores. You know you don't have to go to the browser, click on that link and select the country versus which one is working or you can also, you don't have to go to the stock market website, you can get everything calculated right here, so every minute will refresh the data, so when it shows you the refresh at the bottom, if you see, there is a message telling you to get data from the website somewhere.

You will receive the message here. Let's see, wait a little more, say 30 seconds, it will be displayed automatically. Now, the next topic, meanwhile, we'll look for that from Notepad after this. We will see how to get notepad, suppose some person changes some data on desktop or some location, something that you automatically changed in your

excel

file, the data will change, so this setting we can also do with option from the notepad that will be available here, which is in this place from the text, so let's see first, yes, so you see that the time has changed automatically.

Now it says this 1926-27, so we waited for a minute and automatically the time changed. This is very useful for people like financial background who use a lot tried to calculate how many shares they have sold what is the profit they made and so on all the calculations now next thing is how do I get something from notepad. First thing is you should have a notepad on desktop or some other location I have a notepad file which is my notepad file and the file name is my notepad file double click and open there a written sentence what is the sentence that I have written that is one of my favorite parts a coat of mine that works in such a way that the presence and absence are felt.

What I want is to copy this line into my Excel and if I keep changing this data and my acceleration it should change automatically so I'll close it first. Remember. the file name, my notepad file and the location is desktop, so I'm going to go back to my Excel here, that's my Excel here and now, how do I get it? Go to the data tab, click on this to get external data and you will see there is an option. from the text, so from the text, what text you have the location. I have the location. I'll click on the desktop on the desktop, that's my notebook file, click on the notebook file and click import.

Now you remember that they are text to text to columns options where you get a text and you can split it into two separate columns. The reason is that sometimes you don't want forty fifty thousand lines in a cell. You want to split it into different columns. Now I want in the same column. I do not want to do anything. just click on this finish and I'll get the same line. Now it will ask you where do you want, do you want on the same sheet or do you want on the existing worksheet. I'll see it on the same sheet, click OK and you'll see. it says the same line, I have it here, walk in such a way that its presence and absence is filled now what I want is I want if the data changes on the desktop, it changes automatically, same thing if I click right now. go manually and change it there so I'm going to go to the desktop click here and delete all the work but make sure it works smart but make sure it also works smart and I'll close it it allows saving so I've changed the proverb, let's go back to Excel, let's go back to Excel in this place, yes, now the text is written here, the same text, do I need to update it?

Yes, I need to update it, but when I update it asks me: import a text file, why? question import file I will cancel it again if I click update. What happens is if I click update it asks me which file do I want. I want to update, so that's not what I want. I want my work to be saved, so what I'll do is keep the cursor at the location where I imported the data. Click properties. You will see that there is an option like message. for file name when updating, why should I do that? I don't want you to know.

The dialog box will appear. I'll remove that option and click OK. That's it and I just have to click Refresh to refresh and the text changes automatically. Click Update automatically. It requires change, work hard but work smart. You know, make the whole table auto-fit, so it's been split up somehow, so it's not there. This is how you can change data dynamically from the text notepad. Similarly, I have other options which is available here from access from other sources, you can do it like this from access from other sources which are available, there are many options available here, so this way now you can also keep a timer here, the last thing I'm going to show you here if you keep clicking on properties, you can ask them.

I want to update every 1 minute, not 60 minutes every 1 minute, click OK so that anyone who is sitting, if they are on the shared Drive network, if it continues to change automatically, you can get an update in the Excel that is interconnected like this which I think I hope you understood how to import data from notepad and from the web, that's all for this video.