8 hours 33 minutes
okay, in this lesson, I'm going to show you how to import data from the page.
And what is important for you to know is that you cannot import the entire we're paging to excel because of the page contains many, many things that simply cannot be shown from
XL. But just import data that we can import from web were were paid directly. Here
it goes to the default home page. So we're not going to the airport this page. We're going to import
cyber a home page,
and we cure Go. So you basically have, like, mini browser opened in the open dialogue,
and now you have options.
You can import it without former thing. You can do it with rich text formatting on Lee and with full HTML for mating.
That means that if you select full HD male former thing, you're going to get the links
imported as well.
Ah, so, uh, three consecutive d limiters is one of an important webpage. Yes, you should use this
and you should disabled. If you quicken disabled data recognition, it will disable some
former thing that will make data in a certain way because they're in a such format in the Web page on and you can disable with Web query re directions, which I strongly suggest, unless you really know what you're doing
and we're going to click, Okay?
And then we just taken import.
And, of course, of course, you're asked where you want to put the data so in herself,
and now it's getting data. And what you see now that it got is, uh,
and it opens when, if we can this it opens a link in
your default browser
You don't see here, But, uh,
we don't want to put a cookie, so we just go there. So you got all the links from the web page, uh, and text from the Web page important in itself.
In the most of the cases, text is not what you need. Sometimes it is,
but in most cases, the lynx is what you need. So you get all these
and they're quite a lot of them because fix everything from the web page.
Now let's make another
yeah, we still cannot
do that because it's importing Still. Now it's okay.
In this case, we're just going toe.
Okay? We can continue. It has opened. Also. Dalek box in Web browser.
So we're going to go toe Web again.
We're going toe click here the same page.
we go there
and then click on options
and we don't any formal thing. We just want the plain text
and we click. Okay,
decide where to put it.
And now you see, this is just the plain text from the website, so it makes sense. If you're, for example, importing some of a page that has some table in it and you want the table,
you can go there. An important table in a plain text format. It will take some time on how to clear up the daytime, and we're going to talk about it. Very so. So this is all about just importing data from different sources