How to print labels from Excel

Print labels from Excel for addresses, products, or barcodes. Map the columns, preview each row, and print to the printer you already have. One row becomes one label. You do not mail-merge in Word first. No signup. Mac and Windows. Save the sheet as xlsx or CSV. The rows stay in this browser.

Sizes

2.63 x 1 in.

5160 from a workbook

Address rows in Excel. Save xlsx, import it, and map Name, Street, City, Postal onto the 30-up sheet.

4 x 2 in.

5163 product rows

Wider cells when the Excel row has a product title and a price, not just an address.

2 x 1 in.

2x1 SKU column

Column A is the code. Format it as text so leading zeros stay. Then import.

4 x 6 in.

4x6 ship-to columns

One order per row. The columns are the lines of the address, not one cell with line breaks you hope survive.

3.5 x 2.25 in.

Badge columns

First name, last name, and company as three columns. The first name is the large line.

4 x 2 in.

Bin columns

Location, SKU, and description. This is the warehouse layout, still fed by the same workbook.

How to print labels from Excel

Save the workbook. Import it. You do not mail-merge in Word, and you do not copy cells into a text box one at a time. The first row should be headers: Name, Street, City, Region, Postal, or SKU and Title, whatever the labels need. One data row becomes one label. Empty rows become empty labels, so delete them before you import.

Dates and ZIP codes are the usual mess. A ZIP of 02115 becomes 2115 if Excel stored it as a number. Format that column as text, retype the zero if it already vanished, and save. Dates that should read 2026-04-02 should be formatted that way in the cell, not left as a serial number. Merged cells do not import cleanly. Unmerge them.

  1. Put headers in row 1 and records under them. One record, one row.
  2. Open the card for the stock you loaded.
  3. Import the xlsx or a CSV you saved from Excel.
  4. Map each header to a line or a barcode. Preview the last row.
  5. Print one. Then print the used range, not the whole million-row sheet.

A CSV export of the same file is print labels from CSV. A published Google Sheet is print labels from Google Sheets. The Word route you are skipping is print labels without Word.

Questions

How do I print labels from Excel?

Header row, one record per row, import the file, map columns, proof the last row, print.

Can I print address labels from Excel onto Avery 5160?

Yes. Open the 5160 card, map the address columns, and print on US Letter with scaling off.