How to Print Labels from Word, Google Docs, and Spreadsheets

Overview

Printing labels successfully depends on three things: matching the document to the physical label stock, keeping your data structured, and testing the alignment before printing the entire batch. Word is usually the most direct option for mail merge labels, while Google Docs can work well when your team stores data in Google Sheets and collaborates in the browser. A spreadsheet remains the best source of truth when the same names, addresses, SKUs, or storage locations will be reused.

Before opening a template, identify the label sheet or roll you will use. Record the label width and height, the number of columns and rows, the gap between labels, and the margins around the sheet. These measurements determine whether a built-in template will fit. If you need to compare common dimensions, use the printable label size guide before setting up the document.

For individual labels, a simple table or label template may be enough. For a batch, use mail merge. Mail merge takes one document layout and fills it with records from a spreadsheet, reducing repetitive typing and making updates easier. It is useful for mailing lists, inventory labels, employee folders, event name tags, product batches, and storage bins.

Prepare a clean source spreadsheet

Use the first row for field names and keep each following row as one complete label record. A basic address-label sheet might use these columns:

• Name: the recipient, customer, contact, or item name.
• Company: an optional business or department name.
• Address 1: the main street or delivery line.
• Address 2: an optional apartment, suite, or unit line.
• City: the town or city.
• Region: the state, province, county, or equivalent.
• Postal code: keep the value as text if leading zeroes matter.
• Country: include it when the batch crosses borders.

For product or storage labels, replace address fields with columns such as SKU, product name, batch, location, quantity, or expiry date. Avoid merged cells, blank header rows, duplicate column names, and extra notes beneath the data. Standardize capitalization and remove accidental spaces before starting the merge.

Checklist by scenario

Print address labels from a spreadsheet using Word

1. Confirm the stock. Check the package or sheet specifications and choose a Word label layout that matches the label dimensions and page arrangement. Do not select a template based only on its product number unless the stock and template are known to correspond.
2. Open the mail merge workflow. In Word, look for the Mailings tools and choose the option for labels or a new mail merge using the label format. Menu names can vary by Word version, so use the equivalent label or mail-merge command if the wording differs.
3. Connect the spreadsheet. Select the workbook and the worksheet containing the prepared records. Confirm that the first row is treated as field names.
4. Insert the fields. Build the first label with the fields in the order you want. For an address, place the name on the first line, company on the next if needed, followed by address, city and region, and postal code.
5. Preview the records. Move through several records, including one with a long name, a blank optional field, and a longer address. Check that lines do not wrap into the wrong area.
6. Propagate the layout. Use Word's command to update or replicate the first label across the sheet. This step is essential; editing only the first label can leave the remaining cells blank or incorrectly formatted.
7. Print a plain-paper test. Print one page on ordinary paper, place it behind a label sheet, and hold both toward a light source. Compare the text with the label boundaries before loading label stock.
8. Print the final batch. Use the correct paper size and print scale. If the result is aligned, print the remaining pages and retain the source file for the next batch.

Create a Google Docs label workflow

Google Docs does not always provide the same built-in label and mail-merge workflow as desktop Word. A practical Google-based process is to keep the records in Google Sheets, create the layout in a compatible label template or label-focused add-on, and generate a document for review before printing. Available menu names and add-on behavior can change, so verify the current instructions inside your Google Workspace environment.

1. Format the Google Sheet with one record per row and clearly named columns.
2. Choose a Google Docs label template that matches the physical sheet, or create a table with the exact number of columns and rows.
3. Use the template or approved add-on to place spreadsheet fields into the label layout.
4. Review several generated labels, paying particular attention to empty fields and long text.
5. Download or print the completed document using the actual label page size and a scale setting that does not enlarge or shrink the page.

For a small number of labels, copying a formatted table row may be faster than setting up a merge. For recurring batches, keep a master Google Sheet and a named template so the workflow is repeatable rather than rebuilt from scratch.

Print product, name, or folder labels

Start with the shortest useful content. Product labels may need a product name, variant, SKU, and batch reference; folder labels may need a department, project, or date; name labels may need a first name and organization. Put variable information in spreadsheet columns and keep design elements—such as a logo, border, or fixed heading—in the template.

Use a consistent naming convention for files, such as product-labels-template and product-labels-2026-10. If a label includes a QR code, test the printed code at its final size rather than assuming that a code that works on screen will scan after printing. See the guide to creating and maintaining QR code labels for a separate checklist.

What to double-check

• Label dimensions: Confirm width, height, corner shape, gaps, and the number of labels per page. Small differences can shift every row.
• Page and printer settings: Select the correct paper size and feed direction. Turn off options such as “fit to page,” “shrink oversized pages,” or other automatic scaling when exact alignment matters.
• Margins and gutters: Compare the document's top, bottom, left, and right margins with the label sheet. A consistent shift often points to a margin or feed setting.
• Data fields: Check that every merge field maps to the intended spreadsheet column. Look for postal codes converted to numbers, dates displayed in an unexpected format, and blank optional fields leaving unwanted spaces.
• Text overflow: Test the longest likely value. Reduce font size, adjust line spacing, or simplify the field combination if text crosses a label boundary.
• Printer feed: Load sheets according to the printer's instructions and use the recommended media setting where available. Test with one sheet first.
• Label stock condition: Do not use sheets with lifted corners, wrinkles, or partially removed labels. Loose adhesive material can cause feeding problems in some printers.

If your labels are consistently too high, low, left, or right, adjust the document layout only after confirming the printer is not scaling the page. If the error grows from one row to the next, check the row height, vertical pitch, or spacing between labels rather than changing the outer margins.

Common mistakes

Avoid printing directly onto an expensive batch until the plain-paper overlay test passes. Keep one successful blank template and one completed sample as references. If label production is part of a wider inventory or fulfillment process, the labeling workflow guide can help organize naming, verification, and handoff steps.

When to revisit

Return to this checklist whenever the label stock, printer, software, spreadsheet structure, or information on the label changes. A template that worked for one sheet size may not work for another, even when the labels look similar. Recheck the workflow before seasonal mailing cycles, new product runs, office moves, inventory counts, or any recurring operation where a batch is produced after a long gap.

Review the process after a Word, Google Workspace, printer-driver, or label-maker-app change. Menu paths and template compatibility can change, and a new default print setting may introduce scaling. Also revisit the data columns when a team adds a new field, such as a batch code, country, storage zone, or QR destination.

Before your next print run, use this short final checklist:

1. Confirm the exact label stock and document template.
2. Clean and validate the source spreadsheet.
3. Preview a short, long, blank, and unusual record.
4. Print one plain-paper alignment test.
5. Check page size, feed direction, and actual-size printing.
6. Print one label sheet and inspect it before continuing.
7. Save the verified template and date the source file.

For recurring work, document the successful settings beside the template: stock dimensions, printer, orientation, feed direction, and any approved adjustments. That small record turns label printing into a repeatable office workflow instead of a last-minute formatting exercise.