How to Print Labels from Google Sheets

Google Docs has no built-in label merge, and most add-ons ask for access to your whole Google Drive. You don’t need one: copy the rows from Google Sheets into LabelSheet and the labels are made in your browser.

1. Set up the sheet

Use the first row for column names and one row per label:

name	street	city	country
Ana Souza	Rua das Flores 12	São Paulo	Brazil
Ken Sato	2-3-1 Shibuya	Tokyo	Japan

Keep names short (name, city) because you’ll type them as {{name}}, {{city}}.

2. Copy the rows

Click the top-left cell, Shift-click the bottom-right cell (include the header row), and press Ctrl+C (⌘C on Mac).

Alternatively choose File → Download → Comma-separated values (.csv) and upload that file.

3. Paste into LabelSheet

1. Open the label maker and pick your label sheet.
2. Go to Data & copies → Mail merge from a spreadsheet.
3. Paste into the box. Google Sheets copies as tab-separated text, which LabelSheet reads directly.

4. Insert fields and print

Click the label text and insert the field buttons — or type {{name}}, {{street}}, {{city}} on separate lines. Check the sheet preview, then Download PDF and print at 100% / Actual size.

Useful tricks

• Several copies per row: set Copies of each label (e.g. 2 labels per guest).
• Combine columns in the sheet: =B2&", "&C2 creates “city, country” in a new column.
• Filter first: use a filter view in Google Sheets, then copy only the visible rows.
• Different label per product: the same works for product names, prices and SKUs — use the fields in a barcode or QR code.

Because nothing is uploaded, you don’t have to grant any app access to your Google account.