How to Make Labels from Google Sheets for Free (No Mail Merge, No Word)

You have a Google Sheets file with your product names, prices, or addresses. You need labels. The traditional answer is "use Word Mail Merge" — which means exporting to Excel, opening Word, setting up a Mail Merge, linking your data, formatting the output, and praying it doesn't break when you print.

There's a much faster way.

What You'll Need#

• Your data in Google Sheets (any columns — product name, price, address, barcode, SKU, whatever)
• A printer
• Label sheets (Avery 5160 for small labels, Avery 5163 for larger ones — or a thermal printer)
• Labeliy — free, no install

That's it. No Word. No Mail Merge. No add-ons.

Step 1 — Set Up Your Google Sheet#

Make sure your sheet has a header row — the first row should be column names, not data.

Example:

product_name	price	barcode
Cotton T-Shirt	₹499	8901234567890
Denim Jeans	₹1,299	8901234567891
Baseball Cap	₹299	8901234567892

Keep column names simple — no spaces (use underscores instead), no special characters. You'll match these to your label design in a moment.

Step 2 — Open Labeliy and Pick Your Sheet#

Go to labeliy.com/label-maker.

Click Paper Type, choose Label Sheet, and search for your Avery format. If you're not sure, Avery 5160 is the most common — 30 small labels per sheet.

If you have a thermal printer (Zebra, Dymo, Rollo), choose Thermal / Custom and enter your label size.

Step 3 — Apply a Label Template#

Click Label Design, then browse the templates. Pick one that matches what you're making — price tag, barcode label, address label, etc.

The template already has fields set up. The column names in the template (like product_name, price) need to match your spreadsheet headers — this is what connects your data to the label.

If your spreadsheet uses different column names, you can either:

• Rename the columns in your Google Sheet to match the template
• Or open the canvas editor in Labeliy and rename the dynamic element to match your column

Step 4 — Copy and Paste from Google Sheets#

This is the fastest method — no file upload needed.

1. In Google Sheets, select your data rows (not the header row — just the data)
2. Copy (Ctrl+C on Windows, ⌘C on Mac)
3. In Labeliy, click the Data Source section
4. Click the first cell of the first row in the table
5. Paste (Ctrl+V / ⌘V)

Your data fills in automatically. Each row becomes one label.

Include the header row when pasting if you want Labeliy to auto-map the columns. Select from row 1 (headers) down to your last row of data, copy, then paste — Labeliy recognises the first row as headers and maps the columns automatically.

Step 5 — Or Upload the File Instead#

If you prefer uploading:

1. In Google Sheets, go to File → Download → CSV (.csv)
2. In Labeliy, click Data Source → Import tab → Choose File
3. Select the CSV you just downloaded
4. Labeliy reads the headers and maps them to your label elements
5. Click Apply

Same result, slightly more steps than copy-paste.

Step 6 — Preview and Print#

Check the label preview on the right side — you should see your first row's data on the label. Scroll through or check a few rows.

When it looks right, click Print Labels.

In the print dialog:

• Scale: 100% (the single most important setting)
• Margins: None
• Paper size: match your label sheet (Letter for US, A4 for most others)

Click Print. Done.

Tips#

Print a test on plain paper first. Before using real label sheets, print one page on regular paper and lay it on top of your label sheet. Hold both up to a light. The printed text should sit exactly inside each label cell. If it's off, check your scale setting.

For addresses, keep the full name in one column. If your sheet has separate First Name and Last Name columns, combine them in Google Sheets with a formula: =A2&" "&B2 and paste that combined column into Labeliy.

Quantities. If you need 3 copies of one label and 5 of another, add a quantity column in your sheet. When you import, set the Quantity column in Labeliy's data table to match. Labeliy will print the right number of each automatically.

Save your configuration. After printing, click Save Configuration in Labeliy. Next week when you need to reprint with updated prices, just open the saved config, paste your new data, and print. You don't have to set up the sheet format and design again.

Why Not Just Use Word Mail Merge?#

Word Mail Merge works, but it's slow and fragile:

• You have to export from Sheets to Excel first (or connect via Power Query)
• Setting up the merge document is fiddly — margins, label sizes, field codes
• The output often needs tweaking before it prints correctly
• If your data changes, you start most of the process over

With Labeliy, you paste your data and it's done. The label size, sheet format, and design are saved. Updates take 30 seconds.

For anyone printing labels more than once, that time saving adds up fast.