1. Save your address list as CSV
Put one recipient on each row. Separate columns for name, street address, second address line, city, state, and ZIP give you the most control. A second address line can stay blank for most rows. Before exporting, check ZIP codes that begin with zero; spreadsheet software may remove a leading zero when a column is treated as a number.
| Name | Street | City | State | ZIP |
|---|---|---|---|---|
| Jordan Lee | 18 Maple St | Portland | ME | 04101 |
2. Match the fields to label lines
Open the CSV address label maker and choose your CSV, or copy cells from Excel or Google Sheets and use Paste rows. Include the header row when pasting. Select which column belongs on each printed line. Use the sheet preview to catch swapped city and street fields, long names, and blank lines. The file stays on your device during this process.
For a partly used sheet, set First empty label on the first sheet before previewing. The tool skips the used positions on that first sheet, then continues with full sheets.
3. Check the stock and printer settings
The US Letter layout is for 30 labels per sheet, each 1 × 2⅝ inches, such as Avery 5160. Check the product number and dimensions on your package. A4 21-up stock needs the separate A4 label tool.
Print one page on plain paper first. Set paper to US Letter, print at 100% or Actual size, and turn off browser headers and footers. Hold the paper behind a label sheet against a light to see whether text sits within every label. Only then load the label stock. If alignment drifts, check printer scaling and paper feed before printing a batch.
Stock reference: Avery’s 5160 template.
4. Print or save a PDF
Use Print or save as PDF after checking the preview. If you save a PDF for later, verify the same paper size and 100% scale when you eventually print it. Keep the original CSV in case an address changes; regenerate the sheet rather than editing a flattened printout.