 Okay, this tutorial is going to be a little bit different than most my tutorials. This one's going to be on LibreOffice I don't think I've ever done a tutorial on office software before. I don't use it too much myself But with the Christmas season coming up, I guess the Christmas season is here A lot of people are going to be wanting to send out letters And they may have an address list in some sort of spreadsheet that they may want to be able to print to Labels so here. I just made a quick little spreadsheet made up some names and addresses First things first obviously save this. I saved this and Before we continue we're gonna have to convert this into a database so what we're gonna do wrong click here, we're gonna insert a row and You can label these probably best because in the database this top row is going to be what each column is so we've got name address and we'll just say City and the zip here really at city state is it but doesn't really matter. That's just for your reference Once again save that then click file new and Database Then we're gonna choose connect to an existing database and we're gonna choose a spreadsheet Click next and then we got to choose our spreadsheet So come in here and go to wherever you have your spreadsheet that you just created saved Mine's an ODS format, but Excel spreadsheet should work the same Click next all that should be good. We're gonna open the database for editing Finish is gonna ask where you want to save this database. So just save it somewhere Addresses okay So this point we're gonna click on the sheet here This is the sheet. We just created in spreadsheet, but now it's in a database format You can see that first line is now the column names and we can go file new and down to labels At this point, we're gonna choose our database here, which we named addresses Choose the table, which would be sheet 1. It's our only table and then here We're gonna add the fields we want now how we're gonna set them up over here is going to be How they're gonna show up on the labels. So I'm just gonna click name add name address City and zip and then I'm going to space these out as they would be Name on the first line address on the second line and city and zip on the third line there Next we're gonna choose what type of labels you have so I'm gonna choose Avery letter size because the size of our paper Avery is the brand and then down here Choose whatever is the The paper it should say on the package what type of labels they are just choose whichever one you have And then click new document. So now we get this. This is the output of what it's going to look like Obviously right now. It just has fillers in there. So what we're gonna do next if you hit F4 It'll show you the sheet that we're using, but if we go up to window Actually, I meant tools and then down to mail merge with wizard and Basically, I'm just gonna keep clicking next here And eventually we're gonna get to a point where we're done And we're gonna save and start document and it went into the background here It's asking what we want to save our new little Formats because it basically it created a text document. That's formatted to our labels. I will save that as Addresses in this case. I'm gonna do an ODT, which is an open document text file But of course, you can choose if you prefer Microsoft format or other formats, but why not use open when you can use open? We'll click save there and finish here and here we go We have got our four names all in my case four names and it should be formatted at this point You can click your prints button And it should print obviously, you can also go to print preview here and see what it's gonna look like And printer settings if you want to change I printed it to a PDF because I'm not hooked up to my printer right now But that's it. I Hope you enjoyed the tutorial. I hope it wasn't too complicated But basically if it was just go back and review the video again So relatively simple only took us a few minutes and now you have it saved in a format that you can edit later on So I hope you enjoy the tutorial visit filmsbychrist.com. That's Chris of the K check out the link in the description And I hope that you have a great day