Sheets To Labels

How to Print Labels from Excel | Step-by-Step Guide

Apr 13, 2026

To print labels from Excel, clean the worksheet first, choose the label layout, upload the Excel file, map the columns onto the label, preview the full sheet, and export the PDF at 100% scale.

If you want the shortest product-first path, start with Excel to Labels. If the job is mainly mailing labels, start with Address Label Maker.

Microsoft Excel is the world's most popular tool for managing lists, from inventory to mailing addresses. Yet, printing that data onto sticky labels remains surprisingly difficult. The traditional "Word Mail Merge" wizard is clunky, complex, and prone to formatting errors.

This guide will walk you through a modern web-based approach that makes printing labels from Excel files (.xlsx or .xls) as easy as drag-and-drop.

The key steps are:

  1. Step 1: Clean the Excel sheet first.
  2. Step 2: Choose the label layout.
  3. Step 3: Upload the Excel file.
  4. Step 4: Map the columns onto the label.
  5. Step 5: Preview the full sheet.
  6. Step 6: Export the PDF and print at 100% scale.

The Problem with Word Mail Merge

If you've ever tried to print labels from Excel using Word, you know the pain points:

  • Complex Wizard: Navigating through multiple steps just to select a file.
  • Alignment Issues: Spending hours tweaking margins because the text drifts off the label.
  • Duplicate Design: You have to re-design your label every time you update your list.

A Better Solution: Web-Based Label Printing

Tools like Excel to Labels let you upload your Excel file directly to a browser-based designer. It handles parsing, layout, and PDF generation automatically. If you specifically need to print address labels from Excel, the more direct tool page is Address Label Maker. If you need more layout control for barcode, product, or custom sheet jobs, use Label Designer.

Step-by-Step: How to Print Labels from Excel

Step 1: Clean the Excel sheet first

Make sure your Excel file is well-structured.

  • Row 1: Use as headers (e.g., "Product Name", "SKU", "Price").
  • Row 2+: Your data.
  • No Merged Cells: Ensure columns are clean.
  • ZIP codes as text: Keep postal codes as text if they can start with 0.

Step 2: Choose the label layout

Before import, decide what kind of Excel label job this is:

  • Address labels: mailing labels, return labels, Avery 5160 sheets
  • Product labels: SKU, price, barcode, QR code
  • Shipping labels: recipient and order data
  • Custom labels: non-standard A4 or Letter sheet layouts

For mailing workflows, use Address Label Maker. For broader label design, continue in Excel to Labels or Label Designer.

Step 3: Upload the Excel file

Navigate to Excel to Labels and drop your Excel file into the upload zone. We support both .xlsx (modern) and .xls (legacy) formats.

Step 4: Map the columns onto the label

On the left sidebar, you will see your column headers. Drag "Product Name" to the canvas where you want it to appear. Do the same for "Price" or "SKU".

Step 5: Preview the full sheet

Before exporting, check for:

  • long names wrapping badly
  • blank rows creating blank labels
  • price and barcode columns mapped incorrectly
  • address lines overflowing small labels
  • sheet layouts that look fine individually but drift on the full page

If the sheet still prints off-center, read How to Fix Label Printing Misalignment.

Step 6: Export the PDF and print at 100% scale

Click Print. The system generates a high-resolution PDF with all your labels laid out on your chosen paper size (A4, Letter, etc.).

Set the print scale to 100% or Actual Size, not Fit.

Add barcodes from Excel (optional)

One of the biggest advantages over Word is dynamic barcode generation.

  • Drag a Barcode element onto your label.
  • Select your "SKU" column as the data source.
  • We automatically generate a valid barcode (Code128, UPC, EAN) for every row in your Excel file.

Common Excel Questions

Q: Does it support formulas? A: Yes! If you have a column that calculates a price (e.g., =A2*1.2), we import the calculated value, so your labels show the correct final price.

Q: Can I use images? A: Absolutely. If you have a column with public image URLs (e.g., hosted on your website), map it to an Image component, and we will render the product photo on the label.

Conclusion

Stop wasting time with outdated Mail Merge wizards. Upload your Excel file to Excel to Labels and get your printing done in minutes.

Try Excel to Labels

If you want to turn spreadsheet data into print-ready labels faster, try Excel to Labels. If you need to print address labels from Excel, use Address Label Maker. If you need broader layout control for shipping labels, product stickers, or custom sheet formats, continue in Label Designer.