How to print labels from Google Sheets
You can print labels from Google Sheets without an add-on. Publish the sheet to the web as CSV, paste that link in the free label maker, and print one label per row. No signup.
How to print labels from Google Sheets
- In Google Sheets, use File, Share, Publish to the web. Pick the tab, choose Comma-separated values, and copy the link.
- Open https://app.mylabelmaker.com. No signup.
- Paste the published link. The first row of the sheet must be the column names.
- Click the columns onto the label. Check the rows for this run.
- Print. When someone edits the Google Sheet, publish again if you need the new rows.
A club list lives in a Google Sheet because three people add households during the week. On Thursday you need return labels, not a new spreadsheet. Publish the tab, paste the link, and the names are on 30252 labels.
| Name | Street | City |
|---|---|---|
| Neo Cole | 14 Pine St | Bend |
| Ava Singh | 88 Oak Ave | Bend |
| Luis Ortega | 3 River Rd | Bend |
Publish to the web, as CSV
File, then Share, then Publish to the web. Pick CSV. The link you paste is the published one. The link from the Share button, the one that asks people to sign in, does not load the rows.
The fetch goes to Google, because that is where the sheet is. The label you design stays in this browser. There is no account on this site.
Click Name, Street, and City onto the label. Check the households you are printing tonight. Print from this computer for a LabelWriter or a letter sheet, or send the job to a Zebra printer with Browser Print.
The other Sheets page is create labels from Google Sheets. Mail merge wording for the same job is mail merge labels from Google Sheets.
Questions people ask
How do I print labels from Google Sheets?
Publish the sheet to the web as CSV, paste that link, click the column names onto the label, and print the rows you checked. One row becomes one label.
Why will my share link not load?
A share link expects a Google sign-in. Publish to the web as CSV and paste that link instead.
Do I need a Google Sheets add-on?
No. Publish as CSV and paste the link. No signup on this site either.
Paste the published sheet
They keep editing Google Sheets. You print the labels.
Open free label maker