LibreOffice Writer · Calc · Avery 5160

How to print labels in LibreOffice, from a Calc list or typed once

Updated

LibreOffice Writer has Avery® 5160 built in: File > New > Labels, then Brand Avery Letter Size and Type 5160 Address. For a list, register the Calc file as a data source with File > New > Database, pick its fields in the same dialog, and answer Yes when printing asks about a form letter. Or save the sheet as CSV or .xlsx and open it here for a PDF.

  • 5160 built in, measured
  • A Calc list as it is
  • Works on Linux too
Labels Labels FormatOptions Label text <First Name> <Last Name> <Street> <City>, <State> <ZIP> Database Addresses Table Sheet1 Brand Avery Letter Size Type 5160 Address New Document Ottilie Brannigan52 Maple AveHoboken, NJ 07030Kwame Lindqvist1408 W Cary StRichmond, VA 23220Saoirse Matsumoto9 Ridgewood TerAsheville, NC 28801Dariusz Okafor3125 SE Belmont St Apt 4CPortland, OR 97214Henrietta Quiroga780 Juniper WayBoise, ID 83702Ezra Valdivia-Holt26 Church StMontpelier, VT 05602Mirela Whitcombe1150 S Ocean BlvdDelray Beach, FL 33483 1 · Writer: File > New > Labels 2 · Avery 5160, 7 labels

Merge · same text · open here

Three ways, by what goes on the labels.

LibreOffice's menus, from its own help pages, read on November 16, 2026. On a Mac, Options sits under LibreOffice > Preferences.

LibreOffice Writer has Avery's US sheets built in, so a sheet of labels comes three ways. A list in Calc, merged in Writer merges in Writer once the sheet is a registered data source. One text on every label comes straight from the Labels dialog. A list in Calc, saved as CSV or .xlsx opens here once Calc saves it as CSV or .xlsx.

