Creating Printable Labels from Excel Data
Printing labels one by one is slow and error-prone. With Mergram, you can take an Excel spreadsheet of names, addresses, or product data and generate an entire sheet of printable labels in one operation. This guide covers everything from designing your label layout to printing on label paper.
Prerequisites
Before you begin, gather the following:
- A label sheet specification — know your paper size (Letter, A4) and label dimensions
- An Excel or CSV file with your label data organized in columns
- A PDF template matching your sheet dimensions, or the ability to create one
- A free Mergram account
Label paper dimensions
Common label sheet sizes include Avery 5160 (1” x 2.63”, 30 per Letter page), Avery 5162 (1.33” x 4”, 14 per page), and Avery 5163 (2” x 4”, 10 per page). Check your label paper packaging for exact dimensions and use those measurements when positioning fields.
Types of Labels You Can Create
| Label Type | Typical Fields | Common Use |
|---|---|---|
| Address labels | Name, street, city, state, zip | Mailing lists, direct mail |
| Shipping labels | To/from address, weight, tracking barcode | E-commerce, fulfillment |
| Name badges | Name, title, company, QR code | Conferences, events |
| Product labels | Product name, price, barcode, SKU | Retail, inventory |
| File folder labels | Category, date, description | Office organization |
| Inventory tags | Asset ID, barcode, location, department | Asset management |
Preparing Your Spreadsheet
Organize your data with one row per label. Use separate columns for each field component:
| FirstName | LastName | Company | Street | City | State | Zip |
|---|---|---|---|---|---|---|
| Alice | Chen | Acme Corp | 123 Main St | Springfield | IL | 62701 |
| Bob | Martinez | Globex Inc | 456 Oak Ave | Austin | TX | 73301 |
| Carol | Johnson | Initech | 789 Elm Blvd | Portland | OR | 97201 |
| David | Kim | Umbrella Co | 321 Pine Rd | Denver | CO | 80201 |
Combine fields for display
You don’t need a “Full Name” column. Place FirstName and LastName fields side by side on the canvas with a space between them. This gives you more layout flexibility than a single concatenated column.
Designing Your Label Template
Step 1: Create the Base PDF
Create a blank PDF matching your label sheet size. You can:
- Use a blank Letter or A4 PDF as your template
- Add light grid lines or outlines during design (remove before final merge)
- Set the page size to match your label paper exactly
Step 2: Place Fields on the Canvas
In the Mergram editor, drag columns from your data panel onto the canvas to create text fields. Position each field within a single label’s boundaries:
- Name line: Place
FirstNameandLastNamefields on the first line - Company line: Place
Companybelow the name - Address line: Place
Streeton the third line - City/State/Zip line: Place
City,State, andZipon the fourth line
Adjust font sizes to fit within the label area — 9–11pt works well for address labels.
Step 3: Add Barcodes for Shipping Labels
For shipping or inventory labels, add a barcode field:
- Select the TrackingNumber column from your data fields
- Change the render type from “Text” to “Barcode”
- Position the barcode below the address text
- Barcodes scale to fill the bounding box width — drag the box wider for a wider barcode. Adjust the barcode height and margin settings in the properties panel to control vertical dimensions
Printing Tips for Label Paper
Getting labels aligned correctly on pre-cut label paper requires careful print settings:
| Setting | Recommended Value | Why |
|---|---|---|
| Page scaling | None (100%) | Prevents label size distortion |
| Page margins | Minimum or none | Label paper has built-in margins |
| Orientation | Match template | Wrong orientation misaligns all labels |
| Duplex (double-sided) | Off | Label paper is single-sided |
| PDF reader | Adobe Reader | Most reliable for exact positioning |
Test on plain paper first
Before printing on expensive label paper, print the generated PDF on plain paper. Hold it up to the light against your label sheet to check alignment. Adjust field positions in the editor if needed, then reprint on label paper.
Generating a Combined Label Sheet
When merging, use the combined output mode to produce a single PDF with all labels on consecutive pages. This is ideal for printing entire label sheets at once:
- Each page contains as many labels as your layout allows
- Empty slots at the end of the last page are left blank
- The combined PDF is ready to print directly on label paper
If you need individual labels (one per PDF), use the individual output mode instead.
Using Filename Templates
For individual label output, set a meaningful filename template:
| Template | Example Output |
|---|---|
Label_[[LastName]]_[[Zip]] | Label_Chen_62701.pdf |
Shipping_[[Company]]_[[State]] | Shipping_Acme Corp_IL.pdf |
Badge_[[FirstName]][[LastName]] | Badge_AliceChen.pdf |
Common Issues and Troubleshooting
Labels are misaligned on the sheet: This is almost always a print scaling issue. Ensure your PDF reader is set to “Actual Size” or “100%” — not “Fit to Page” or “Shrink to Fit.” Even a 2% scale difference shifts labels noticeably by the bottom of the page.
Text overflows the label area: Reduce the font size for the overflowing field, or abbreviate the data in your spreadsheet (e.g., “St” instead of “Street”). You can also widen the field bounding box slightly.
Barcodes scan incorrectly: Ensure the barcode bounding box is wide enough for the encoded data. Widen the bounding box or use a shorter identifier format. Increase the barcode height setting for taller bars that are easier to scan.
Blank labels in the output: Check for empty rows in your spreadsheet. Filter or remove rows with missing data before merging to avoid wasting label slots.
Get Started
Upload a blank PDF, connect your address spreadsheet, and design your label layout in the Mergram editor. Preview with real data, then generate a complete sheet of printable labels in seconds.