[Autogenerated] high in this lesson. I'm
gonna show you how to export a SharePoint
list to excel. Let's go ahead and let's go
to our employees list and we want to take
this list and move it into, except we're
going to go ahead and create a New Excel
workbook. With all the information from
this list, you can see here the top. We
have a big button that says Export to
Excel. That looks like a place to start.
So let's go ahead and let's click on that.
Once we do, we get this pop up down here
at the bottom. That asks us, What do we
want to do with this query? We want to
open it, save it or cancel, but we're
gonna open it up. We're gonna click there.
And when we do that, it opened up Excel.
And in our Excel workbook here we now have
this security notice, and basically this
is telling us that things that come from
the Internet might not be safe, but we
trust our SharePoint. We're okay. So we're
going to enable that connection and look
at that. It brings back all of this data,
all of that entire SharePoint list here
into Excel. Pretty nice. Let me get rid of
this now. We want to go ahead and we save
it. We're going to click on the little
Save icon and we will save it as employees
and we'll save it to Olivia's one drive.
That's perfect. We'll click save, and once
it's done, there we go. It turned the auto
save on. I got it and we will close it Now
that we've exported this SharePoint list
into Excel and we save that workbook,
we've created a connection between the
two, but it's only a one way connection.
So what does that mean? If we make a
change here in the SharePoint list, that
change will be reflected in the workbook,
but not the other way around. If I go
ahead and make a change in the workbook,
it's not going to update the SharePoint
list. Let me show you. We're gonna go
here. We're going to select the first
record Michael Callen final. We'll click
on edit and we're gonna go and let's say
he is no longer a sales associate. Let's
say we have moved him into the accounting
department and we've given him a raise to
$21 an hour. Go ahead and click Save. We
see that that has been changed here in the
SharePoint list. Now let's go ahead and
let's go to Olivia's one Drive and open up
the workbook and we see that Michael is
still listed as a sales associate at $9.24
an hour. And you're thinking, what gives?
Don't panic. We need to go to the data tab
and click, Refresh all. See that? Now it
changed. You have to refresh the
connection. Unfortunately, like I said, it
doesn't work the other way. If we go ahead
and change Joshua Hartson here, we're
gonna move him into accounting as well.
And we'll give him a raise up to $21 an
hour. And we don't have to say because the
auto save is on. But we're ready to go.
Will simply close that up. Go back to a to
SharePoint, will refresh the page, and we
look and we see that Joshua Hearts and
it's still a sales associate, still making
$11.60. So that's what I was talking
about. It's only a one way connection. It
doesn't work both ways. But now you know
how to export a SharePoint list into
excel. Thanks for listening, and I'll see you next time.