Three ways to print a sheet of labels with LibreOffice, by what goes on them
What goes on the labelsHowBest for
A list in Calc, merged in WriterRegister the spreadsheet as a data source (File > New > Database), then pick its fields in File > New > Labels. Printing asks whether to print a form letter: answer Yes (LibreOffice's steps). Each step.A list you keep in Calc and print from again each year.
One text on every labelFile > New > Labels, then type it in Label text, or tick Address to fill in your name and address from Tools > Options > LibreOffice > User Data (LibreOffice's steps).Return address labels, jar labels, a name on every tag.
A list in Calc, saved as CSV or .xlsxFile > Save As, then Text CSV or .xlsx as the file type; a CSV keeps only the sheet you are on (LibreOffice's steps). Open the file above.A list printed now, with no data source to set up, or a sheet already half used.

Do it here

Open the list you saved from Calc.

Save the sheet from Calc as Text CSV or .xlsx, then open it here: each row becomes a label. Calc's own .ods files aren't read, and nothing is uploaded.

Cells copied from Excel, Google Sheets or Numbers, header row included, or addresses with a blank line between them.

The number on your box

Open the full editor

The sheet shows the sample: a list of seven made-up households, as Calc saves it as CSV. Paste your list or open a file, and it shows yours.

Your list stays on this device. Nothing is uploaded.

Ottilie Brannigan52 Maple AveHoboken, NJ 07030Kwame Lindqvist1408 W Cary StRichmond, VA 23220Saoirse Matsumoto9 Ridgewood TerAsheville, NC 28801Dariusz Okafor3125 SE Belmont St Apt 4CPortland, OR 97214Henrietta Quiroga780 Juniper WayBoise, ID 83702Ezra Valdivia-Holt26 Church StMontpelier, VT 05602Mirela Whitcombe1150 S Ocean BlvdDelray Beach, FL 33483
Sample list · 7 labels on 5160

Worked example

Seven rows in, seven labels out.

The CSV file Calc saves, opened as it comes: a ZIP code keeps its leading zero and an apartment stays on the street line.

In the CSV file from Calc

Addresses.csv

4 rows of the sample list
RowFirst NameLast NameStreetCityStateZIP
2OttilieBrannigan52 Maple AveHobokenNJ07030
3KwameLindqvist1408 W Cary StRichmondVA23220
5DariuszOkafor3125 SE Belmont St Apt 4CPortlandOR97214
7EzraValdivia-Holt26 Church StMontpelierVT05602
On the 5160 sheet, as listed
  1. Ottilie Brannigan52 Maple AveHoboken, NJ 07030
  2. Kwame Lindqvist1408 W Cary StRichmond, VA 23220
  3. Dariusz Okafor3125 SE Belmont St Apt 4CPortland, OR 97214
  4. Ezra Valdivia-Holt26 Church StMontpelier, VT 05602
  • 7 rows from Calc's CSV file: 7 labels, 23 of the sheet left for next time.
  • Hoboken, NJ 07030 and Montpelier, VT 05602 keep their leading zero.
  • The apartment stays on the street line, as it was in the cell.

From Calc to a sheet of labels in four steps.

  1. Save the list from Calc

    File > Save As, then Text CSV or .xlsx as the file type (LibreOffice's steps). A CSV holds only the sheet you are on.

  2. Open the file above

    In any browser, on Windows, a Mac or Linux. Each row of the sheet becomes one label.

  3. Pick the number on your box

    And Start at label, if the sheet has labels missing. The line under the list says how many sheets you need.

  4. Download and print at 100%

    Open the PDF and print it at its own size, not scaled to fit the page.

Sheets for a Calc list

Sizes from Avery's own template files. LibreOffice's built-in types for the same numbers land within a hair of them.

Sheets for a Calc list: size, labels per sheet and the numbers that share each layout
SheetLabel sizePer sheetSame layoutGood for
Avery® 5160 1 × 2-5/8 in 30 8160 · 9160 · 18160 +56 Most addresses: 30 to a sheet, three lines at 10 pt.
Avery® 5161 1 × 4 in 20 8161 · 5261 · 5909 +19 Long street names: 20 labels 4 in wide.
Avery® 5163 2 × 4 in 10 8163 · 18163 · 48163 +29 Parcels and big envelopes: 10 labels of 2 × 4 in.
  • Merging in Writer instead? Each sheet's Brand and Type, checked against Avery's file.
  • Half a sheet left? Set Start at label in the box above to the first free label.

Brand and Type

The Avery sheets LibreOffice already has.

We set LibreOffice's measures for each type, as its label list gives them, against Avery's own template files, edge by edge.

Avery sheets built into LibreOffice Writer, where to find each in the Labels dialog, and how far its labels land from Avery's template file
SheetIn LibreOffice (Brand › Type)LabelsFurthest edge from Avery's file
Avery 5160Avery Letter Size › 5160 Address30 of 1 × 2-5/8 inunder 0.001 in
Avery 5161Avery Letter Size › 5161 Address20 of 1 × 4 in0.011 in (0.3 mm)
Avery 5163Avery Letter Size › 5163 Address / Shipping10 of 2 × 4 inunder 0.001 in
Avery 5167Avery Letter Size › 5167 Return Address80 of 1/2 × 1-3/4 in0.02 in (0.5 mm)
  • Same layout, other numbers. 5260 Address, 5960 Address and 8160 Ink Jet Address carry the same measures as 5160 in LibreOffice's list.
  • Avery 5167 lands up to 0.02 in (0.5 mm) from Avery's file, across 4 columns: keep the text a little inside each label.
  • Where to pick it. On the Labels tab, under Format: Sheet, then the Brand and the Type. The Format tab shows the measures; a sheet not in the list is [User], typed in there (LibreOffice's steps).
  • One label of a sheet. The Options tab's Single Label prints one label at the column and row you give (LibreOffice's steps).

Calc to Writer

A mail merge for labels, step by step.

Writer reads the list from a registered data source, so the first step happens once per spreadsheet.

  1. Register the spreadsheet. File > New > Database opens the Database Wizard (LibreOffice's steps). Choose Connect to an existing database, then Spreadsheet as the type, and browse to the file (LibreOffice's steps). On the last page keep Yes, register the database for me (LibreOffice's steps), then save the small database file the wizard makes.
  2. Open the Labels dialog. File > New > Labels. On the Labels tab pick Avery Letter Size and the Type, then the database and the table, which is the sheet's name (LibreOffice's steps).
  3. Put the fields on the label. Pick a field and click the left arrow to insert it into Label text. Press Enter for a new line, and type the spaces and commas between fields.
  4. Choose Entire Page on the Options tab, and Synchronize contents if you will change the font or add a picture: you then edit the top left label and click Synchronize Labels to copy it to every label (LibreOffice's steps).
  5. Click New Document, then print. Writer asks whether you want to print a form letter: answer Yes. In the Mail Merge dialog choose All, or a From and To record, then Printer, or File to save one document with every label (LibreOffice's steps).
  • The sheet isn't in the Database list? It isn't registered yet: LibreOffice inserts fields from registered databases only (LibreOffice's note).
  • Hard to see the fields? View > Field Names shows each one by its name while you arrange the label (LibreOffice's tip).
  • A change shows on one label only? Click Synchronize Labels: it copies the top left label to the others.
  • Only some addresses? Give the first and last record under From and To in the Mail Merge dialog.

A merge in Word that fills one label or stops after a page: seven fixes for mail merge labels.

Three things that keep 5160 labels straight.

Print at actual size

"Fit to page" can resize the sheet, and then the lower rows drift off their labels. The PDF opens at 100%; keep it there.

Feed the right side up

Printers differ: some print on the side facing up in the tray, others on the side facing down. Mark an X on a plain sheet, print once and look before you load labels.

Test on plain paper

Hold a plain-paper print over a 5160 sheet against a window. If it sits off, calibrate once and save the correction for that printer.

Questions people ask

Does LibreOffice have a template for Avery 5160 labels?

Yes, built in: File > New > Labels, then Brand Avery Letter Size and Type 5160 Address (LibreOffice's steps). Its labels land under 0.001 in from Avery's own file, and 5260, 5960 and 8160 Ink Jet Address sit in the same list with the same measures.

How do I do a mail merge for labels in LibreOffice?

Register the Calc file with File > New > Database, then in File > New > Labels pick the database, the table and the fields. Click New Document, print, and answer Yes to the form letter question (LibreOffice's steps). Each step.

Why isn't my spreadsheet in the Database list?

Writer inserts fields from registered databases only. Run File > New > Database, connect to the spreadsheet and keep Yes, register the database for me (LibreOffice's note).

How do I print a whole sheet of the same label in LibreOffice?

In File > New > Labels, type the text in Label text, or tick Address for your own from User Data, and keep Entire Page on the Options tab. With Synchronize contents on, format the top left label and click Synchronize Labels (LibreOffice's steps).

Can I print labels for only some addresses?

Yes. When the Mail Merge dialog opens, give the first and last record under From and To (LibreOffice's steps). Here, delete the rows you don't want from the box above before you download.

Can this page open a LibreOffice .ods file?

Not an .ods. Save the sheet as Text CSV or .xlsx first and open that. The file is read in your browser and the PDF is made there: nothing is uploaded or stored.

A long list, sorted your way.

The editor opens the same file and does more: sort by last name or ZIP code, leave out duplicates, change the lines, print copies.

LibreOffice Writer's Labels dialog with the list's fields in the label text and Avery Letter Size, 5160 Address chosen, and the sheet of Avery 5160 address labels it makes