[Autogenerated] high in this lesson. I'm
gonna show you how to create a SharePoint
list from an Excel spreadsheet. We're here
on our HR team site. We're on the home
page and we're gonna go over here and
click on the new button. Now, when I click
there, we get this list and we're gonna go
all the way down the bottom two app
because SharePoint lists are basically
APS. It brings us here to the your APS
page and we're going to scroll down. And
the very last one that we see down here in
the lower right corner is import
spreadsheet. That's what we're gonna do.
But before we do that, I want to go ahead
and I want to take a look at the worksheet
that we're going to import. So we're going
to go to our documents and it is gonna be
this one intern candidates. It's a list of
potential interns for our company. Now
it's very simple. Excel worksheet. There's
not a lot on it. There's only 30 Rose
worth of data and it just names, address,
email, things like that. It's not been
formatted as a table. There's no named
ranges. It's just data on a worksheet.
Okay, now, another important thing is
before you go ahead and try to import
this, it can't be open. You need to make
sure that this Excel file is closed. So
we're going to do that. Come back here to
our APS page and we're gonna click on
import spreadsheet now. And when we do
that, it brings up the new APP page. First
thing we have to do is give our app a
name, give our SharePoint list a name, and
we're going to call it intern candidates
the same as the name of the worksheet.
Now, it doesn't have to be the same name.
It just happens that that's pretty
explanatory. That's why I'm not even gonna
bother putting a description on. Now, I'm
gonna go down here to the file location
and click on the browse button because now
we have to tell SharePoint which Excel
workbook we want to bring in. So we're
gonna go to browse. We're gonna come down
here and select intern candidates and
click open. Now, before I hit Import, I
gotta tell you something. This is not
going to work. And you're probably
thinking, Why am I showing you this
because I want you to see what happens.
And then we're gonna talk about why it
doesn't work. We're gonna click the import
button and see this. I get this pop up.
That says, This site says this feature
requires a browser that supports Activex
controls. I'm using Microsoft Edge latest
version of the newest browser by
Microsoft. It does not support Activex
controls. Now I'm going to tell you that
we need to use a different browsers. We
can't use Google Chrome because it also
does not support Activex controls. What
are we going to do in that case, you ask?
Well, let me tell you, let's cancel this
first and let's go back here. We actually
need to go to our old friend Internet
Explorer. Yep, that's right. The old
outdated. Nobody likes it anymore.
Internet Explorer. It's still really
useful Gang. Don't dismiss it just because
it's not. The newest and greatest Internet
Explorer does support the Activex
controls. So what we want to do will work
using Internet Explorer. Let's take a look
once again, we're going to go to our new
button click app scroll down to import
spreadsheet. We're gonna give our list of
name and again intern candidates just like
before, will also skip the description,
will browse for the file and choose
intern. Candidates will click open, and
now when we click import, it's Gonna work.
It's gonna be a lot different than when we
did it the last time. Look at that. See
what happened here? It's opened up Excel.
It's open up that worksheet and we get
this window import to win those SharePoint
Service's list. What is the type of range
of data that we want to import now? This
is very important. You see, here it says
table range. We got to select the drop
down because we have three choices. Ranger
sells table range and named range, and it
depends on how your data is formatted in
the worksheet as to which one you choose.
Now, I already told you we don't have a
table in this worksheet. None of our data
has been formatted as a table. We also
have no named range is. All we have is a
range of cells, so that's what we're going
to select now. If it was a formatted table
or we had a named range, we could select
those, but it's just a range of cells.
Now, you see, we have the select range
option. We have to go ahead and select the
range of data that we want to bring it.
I'm going to click on that little button
right there to collapse that dialogue box.
And I am gonna go here in Excel in this
worksheet and highlight. You see, I
clicked and dragged to highlight that
range. Now, if I knew what the range was,
I could have simply typed it in here. And
you see, it is intern candidates. That's
the name of the worksheet and the range A
one through age 30. Okay, now we're gonna
click Import, give it a minute here to do
its thing. Look at that. We have a brand
new list that we brought in from Excel as
a lot easier than entering in all of these
values. All of these items manually, isn't
it? Now, one thing I want to also point
out. Look, over here on our quick launch,
we don't see a link to the new list in the
quick launch. That's because when it
brings it in, it doesn't give you the
option to say yes or no? Do I want to
include this on the quick launch? So what
we're going to do is go to list settings
for our list. Click on list name,
description and navigation. And then down
here, simply click. Yes, I'm display this
list on the quick launch. Well, save it.
You can already see it there, and we go
back to our list. So now you know how to
create a new SharePoint list from an Excel
spreadsheet. Thanks for listening. And I'll see you next time.