Why does Excel truncate leading zeros on ZIP codes (e.g. 02134 turns to 2134)?

Excel automatically categorizes numbers as general numeric data, dropping leading zeros. LabelQueue's parser treats address columns as raw strings, preserving leading zeros for 5-digit ZIP codes and SKU codes.

Can I include barcodes when printing labels from Excel?

Yes! Map any column containing your SKU, tracking number, or serial code to the "Barcode Column" option. LabelQueue automatically renders verified vector Code 128 barcodes onto every label.

Are my confidential client and customer addresses uploaded to your server?

Never. LabelQueue operates on a 100% client-side privacy architecture. All spreadsheet reading, field mapping, and PDF compilation run locally inside your browser memory using WebAssembly. No data is ever transmitted across the internet.

How many sheets will be generated if I have hundreds of addresses?

LabelQueue automatically calculates total pages needed (e.g. 300 addresses on Avery 5160 creates a 10-page PDF). Our interactive preview includes a "Page 1 of N" pager so you can inspect every sheet before printing.

Print Labels from Excel & CSV (Free Online Mail Merge Wizard)

Skip Microsoft Word formatting headaches. Upload your spreadsheet, map columns in 3 clicks, preview multi-page sheets, and export aligned vector PDFs. 100% private.

100% Client-Side Sandbox72.0 DPI Vector

Loading Excel Mail Merge Engine...

Initializing spreadsheet parser & Avery layout generator

Mail Merge Tutorial

Say Goodbye to Microsoft Word Mail Merge: Complete Online Guide to Printing Labels from Excel

Why traditional desktop mail merge fails, how client-side parsing protects customer privacy, and the 5-step workflow.

The 5 Glaring Flaws of Microsoft Word Mail Merge

For over two decades, office professionals have relied on Microsoft Word’s "Mailings" tab to print address labels from Excel databases. Yet, Word Mail Merge remains one of the most frustrating legacy software workflows in computing history.

The "Locked Database" Bug: If your Excel spreadsheet is open when you trigger Word Mail Merge, Word locks the file and displays an obscure DDE/ODBC connection error.
Lost Leading Zeros: Excel treats ZIP codes beginning with zero (such as Boston 02134 or New Jersey 07030) as standard numbers, truncating the first zero and generating undeliverable mailings.
Accumulated Vertical Creep: Word treats Avery sheets as standard text tables. Hidden line spacing causes addresses on bottom rows to slip across die-cut boundaries.
Lack of Real Barcode Support: Word cannot natively render vector Code 128 or UPC-A barcodes without installing custom third-party TrueType barcode fonts that distort when printed on different machines.
Cloud Privacy Concerns: Uploading Excel spreadsheets to generic online converters exposes confidential customer contact lists to remote web servers.

How LabelQueue Solves Mail Merge in 3 Clicks

LabelQueue re-engineers mail merge from first principles. By combining SheetJS binary parsing with pdf-lib PostScript point calibration, you drag and drop your spreadsheet, select your desired Avery or thermal roll stock, and download an unwatermarked, multi-page vector PDF in seconds. All computation happens locally in your browser memory—no database records, no network uploads, and 100% data confidentiality.

Avery 5160 Standard Layout Reference

Physical Metric Calibration Spec: Avery 5160 / 8160 Address Labels

72.0 pt/inch PostScript Engine

Layout Configuration	3 Columns × 10 Rows (30 Labels per Sheet)
Label Dimensions	2.625" × 1" (66.675 mm × 25.4 mm)[189pt × 72pt]
Sheet Page Size	8.5" × 11" (215.9 mm × 279.4 mm)
Top & Left Margins	Top: 0.5" (12.7 mm) / Left: 0.1875" (4.762 mm)
Inter-Label Gaps	Horizontal: 0.125" (3.175 mm) / Vertical: 0" (0 mm)
Recommended Media	Mailing envelopes, barcode price tags, bin storage markers (LASER & INKJET)
Compatible Avery SKUs	51608160526059606240652165256585846015660

Frequently Asked Questions: Excel to Labels Mail Merge

Everything you need to know about physical margin calibration, print scale, and barcode readability.

Step 1: Upload your .xlsx or .csv spreadsheet into LabelQueue. Step 2: Choose your Avery template (e.g. Avery 5160 or 5163) and map your column headers (Name, Address, City/State/ZIP, Barcode). Step 3: Click "Download Multi-Page PDF" and print at 100% actual size.