1 00:00:03,940 --> 00:00:05,340 [Autogenerated] high in this lesson. I'm 2 00:00:05,340 --> 00:00:07,740 gonna show you how to export a SharePoint 3 00:00:07,740 --> 00:00:10,950 list to excel. Let's go ahead and let's go 4 00:00:10,950 --> 00:00:15,680 to our employees list and we want to take 5 00:00:15,680 --> 00:00:17,740 this list and move it into, except we're 6 00:00:17,740 --> 00:00:20,420 going to go ahead and create a New Excel 7 00:00:20,420 --> 00:00:22,880 workbook. With all the information from 8 00:00:22,880 --> 00:00:25,550 this list, you can see here the top. We 9 00:00:25,550 --> 00:00:27,500 have a big button that says Export to 10 00:00:27,500 --> 00:00:29,680 Excel. That looks like a place to start. 11 00:00:29,680 --> 00:00:32,320 So let's go ahead and let's click on that. 12 00:00:32,320 --> 00:00:34,250 Once we do, we get this pop up down here 13 00:00:34,250 --> 00:00:36,090 at the bottom. That asks us, What do we 14 00:00:36,090 --> 00:00:38,620 want to do with this query? We want to 15 00:00:38,620 --> 00:00:40,790 open it, save it or cancel, but we're 16 00:00:40,790 --> 00:00:43,070 gonna open it up. We're gonna click there. 17 00:00:43,070 --> 00:00:46,640 And when we do that, it opened up Excel. 18 00:00:46,640 --> 00:00:49,780 And in our Excel workbook here we now have 19 00:00:49,780 --> 00:00:52,010 this security notice, and basically this 20 00:00:52,010 --> 00:00:54,390 is telling us that things that come from 21 00:00:54,390 --> 00:00:57,410 the Internet might not be safe, but we 22 00:00:57,410 --> 00:01:00,250 trust our SharePoint. We're okay. So we're 23 00:01:00,250 --> 00:01:03,740 going to enable that connection and look 24 00:01:03,740 --> 00:01:06,170 at that. It brings back all of this data, 25 00:01:06,170 --> 00:01:09,820 all of that entire SharePoint list here 26 00:01:09,820 --> 00:01:14,280 into Excel. Pretty nice. Let me get rid of 27 00:01:14,280 --> 00:01:18,610 this now. We want to go ahead and we save 28 00:01:18,610 --> 00:01:19,900 it. We're going to click on the little 29 00:01:19,900 --> 00:01:28,380 Save icon and we will save it as employees 30 00:01:28,380 --> 00:01:30,260 and we'll save it to Olivia's one drive. 31 00:01:30,260 --> 00:01:34,880 That's perfect. We'll click save, and once 32 00:01:34,880 --> 00:01:36,690 it's done, there we go. It turned the auto 33 00:01:36,690 --> 00:01:40,980 save on. I got it and we will close it Now 34 00:01:40,980 --> 00:01:43,320 that we've exported this SharePoint list 35 00:01:43,320 --> 00:01:46,240 into Excel and we save that workbook, 36 00:01:46,240 --> 00:01:48,310 we've created a connection between the 37 00:01:48,310 --> 00:01:50,930 two, but it's only a one way connection. 38 00:01:50,930 --> 00:01:53,520 So what does that mean? If we make a 39 00:01:53,520 --> 00:01:57,010 change here in the SharePoint list, that 40 00:01:57,010 --> 00:02:00,110 change will be reflected in the workbook, 41 00:02:00,110 --> 00:02:02,240 but not the other way around. If I go 42 00:02:02,240 --> 00:02:04,330 ahead and make a change in the workbook, 43 00:02:04,330 --> 00:02:06,640 it's not going to update the SharePoint 44 00:02:06,640 --> 00:02:09,890 list. Let me show you. We're gonna go 45 00:02:09,890 --> 00:02:11,080 here. We're going to select the first 46 00:02:11,080 --> 00:02:13,910 record Michael Callen final. We'll click 47 00:02:13,910 --> 00:02:18,330 on edit and we're gonna go and let's say 48 00:02:18,330 --> 00:02:21,780 he is no longer a sales associate. Let's 49 00:02:21,780 --> 00:02:24,480 say we have moved him into the accounting 50 00:02:24,480 --> 00:02:28,540 department and we've given him a raise to 51 00:02:28,540 --> 00:02:32,830 $21 an hour. Go ahead and click Save. We 52 00:02:32,830 --> 00:02:35,560 see that that has been changed here in the 53 00:02:35,560 --> 00:02:38,790 SharePoint list. Now let's go ahead and 54 00:02:38,790 --> 00:02:43,860 let's go to Olivia's one Drive and open up 55 00:02:43,860 --> 00:02:47,370 the workbook and we see that Michael is 56 00:02:47,370 --> 00:02:51,070 still listed as a sales associate at $9.24 57 00:02:51,070 --> 00:02:53,390 an hour. And you're thinking, what gives? 58 00:02:53,390 --> 00:02:56,420 Don't panic. We need to go to the data tab 59 00:02:56,420 --> 00:03:01,130 and click, Refresh all. See that? Now it 60 00:03:01,130 --> 00:03:03,240 changed. You have to refresh the 61 00:03:03,240 --> 00:03:06,630 connection. Unfortunately, like I said, it 62 00:03:06,630 --> 00:03:09,250 doesn't work the other way. If we go ahead 63 00:03:09,250 --> 00:03:11,160 and change Joshua Hartson here, we're 64 00:03:11,160 --> 00:03:13,680 gonna move him into accounting as well. 65 00:03:13,680 --> 00:03:16,010 And we'll give him a raise up to $21 an 66 00:03:16,010 --> 00:03:20,810 hour. And we don't have to say because the 67 00:03:20,810 --> 00:03:24,530 auto save is on. But we're ready to go. 68 00:03:24,530 --> 00:03:32,540 Will simply close that up. Go back to a to 69 00:03:32,540 --> 00:03:38,690 SharePoint, will refresh the page, and we 70 00:03:38,690 --> 00:03:40,880 look and we see that Joshua Hearts and 71 00:03:40,880 --> 00:03:43,750 it's still a sales associate, still making 72 00:03:43,750 --> 00:03:47,220 $11.60. So that's what I was talking 73 00:03:47,220 --> 00:03:50,060 about. It's only a one way connection. It 74 00:03:50,060 --> 00:03:52,950 doesn't work both ways. But now you know 75 00:03:52,950 --> 00:03:56,130 how to export a SharePoint list into 76 00:03:56,130 --> 00:04:06,000 excel. Thanks for listening, and I'll see you next time.