how to print address labels from excel file

Working copy of the address spreadsheet with short namesĬreate a temporary database from the spreadsheet by selecting File>New>Database, then select Connect to an existing database, specify Spreadsheet in the dropdown and press the Next button. In the example file, I have renamed the original columns to f, l, a, c, s and z.Īlso rename the spreadsheet tab (at the bottom) to a single-character name, such as a. Row 1 must be a header row that specifies names for each column, so add that row if needed.Īgain, use single-character names for the header row. Open the temporary working copy ( a.csv) of the address spreadsheet. Use single-character names to ensure good results when laying out the label structure. Since file and field names can potentially be longer than the values they contain, using long names can overflow the available label area and confuse the layout. These steps lay out the address fields on a visual representaton of the label inside LibreOffice. I my case, I made a copy of addresses.csv, named it a.csv, and moved it into the temporary folder. Make a temporary working copy and name the copy using a single-character file name.

In my case, the folder is called temp and it was created on the desktop.Ĭlose the original address spreadsheet if it’s currently open. Sample address spreadsheet in LibreOffice CalcĬreate a temporary folder to hold the working files, which can all be deleted afterwards. The exact structure of the spreadsheet doesn’t matter, but using fewer columns makes layout easier, so one could also use a single column for full name and a single column for city, state and zip if that makes more sense. My example file is called addresses.csv and contains columns for first, last, address, city, state and zip. These instructions work with version 5.4.5.1.īegin with a spreadsheet of addresses. MailMerge in LibreOffice is somewhat fiddly and the recommended method seems to change from version to version.

I only need to do this once a year, and every year I forget how.

How to print address labels from excel file