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

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 each Excel row should fill a PDF form, certificate, invoice, contract, or other reusable PDF template, use Fill PDF from Excel, Google Sheets, or CSV instead.

Microsoft Excel is the world's most popular tool for managing lists, from inventory to mailing addresses. Yet, printing address labels from Excel 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.

Comparison: Microsoft Word vs. SheetsToLabels

---

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 Amazon FBA shipments, use the dedicated FBA FNSKU Label Maker. For broader label design, continue in Excel to Labels or Label Designer.

If the output is not a label sheet at all, but one personalized PDF per Excel row, use the PDF mail merge workflow instead of forcing the job into a label layout.

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 & Database 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.

Q: Can I import data from Airtable or Notion? A: Yes! You can easily export your Airtable or Notion tables as a .csv file. Once exported, drop the CSV file into our online converter just like an Excel sheet. Read our dedicated guide on How to Print Labels from Airtable for more details.

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.

Related Reading

• Need mailing labels specifically? Read How to Print Address Labels from Excel or Google Sheets.
• Need a Google Sheets workflow instead? Read How to Print Labels from Google Sheets.
• Need FBA barcodes? Read How to Bulk Generate Amazon FBA FNSKU Barcode Labels from Excel.
• Alignment off when printing? Read How to Fix Label Printing Misalignment.
• Need PDFs instead of labels? Read How to Generate One PDF Per Row from Excel.
• Working with static templates? Read How to Fill a Non-Fillable PDF from Excel or Google Sheets.