[Autogenerated] Hi. We're here today in
our office 3 65. And in this lesson, we're
going to take a look at how to create Ah
SharePoint list from an Excel table. One
of the great things about SharePoint, of
course, are the SharePoint lists. They
could hold a lot of data, and in a lot of
ways, they're very much like an Excel
table. They have a lot of data, and
there's a lot of things you could do with
it. We're gonna go to this site, our sales
team site, and this is where we're going
to create that new SharePoint list. Now
the great thing about SharePoint lists is,
of course, they could hold a lot of data.
The bad thing is you have to enter all of
that data. But if that data exists in an
Excel table, you can go ahead and import
the whole thing right into a SharePoint
list. Let's take a look. If you go ahead
and click here on the home page of your
SharePoint site and you click new, you
see, the very first option is list. When
you click there, you get this window that
slides out on the right this panel here
create list and you put it in the list.
Name of description. Click create, and you
have a nem P list with no columns, and
then you have tow create the columns and
you have to fill in all that data. But
that's not what we're going to do. That's
a lot of work. Instead, we're going to
create a SharePoint list from an Excel
table, and it'll bring in all of the data.
All of our columns. Let's go in and take a
look at that Excel list. We're gonna open
up our excel. We're gonna open up our
Excel worksheet here, and it's a list of
customers and the amount of sales we have
with them. Now there's about, I think, 100
rows yeah, 102 rows of data. We have our
hetero. There's one thing we need to do
first before this is ready for us to go
ahead and import it to excel. We need to
format this list as a table. You see this
button here upon the home tab of the
ribbon. We need to click there and we can
apply any theme, any formatting theme. We
want it doesn't matter. The important
thing is that my table has headers and
that IT select all of our data. We could
see that range here. Now we click. Okay.
And now this data is formatted as a table
and we're gonna name this table. You see
that? We have the table design tab here
and over to the left. We see table name,
and it says table one. I'm gonna get rid
of that. And I'm gonna call this
customers. Alright? We've named our table.
Let's save our changes. We'll close this
up. We're gonna come back here to
SharePoint now. We're not going to create
the list here from the home page. New
button. We're going to instead go to site
contents and we're gonna click the new
button here. It looks like the same new
button, but watch what happens when I
click new list. I got a lot more going on
in here, Don't I? UI got-to give our list
of name and it's going to be mhm. Customer
sales gives us a little information here,
but what I want is new from an existing
list or from Excel. That's what I'm
looking for. We're gonna click there, and
it's prompting us. Now we can choose a
list that may already be on the SharePoint
site. The customer worksheet is not here
on SharePoint. It's on my local computer,
so we have the option to upload IT. We're
going to click there. We'll go to our
documents folder and select our list.
We'll click and open and you see it's up
loading. Now. Select the table from this
file. This is what we wanted. That's why
we named the table. If we had several
tables and we didn't name them, they would
be named table. Want able-to Table three
and you might not remember exactly which
table you want. It's always a good idea to
name those tables. Then we see our
columns. And if I can get my there we go.
I could move that over. You see, it tells
me the different types of columns that we
have now this is number. We're going to
change that to currency, and I'm going to
show you one more trick. Zip code. IT
recognizes it as a number, but the problem
is we're gonna have a comma in here. It's
gonna put a comma after the third place.
So we're gonna change this simply to
single line of text. The rest of this
should all be fine. All right, let's go
ahead and let's create our list. And there
it is. Look at that are brand new
SharePoint list that we created from that
Excel workbook. And here it is on our
navigation customer sales. And that's how
you create a SharePoint list from a table
in Excel. It's a lot easier, a lot less
work. That's it for this lesson. Thanks for listening, and I'll see you next time.