1 00:00:03,940 --> 00:00:05,600 [Autogenerated] high in this lesson. I'm 2 00:00:05,600 --> 00:00:07,320 gonna show you how to create a SharePoint 3 00:00:07,320 --> 00:00:10,890 list from an Excel spreadsheet. We're here 4 00:00:10,890 --> 00:00:12,840 on our HR team site. We're on the home 5 00:00:12,840 --> 00:00:15,120 page and we're gonna go over here and 6 00:00:15,120 --> 00:00:17,370 click on the new button. Now, when I click 7 00:00:17,370 --> 00:00:20,090 there, we get this list and we're gonna go 8 00:00:20,090 --> 00:00:24,040 all the way down the bottom two app 9 00:00:24,040 --> 00:00:26,660 because SharePoint lists are basically 10 00:00:26,660 --> 00:00:29,500 APS. It brings us here to the your APS 11 00:00:29,500 --> 00:00:32,160 page and we're going to scroll down. And 12 00:00:32,160 --> 00:00:34,360 the very last one that we see down here in 13 00:00:34,360 --> 00:00:36,330 the lower right corner is import 14 00:00:36,330 --> 00:00:38,540 spreadsheet. That's what we're gonna do. 15 00:00:38,540 --> 00:00:41,250 But before we do that, I want to go ahead 16 00:00:41,250 --> 00:00:44,920 and I want to take a look at the worksheet 17 00:00:44,920 --> 00:00:47,330 that we're going to import. So we're going 18 00:00:47,330 --> 00:00:50,540 to go to our documents and it is gonna be 19 00:00:50,540 --> 00:00:53,670 this one intern candidates. It's a list of 20 00:00:53,670 --> 00:00:58,460 potential interns for our company. Now 21 00:00:58,460 --> 00:01:00,670 it's very simple. Excel worksheet. There's 22 00:01:00,670 --> 00:01:02,610 not a lot on it. There's only 30 Rose 23 00:01:02,610 --> 00:01:05,550 worth of data and it just names, address, 24 00:01:05,550 --> 00:01:08,320 email, things like that. It's not been 25 00:01:08,320 --> 00:01:11,090 formatted as a table. There's no named 26 00:01:11,090 --> 00:01:14,540 ranges. It's just data on a worksheet. 27 00:01:14,540 --> 00:01:17,010 Okay, now, another important thing is 28 00:01:17,010 --> 00:01:18,880 before you go ahead and try to import 29 00:01:18,880 --> 00:01:21,450 this, it can't be open. You need to make 30 00:01:21,450 --> 00:01:24,080 sure that this Excel file is closed. So 31 00:01:24,080 --> 00:01:26,820 we're going to do that. Come back here to 32 00:01:26,820 --> 00:01:28,970 our APS page and we're gonna click on 33 00:01:28,970 --> 00:01:33,400 import spreadsheet now. And when we do 34 00:01:33,400 --> 00:01:36,870 that, it brings up the new APP page. First 35 00:01:36,870 --> 00:01:38,610 thing we have to do is give our app a 36 00:01:38,610 --> 00:01:41,120 name, give our SharePoint list a name, and 37 00:01:41,120 --> 00:01:44,580 we're going to call it intern candidates 38 00:01:44,580 --> 00:01:49,800 the same as the name of the worksheet. 39 00:01:49,800 --> 00:01:52,450 Now, it doesn't have to be the same name. 40 00:01:52,450 --> 00:01:55,030 It just happens that that's pretty 41 00:01:55,030 --> 00:01:56,770 explanatory. That's why I'm not even gonna 42 00:01:56,770 --> 00:01:58,940 bother putting a description on. Now, I'm 43 00:01:58,940 --> 00:02:01,160 gonna go down here to the file location 44 00:02:01,160 --> 00:02:02,890 and click on the browse button because now 45 00:02:02,890 --> 00:02:05,590 we have to tell SharePoint which Excel 46 00:02:05,590 --> 00:02:07,170 workbook we want to bring in. So we're 47 00:02:07,170 --> 00:02:10,170 gonna go to browse. We're gonna come down 48 00:02:10,170 --> 00:02:13,530 here and select intern candidates and 49 00:02:13,530 --> 00:02:17,320 click open. Now, before I hit Import, I 50 00:02:17,320 --> 00:02:19,940 gotta tell you something. This is not 51 00:02:19,940 --> 00:02:22,890 going to work. And you're probably 52 00:02:22,890 --> 00:02:24,220 thinking, Why am I showing you this 53 00:02:24,220 --> 00:02:25,980 because I want you to see what happens. 54 00:02:25,980 --> 00:02:27,400 And then we're gonna talk about why it 55 00:02:27,400 --> 00:02:29,610 doesn't work. We're gonna click the import 56 00:02:29,610 --> 00:02:32,450 button and see this. I get this pop up. 57 00:02:32,450 --> 00:02:34,860 That says, This site says this feature 58 00:02:34,860 --> 00:02:37,960 requires a browser that supports Activex 59 00:02:37,960 --> 00:02:42,030 controls. I'm using Microsoft Edge latest 60 00:02:42,030 --> 00:02:44,410 version of the newest browser by 61 00:02:44,410 --> 00:02:47,350 Microsoft. It does not support Activex 62 00:02:47,350 --> 00:02:50,200 controls. Now I'm going to tell you that 63 00:02:50,200 --> 00:02:52,870 we need to use a different browsers. We 64 00:02:52,870 --> 00:02:55,240 can't use Google Chrome because it also 65 00:02:55,240 --> 00:02:58,330 does not support Activex controls. What 66 00:02:58,330 --> 00:03:00,070 are we going to do in that case, you ask? 67 00:03:00,070 --> 00:03:03,290 Well, let me tell you, let's cancel this 68 00:03:03,290 --> 00:03:12,050 first and let's go back here. We actually 69 00:03:12,050 --> 00:03:15,570 need to go to our old friend Internet 70 00:03:15,570 --> 00:03:18,890 Explorer. Yep, that's right. The old 71 00:03:18,890 --> 00:03:21,410 outdated. Nobody likes it anymore. 72 00:03:21,410 --> 00:03:24,200 Internet Explorer. It's still really 73 00:03:24,200 --> 00:03:26,880 useful Gang. Don't dismiss it just because 74 00:03:26,880 --> 00:03:29,650 it's not. The newest and greatest Internet 75 00:03:29,650 --> 00:03:31,800 Explorer does support the Activex 76 00:03:31,800 --> 00:03:35,230 controls. So what we want to do will work 77 00:03:35,230 --> 00:03:37,770 using Internet Explorer. Let's take a look 78 00:03:37,770 --> 00:03:39,350 once again, we're going to go to our new 79 00:03:39,350 --> 00:03:46,150 button click app scroll down to import 80 00:03:46,150 --> 00:03:50,340 spreadsheet. We're gonna give our list of 81 00:03:50,340 --> 00:03:56,120 name and again intern candidates just like 82 00:03:56,120 --> 00:03:58,940 before, will also skip the description, 83 00:03:58,940 --> 00:04:02,570 will browse for the file and choose 84 00:04:02,570 --> 00:04:06,110 intern. Candidates will click open, and 85 00:04:06,110 --> 00:04:08,840 now when we click import, it's Gonna work. 86 00:04:08,840 --> 00:04:10,500 It's gonna be a lot different than when we 87 00:04:10,500 --> 00:04:14,980 did it the last time. Look at that. See 88 00:04:14,980 --> 00:04:16,840 what happened here? It's opened up Excel. 89 00:04:16,840 --> 00:04:20,070 It's open up that worksheet and we get 90 00:04:20,070 --> 00:04:23,260 this window import to win those SharePoint 91 00:04:23,260 --> 00:04:26,610 Service's list. What is the type of range 92 00:04:26,610 --> 00:04:28,790 of data that we want to import now? This 93 00:04:28,790 --> 00:04:30,490 is very important. You see, here it says 94 00:04:30,490 --> 00:04:33,340 table range. We got to select the drop 95 00:04:33,340 --> 00:04:35,130 down because we have three choices. Ranger 96 00:04:35,130 --> 00:04:38,230 sells table range and named range, and it 97 00:04:38,230 --> 00:04:41,030 depends on how your data is formatted in 98 00:04:41,030 --> 00:04:43,940 the worksheet as to which one you choose. 99 00:04:43,940 --> 00:04:46,340 Now, I already told you we don't have a 100 00:04:46,340 --> 00:04:48,550 table in this worksheet. None of our data 101 00:04:48,550 --> 00:04:51,660 has been formatted as a table. We also 102 00:04:51,660 --> 00:04:54,530 have no named range is. All we have is a 103 00:04:54,530 --> 00:04:56,790 range of cells, so that's what we're going 104 00:04:56,790 --> 00:04:59,240 to select now. If it was a formatted table 105 00:04:59,240 --> 00:05:01,370 or we had a named range, we could select 106 00:05:01,370 --> 00:05:03,790 those, but it's just a range of cells. 107 00:05:03,790 --> 00:05:06,340 Now, you see, we have the select range 108 00:05:06,340 --> 00:05:09,400 option. We have to go ahead and select the 109 00:05:09,400 --> 00:05:11,970 range of data that we want to bring it. 110 00:05:11,970 --> 00:05:13,730 I'm going to click on that little button 111 00:05:13,730 --> 00:05:16,740 right there to collapse that dialogue box. 112 00:05:16,740 --> 00:05:21,750 And I am gonna go here in Excel in this 113 00:05:21,750 --> 00:05:24,460 worksheet and highlight. You see, I 114 00:05:24,460 --> 00:05:26,990 clicked and dragged to highlight that 115 00:05:26,990 --> 00:05:29,410 range. Now, if I knew what the range was, 116 00:05:29,410 --> 00:05:31,720 I could have simply typed it in here. And 117 00:05:31,720 --> 00:05:33,600 you see, it is intern candidates. That's 118 00:05:33,600 --> 00:05:36,740 the name of the worksheet and the range A 119 00:05:36,740 --> 00:05:40,140 one through age 30. Okay, now we're gonna 120 00:05:40,140 --> 00:05:44,510 click Import, give it a minute here to do 121 00:05:44,510 --> 00:05:55,190 its thing. Look at that. We have a brand 122 00:05:55,190 --> 00:05:59,150 new list that we brought in from Excel as 123 00:05:59,150 --> 00:06:01,410 a lot easier than entering in all of these 124 00:06:01,410 --> 00:06:04,570 values. All of these items manually, isn't 125 00:06:04,570 --> 00:06:10,490 it? Now, one thing I want to also point 126 00:06:10,490 --> 00:06:13,590 out. Look, over here on our quick launch, 127 00:06:13,590 --> 00:06:18,770 we don't see a link to the new list in the 128 00:06:18,770 --> 00:06:20,820 quick launch. That's because when it 129 00:06:20,820 --> 00:06:22,350 brings it in, it doesn't give you the 130 00:06:22,350 --> 00:06:24,710 option to say yes or no? Do I want to 131 00:06:24,710 --> 00:06:26,930 include this on the quick launch? So what 132 00:06:26,930 --> 00:06:32,940 we're going to do is go to list settings 133 00:06:32,940 --> 00:06:36,300 for our list. Click on list name, 134 00:06:36,300 --> 00:06:39,830 description and navigation. And then down 135 00:06:39,830 --> 00:06:42,870 here, simply click. Yes, I'm display this 136 00:06:42,870 --> 00:06:48,140 list on the quick launch. Well, save it. 137 00:06:48,140 --> 00:06:51,360 You can already see it there, and we go 138 00:06:51,360 --> 00:06:55,590 back to our list. So now you know how to 139 00:06:55,590 --> 00:06:58,840 create a new SharePoint list from an Excel 140 00:06:58,840 --> 00:07:08,000 spreadsheet. Thanks for listening. And I'll see you next time.