# Make and Print Address Labels from Excel

Canonical source: [Make and Print Address Labels from Excel](https://printpiper.app/print-address-labels-from-excel/)

Updated: 2026-09-17

To make address labels from Excel, save one label design with {{Name}}\-style variables, import your .xlsx or .xls mailing list, and connect the address columns. PrintPiper fills every row into your design and downloads a print-ready PDF — as Avery 5160 / 8160 sheets with 30 labels per page or as individual labels in any custom size. The whole workflow runs in your browser, with no Word mail merge.

**What you need:** a mailing list saved as XLSX, XLS, CSV or TSV, and a free account to save your label template. Address data stays on your device; only the saved template design is uploaded. Standard templates print one label per page; Avery 5160 / 8160 mode fills 30 labels per US Letter sheet.

## Lay out the address block

Most mailing labels read best as one text field with line breaks between the variables, rather than five separate fields. Place a single field on the label and fill it with:

Example mailing list — fictional data

| Name | Address | City | State | PostalCode |
| --- | --- | --- | --- | --- |
| Alex Example | 12 Sample Lane | Exampleville | MA | 01234 |

Place these matching column placeholders in one text field:

```text
{{Name}}
{{Address}}
{{City}}, {{State}} {{PostalCode}}
```

The example row prints as:

```text
Alex Example
12 Sample Lane
Exampleville, MA 01234
```

If your addresses need more lines — apartment, department, or a country line — add those columns to the same field in the order you want them printed. Each label prints exactly the text its row supplies. PrintPiper does not validate, standardize, or reformat addresses.

## Choose a label format

Pick the format in **Paper size** before you position the address block:

**Avery 5160 / 8160 · 30 labels / sheet** for standard 1 × 2⅝ inch address labels. Records fill the 3 × 10 Letter grid left to right, and a starting position from 1–30 lets you reuse a partly used sheet. See the [Avery 5160 / 8160 guide](https://printpiper.app/avery-5160-label-template/) for the exact sheet geometry and alignment steps.

**Address · 89 × 36 mm** or custom dimensions for individual labels, shipping-style 4 × 6 in pages, and other stock. Standard templates produce one label page per row, so match your paper or finished size to the stock you loaded. Custom sizes accept millimeters or inches.

## Prepare the mailing list

Use one row per label with unique, nonempty column names such as Name, Address, City, State, and PostalCode. Keep postal codes formatted as text so leading zeroes survive. Unmerge any merged cells in the data table. The first 20,001 worksheet rows of an Excel sheet are readable, and free accounts export 10 records per batch — paid plans raise that to 10,000.

PrintPiper imports the saved display text, including date and zero-padding formats. Formulas must have saved results; XLSM, XLSB, and encrypted workbooks are not supported. The workbook never leaves your device.

## Connect columns and generate the batch

Save the template, then choose **Import CSV / Excel** in the right panel and select your mailing list. For Excel, pick the sheet and click the row that holds the column names. In **Connect columns**, variables with matching header names connect automatically — map the rest by hand. Every required variable must be connected before the export runs.

Check a few preview records, especially the longest addresses, then choose **Print-ready PDF** and a row range and click **Generate files**. Large batches split into several PDF parts, each with its own Download button.

## Print the labels

Print the downloaded PDF at **Actual size / 100%** with the printer paper matching the exported page size, and disable Fit or Shrink scaling. Run one plain-paper test against a label sheet and adjust X/Y alignment if the grid drifts. The full alignment procedure is in the [Avery alignment guide](https://printpiper.app/avery-5160-label-template/#alignment).

## Address label questions

### How do I print mailing labels from Excel without Word?

Exactly as above: save a label template, import the workbook, connect the address columns, and generate the PDF. Nothing in this workflow opens Word, runs a mail merge, or sends your list to a server.

### Can Excel create address labels on its own?

No. Excel has no label layout. The usual routes are Word Mail Merge with the workbook as the recipient list, or importing the workbook into a label tool such as PrintPiper, which turns each row into a printed label.

### Why did my ZIP codes lose their leading zeroes?

Eastern US postal codes starting with zero are stored as numbers by default in Excel. Format the column as text and re-enter the values before importing; digits lost inside Excel cannot be restored by the importer. CSV files keep postal codes as written.

### Can I print return address labels from the same list?

Yes, as a separate template. A return label usually shows one fixed sender block instead of row data, so place the text directly in the design or use a custom size that matches your stock. The built-in sheet grid is Avery 5160 / 8160 only — smaller return-address stock prints one label per page rather than an 80-up sheet.

### Do international addresses work?

Yes. Add a Country column, place it on the final line of the address block, and let each row supply its own format. PrintPiper prints the text as supplied; it does not check postal formats or add barcodes.

### Can I reuse the design for next quarter’s list?

That is the point of saving the template. Next time, open it with **Select template**, import the new file, and generate — the layout, fonts, and column connections stay in place. Column connections belong to each batch and are never stored in the template.

For worksheet selection details, see the [Excel labels guide](https://printpiper.app/print-labels-from-excel/). Google Sheets and CSV lists follow the same steps after [downloading a Sheets snapshot](https://printpiper.app/print-labels-from-google-sheets/) or [preparing a CSV file](https://printpiper.app/print-labels-from-csv/).