1 00:00:03,940 --> 00:00:05,740 [Autogenerated] Hi. We're here today in 2 00:00:05,740 --> 00:00:08,920 our office 3 65. And in this lesson, we're 3 00:00:08,920 --> 00:00:11,520 going to take a look at how to create Ah 4 00:00:11,520 --> 00:00:15,290 SharePoint list from an Excel table. One 5 00:00:15,290 --> 00:00:17,000 of the great things about SharePoint, of 6 00:00:17,000 --> 00:00:19,020 course, are the SharePoint lists. They 7 00:00:19,020 --> 00:00:21,830 could hold a lot of data, and in a lot of 8 00:00:21,830 --> 00:00:24,950 ways, they're very much like an Excel 9 00:00:24,950 --> 00:00:27,010 table. They have a lot of data, and 10 00:00:27,010 --> 00:00:28,330 there's a lot of things you could do with 11 00:00:28,330 --> 00:00:30,820 it. We're gonna go to this site, our sales 12 00:00:30,820 --> 00:00:32,840 team site, and this is where we're going 13 00:00:32,840 --> 00:00:34,710 to create that new SharePoint list. Now 14 00:00:34,710 --> 00:00:37,420 the great thing about SharePoint lists is, 15 00:00:37,420 --> 00:00:39,640 of course, they could hold a lot of data. 16 00:00:39,640 --> 00:00:42,010 The bad thing is you have to enter all of 17 00:00:42,010 --> 00:00:46,190 that data. But if that data exists in an 18 00:00:46,190 --> 00:00:49,320 Excel table, you can go ahead and import 19 00:00:49,320 --> 00:00:51,640 the whole thing right into a SharePoint 20 00:00:51,640 --> 00:00:54,270 list. Let's take a look. If you go ahead 21 00:00:54,270 --> 00:00:56,490 and click here on the home page of your 22 00:00:56,490 --> 00:00:59,270 SharePoint site and you click new, you 23 00:00:59,270 --> 00:01:02,720 see, the very first option is list. When 24 00:01:02,720 --> 00:01:04,960 you click there, you get this window that 25 00:01:04,960 --> 00:01:07,180 slides out on the right this panel here 26 00:01:07,180 --> 00:01:09,170 create list and you put it in the list. 27 00:01:09,170 --> 00:01:12,220 Name of description. Click create, and you 28 00:01:12,220 --> 00:01:15,170 have a nem P list with no columns, and 29 00:01:15,170 --> 00:01:17,930 then you have tow create the columns and 30 00:01:17,930 --> 00:01:20,110 you have to fill in all that data. But 31 00:01:20,110 --> 00:01:21,560 that's not what we're going to do. That's 32 00:01:21,560 --> 00:01:24,160 a lot of work. Instead, we're going to 33 00:01:24,160 --> 00:01:26,830 create a SharePoint list from an Excel 34 00:01:26,830 --> 00:01:29,960 table, and it'll bring in all of the data. 35 00:01:29,960 --> 00:01:32,370 All of our columns. Let's go in and take a 36 00:01:32,370 --> 00:01:34,780 look at that Excel list. We're gonna open 37 00:01:34,780 --> 00:01:37,610 up our excel. We're gonna open up our 38 00:01:37,610 --> 00:01:40,470 Excel worksheet here, and it's a list of 39 00:01:40,470 --> 00:01:43,360 customers and the amount of sales we have 40 00:01:43,360 --> 00:01:47,490 with them. Now there's about, I think, 100 41 00:01:47,490 --> 00:01:50,580 rows yeah, 102 rows of data. We have our 42 00:01:50,580 --> 00:01:52,980 hetero. There's one thing we need to do 43 00:01:52,980 --> 00:01:56,390 first before this is ready for us to go 44 00:01:56,390 --> 00:01:59,900 ahead and import it to excel. We need to 45 00:01:59,900 --> 00:02:02,810 format this list as a table. You see this 46 00:02:02,810 --> 00:02:05,680 button here upon the home tab of the 47 00:02:05,680 --> 00:02:09,200 ribbon. We need to click there and we can 48 00:02:09,200 --> 00:02:11,970 apply any theme, any formatting theme. We 49 00:02:11,970 --> 00:02:14,350 want it doesn't matter. The important 50 00:02:14,350 --> 00:02:17,000 thing is that my table has headers and 51 00:02:17,000 --> 00:02:19,070 that IT select all of our data. We could 52 00:02:19,070 --> 00:02:23,040 see that range here. Now we click. Okay. 53 00:02:23,040 --> 00:02:26,740 And now this data is formatted as a table 54 00:02:26,740 --> 00:02:28,580 and we're gonna name this table. You see 55 00:02:28,580 --> 00:02:31,310 that? We have the table design tab here 56 00:02:31,310 --> 00:02:33,560 and over to the left. We see table name, 57 00:02:33,560 --> 00:02:36,390 and it says table one. I'm gonna get rid 58 00:02:36,390 --> 00:02:39,540 of that. And I'm gonna call this 59 00:02:39,540 --> 00:02:45,440 customers. Alright? We've named our table. 60 00:02:45,440 --> 00:02:49,560 Let's save our changes. We'll close this 61 00:02:49,560 --> 00:02:50,820 up. We're gonna come back here to 62 00:02:50,820 --> 00:02:53,100 SharePoint now. We're not going to create 63 00:02:53,100 --> 00:02:55,450 the list here from the home page. New 64 00:02:55,450 --> 00:02:58,540 button. We're going to instead go to site 65 00:02:58,540 --> 00:03:02,290 contents and we're gonna click the new 66 00:03:02,290 --> 00:03:04,070 button here. It looks like the same new 67 00:03:04,070 --> 00:03:05,910 button, but watch what happens when I 68 00:03:05,910 --> 00:03:09,640 click new list. I got a lot more going on 69 00:03:09,640 --> 00:03:12,060 in here, Don't I? UI got-to give our list 70 00:03:12,060 --> 00:03:18,650 of name and it's going to be mhm. Customer 71 00:03:18,650 --> 00:03:22,260 sales gives us a little information here, 72 00:03:22,260 --> 00:03:26,110 but what I want is new from an existing 73 00:03:26,110 --> 00:03:29,620 list or from Excel. That's what I'm 74 00:03:29,620 --> 00:03:34,060 looking for. We're gonna click there, and 75 00:03:34,060 --> 00:03:36,700 it's prompting us. Now we can choose a 76 00:03:36,700 --> 00:03:39,120 list that may already be on the SharePoint 77 00:03:39,120 --> 00:03:41,660 site. The customer worksheet is not here 78 00:03:41,660 --> 00:03:43,650 on SharePoint. It's on my local computer, 79 00:03:43,650 --> 00:03:47,120 so we have the option to upload IT. We're 80 00:03:47,120 --> 00:03:49,630 going to click there. We'll go to our 81 00:03:49,630 --> 00:03:54,140 documents folder and select our list. 82 00:03:54,140 --> 00:03:55,940 We'll click and open and you see it's up 83 00:03:55,940 --> 00:04:01,890 loading. Now. Select the table from this 84 00:04:01,890 --> 00:04:05,370 file. This is what we wanted. That's why 85 00:04:05,370 --> 00:04:08,570 we named the table. If we had several 86 00:04:08,570 --> 00:04:10,260 tables and we didn't name them, they would 87 00:04:10,260 --> 00:04:13,120 be named table. Want able-to Table three 88 00:04:13,120 --> 00:04:15,990 and you might not remember exactly which 89 00:04:15,990 --> 00:04:18,440 table you want. It's always a good idea to 90 00:04:18,440 --> 00:04:22,760 name those tables. Then we see our 91 00:04:22,760 --> 00:04:28,660 columns. And if I can get my there we go. 92 00:04:28,660 --> 00:04:31,360 I could move that over. You see, it tells 93 00:04:31,360 --> 00:04:37,900 me the different types of columns that we 94 00:04:37,900 --> 00:04:40,610 have now this is number. We're going to 95 00:04:40,610 --> 00:04:44,830 change that to currency, and I'm going to 96 00:04:44,830 --> 00:04:49,860 show you one more trick. Zip code. IT 97 00:04:49,860 --> 00:04:52,390 recognizes it as a number, but the problem 98 00:04:52,390 --> 00:04:54,140 is we're gonna have a comma in here. It's 99 00:04:54,140 --> 00:04:56,860 gonna put a comma after the third place. 100 00:04:56,860 --> 00:05:01,540 So we're gonna change this simply to 101 00:05:01,540 --> 00:05:09,240 single line of text. The rest of this 102 00:05:09,240 --> 00:05:14,880 should all be fine. All right, let's go 103 00:05:14,880 --> 00:05:22,500 ahead and let's create our list. And there 104 00:05:22,500 --> 00:05:26,840 it is. Look at that are brand new 105 00:05:26,840 --> 00:05:32,470 SharePoint list that we created from that 106 00:05:32,470 --> 00:05:38,720 Excel workbook. And here it is on our 107 00:05:38,720 --> 00:05:43,400 navigation customer sales. And that's how 108 00:05:43,400 --> 00:05:47,910 you create a SharePoint list from a table 109 00:05:47,910 --> 00:05:50,750 in Excel. It's a lot easier, a lot less 110 00:05:50,750 --> 00:06:02,000 work. That's it for this lesson. Thanks for listening, and I'll see you next time.