Address labels — free template with mail merge

Address labels are the classic job for label sheets: holiday cards, invitations, newsletters or business mailings. The fastest way is a mail merge — one label per row of your address list.

Paste the rows from Excel or Google Sheets into the Data tab, put {{name}}, {{street}} and {{city}} in the text box, and every label is filled automatically. Empty lines, such as a missing apartment number, are removed so the address stays compact.

Tips

• Keep the font at 10–12 pt for 1″ × 2-5/8″ labels (Avery® 5160 size); “Shrink to fit” handles long addresses.
• Use one column per address line in your spreadsheet (name, street, street2, city).
• Check one row with a very long name before printing 300 labels.
• Start at a later position to use up a partly used sheet.