how do you make mailing labels from an excel spreadsheet

For example, if you have a large number of addresses stored in a CSV file, import it into this Excel file. You need to import or enter the data you plan to use, and how you do this depends on how the data currently exists. How to do a mail merge in Word and Excelġ. In addition, you'll create a mail merge template in Word - this is a document that includes the boilerplate text you want to be the same for every recipient as well as the placeholder for the data that Word will insert from the Excel data file. This is simply a table that includes the information you want to merge - usually names and addresses, though you can merge data about anything. First, you'll need the data file in Excel. To mail merge a document - like a letter, envelope, printing label, or email - all you need is Microsoft Word and Excel, plus all the names and addresses you want to merge. It's surprisingly easy to set up a mail merge, which lets you create seemingly personalized communication for a large number of recipients without creating each message by hand. Mail merge helps you quickly create auto-personalized letters, envelopes, labels, and more.You can import an Excel data table into Word to customize your template with names and addresses.You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.Choose Save as single document, and click OK.Set output to a file so you can preview before printing.Click Yes to “Your document contains address fields.

Swith to the Options tab and select Synchronize contents, if you want to be able to edit the labels later or add extra formatting.Select the labels you want to print on from the Brand and Type dropdowns.You can also add extra spaces or other text by typing in the template. Select and add any other fields to the label template.Click the arrow to insert the field in the label template.Select a field like name or address from the Field dropdown.Select a sheet in your spreadsheet from the Table dropdown.Select the database you just created from the Database dropdown.Delete old fields from the template, if there are any.Name and save your Data Source as a database file in ODB format.Deselect “Open the database for editing”, and click Finish.Browse for the spreadsheet you just saved with the addresses in it, and click next.

Change “JDBC” to “Spreadsheet”, and click Next.

Select Connect to an existing database.

I had to run sudo apt install libreoffice-base in a terminal.

If you don't see that option, you might have to install LibreOffice Base separately. Make sure there are text labels at the top of each column. I finally found some workable instructions that load the addresses directly from the spreadsheet.

How do you make mailing labels from an excel spreadsheet