Sheets To Labels

How to Print Labels from Google Sheets | Step-by-Step Guide

Apr 13, 2026

Print labels from Google Sheets in SheetsToLabels

To print labels from Google Sheets, clean the sheet first, import it into a label workflow, choose the label format, map the sheet columns to the design, preview the full batch, and export the PDF at 100% scale.

If you want the shortest product-first path, start with Google Sheets to Labels. If the job is mainly addresses and mailing sheets, use Address Label Maker. If you need full design freedom for product, shipping, barcode, or QR labels, use Label Designer.

The key steps are:

  1. Step 1: Clean the sheet first.
  2. Step 2: Choose how to bring the sheet in.
  3. Step 3: Pick the label layout.
  4. Step 4: Map spreadsheet columns to the label.
  5. Step 5: Preview the full batch.
  6. Step 6: Export the PDF and print at 100% scale.

Most people searching this are not trying to design labels inside Google Sheets itself.

They usually already have:

  • one Google Sheet with the real rows
  • one label job that repeats
  • one need to export a print-ready PDF without rebuilding the layout in Google Docs each time

That is why the real workflow is:

  1. clean the sheet
  2. import the sheet
  3. choose the label format
  4. map the columns
  5. preview the output
  6. print the PDF correctly

Typical columns depend on the label type:

  • mailing labels: name, address, city, state, zip
  • product labels: product_name, sku, price, barcode
  • inventory labels: item_name, asset_id, location, qr_url
  • shipping labels: recipient, street, postal_code, country

Best practices before import

  • Put headers in Row 1.
  • Remove blank rows in the middle of the list.
  • Keep values formatted consistently.
  • Use one row per label.
  • Only keep columns that really need to print.

Step-by-Step: How to Print Labels from Google Sheets

Step 1: Clean the sheet first

Google Sheets works best when the data is simple and stable.

Check these items before import:

  • every label belongs to exactly one row
  • header names are clear
  • spelling and capitalization are final
  • long values are cleaned up before printing
  • blank rows are removed

Prepare Google Sheets data before printing labels

Step 2: Choose how to bring the sheet in

You have two practical options:

  1. Use the Google Sheets import flow at Import Data.
  2. Export the sheet as CSV and use the CSV workflow if that is simpler for your setup.

If you are printing mailing labels, the best conversion path is usually Address Label Maker. If you need broader product, shipping, or barcode layouts, use Label Designer.

Import Google Sheets data into SheetsToLabels

Step 3: Pick the label layout

Before generating the full batch, decide what you are printing:

  • address labels such as Avery 5160
  • return address labels
  • product labels
  • barcode labels
  • shipping labels
  • custom A4 or US Letter sheet layouts

If your job is mainly mailing labels, start with Address Label Maker. If you need more control over barcode, product, or custom sheet layouts, use Label Designer.

Choose the label template and layout

Step 4: Map spreadsheet columns to the label

After import, map the relevant fields once:

  • name to the main text line
  • address to the address block
  • price to the price area
  • sku to barcode or text
  • qr_url to a QR code element

This is the point where Google Sheets becomes useful: one clean sheet can generate dozens or hundreds of labels without editing each label individually.

Map Google Sheets columns to label elements

Step 5: Preview the full batch

Before exporting, scan the preview for:

  • long names wrapping badly
  • blank labels caused by blank rows
  • ZIP or postal codes losing formatting
  • barcodes using the wrong source column
  • labels that look fine alone but break in the full sheet layout

Fix the sheet first, then refresh or re-import. That is faster than repairing the exported PDF later.

Preview the full label sheet before export

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

When the preview looks right:

  1. Export one PDF for the full batch.
  2. Open it in Acrobat or Preview.
  3. Print on label stock or plain paper for a test run.
  4. Set scale to 100% / Actual Size.
  5. Run one alignment test before the final print.

For most setups, that one setting, 100% / Actual Size, is the difference between aligned labels and wasted stock.

Export the PDF and print at 100 percent scale

Common problems when printing labels from Google Sheets

Some labels are blank

Blank rows in the Google Sheet often create blank output rows. Delete them before import.

ZIP codes lost leading zeros

Keep ZIP and postal code columns as text in the source sheet before importing.

The PDF does not line up with Avery stock

Print scaling is usually the issue. Make sure the PDF viewer is not using Fit, Shrink, or another auto-scaling mode.

I updated the sheet but the labels did not update

Refresh or re-import the data before exporting again. Treat the sheet as the source of truth.

When Google Sheets is the right workflow

Google Sheets is the best starting point when:

  • multiple people edit the list
  • inventory or mailing data changes often
  • you want to avoid repeated CSV exports
  • the spreadsheet is already the source of truth

If you are working from a static file export instead, the better article is Excel to Labels. If you specifically want address labels, the better tool page is Address Label Maker.

Try the right workspace

If you want the fastest route from Google Sheets to printable labels, start with Google Sheets to Labels. If the job is mainly addresses and mailing sheets, use Address Label Maker. If you need full design freedom for product, shipping, barcode, or QR labels, use Label Designer.