Peelstack Label Maker docs

Start here10 min read5 sections

Help

Can't find your answer? Email peelstack@taskivator.com; we aim to answer within two business days. Include the error code if the add-on showed one.

Get the add-on

Get Peelstack Label Maker on the Google Workspace™ Marketplace

  1. Open Peelstack Label Maker on the Google Workspace™ Marketplace and click Install. Or, in Google Sheets™, choose Extensions, Add-ons, Get add-ons and search for Peelstack Label Maker.
  2. Allow the permissions Google shows. Our privacy policy explains each one.
  3. Open a sheet or a document and choose Extensions, Peelstack Label Maker, Create labels.

It works in Google Sheets™ and Google Docs™ on a computer, in a desktop browser. Free for up to 30 labels per run, with the same features as the paid plans.

Paper size: the same as your labels (Letter or A4), in both the print dialog and the printer settings.
Scale: Actual size or 100%. Turn off Fit to paper, Fit to printable area and Fit to page.
Best results: open the PDF in Adobe Acrobat Reader. Browsers sometimes shrink pages on their own.

On a Chromebook

Adobe's desktop Acrobat Reader is made for Windows and Mac, not ChromeOS. On a Chromebook, open the PDF in Chrome (for example, drag it from the Files app into a Chrome tab) and print from Chrome's PDF viewer:

  • Open More settings in the print dialog.
  • Paper size: the same as your labels (Letter or A4).
  • Scale: Default (100%), or Actual size if your dialog lists that instead. Not Fit to printable area or Fit to paper. Chrome remembers the last scale you used for a PDF, so check it each time.
  • Margins: leave them as they are. Chrome offers no margin setting when it prints a PDF, and the PDF already has the right margins.

Print the test page on plain paper first ("Labels print a little off? Align your printer" in the add-on).

School and work accounts

At a school or company, a Google Workspace administrator decides which Google Workspace™ Marketplace apps people can install. If they have not allowed Peelstack Label Maker, the Marketplace shows a message such as "This application is not allowed by your administrator." or "This application has been blocked by your administrator." Only an administrator can change this. Send them our guide for Google Workspace administrators, which gives the steps from Google's own help pages.

Networks that filter web traffic must also let the add-on window load its files. Besides Google Sheets™ and Google Docs™ themselves, it loads files from:

  • cdn.jsdelivr.net: the add-on window's program code (such as the PDF writer, the font engine and the QR code maker) and its fonts, pinned to exact versions and checked against integrity hashes. Without it the add-on window cannot make labels.
  • ssl.gstatic.com: Google's standard style sheet for add-ons.
  • *.googleusercontent.com: the add-on window itself, which Google serves from this domain for every Apps Script add-on.
  • checkout.stripe.com: Stripe's checkout page, opened in a new tab only when someone buys a paid plan.

Our licence server is called from Google's servers, not from your computer, so it needs nothing on your network.

Questions

How do I print on Avery 5160 from Google Sheets™?

Open your sheet, then Extensions, Peelstack Label Maker, Create labels. Type 5160, check the preview and click Download PDF. Print it on Letter paper at Actual size (100%). 8160, 18160 and other codes with the same layout work the same way.

My labels print a little too high, too low or to one side.

If every label is off by the same amount, open "Labels print a little off? Align your printer" in the add-on, print the test page on plain paper, and enter the small offset it shows. We remember it for that paper size. If the error grows further down the page, the page is being resized: set the paper size (Letter or A4) and Actual size in the print dialog and in the printer settings, and turn off any Fit option (Fit to paper, Fit to printable area, Fit to page).

Which template do I choose? My box says 8160 / 18160 / L7160.

Type the number printed on the box. Most codes work, including the other codes Avery prints for the same layout: we map them to the layout and show a picture of the sheet (labels across and down, label size) so you can compare. Not listed? Enter the size under "My labels are not listed".

Can I print on a sheet I have already used part of?

Yes. In the preview, click the first empty label. Printing starts there and continues on new sheets.

Can I print only some rows?

Yes: all rows, the rows you selected in the sheet, or the rows your filter shows. A filter by values (ticking values in the filter menu) is read at once, however long the list. Google Sheets™ tells an add-on about other filters (a condition or a colour) and about rows hidden by hand only one row at a time: on a long list a condition filter can take too long (select the rows and choose "Rows I selected in the sheet" instead), and the sidebar says how many rows it could not check for being hidden by hand. Google Sheets™ does not tell add-ons which rows a slicer hides, so for those use a filter (Data, Create a filter) or select the rows. Labels follow the order of your sheet, so sort the sheet to sort the labels.

How do I put first and last name, or City, State and ZIP, on one line?

Each line can combine several columns with your own spaces and commas, for example {First Name} {Last Name} or {City}, {State} {ZIP}. We suggest the lines from your column names.

Why is there no blank line when Address 2 is empty?

A line whose columns are all empty is left out automatically, so the address closes up.

My ZIP codes lost their leading zero.

We print what the cell shows. If the sheet shows 2134 instead of 02134, format the column as Plain text (Format, Number, Plain text) and type the zero, or use the custom number format 00000. The preview warns you about 4 digit ZIP codes.

Can I print several labels of each row, or a whole sheet of my return address?

Yes. Set "Copies of each row", take the number from a column, use "A full sheet of each row", or tick "Same text on every label" and type your return address.

Can I make the name bold or bigger, or centre the text?

Yes. Each line can be bold, larger or in capital letters, so the name can stand out on every label without editing them one by one. The text can be left aligned or centred, and any line can be centred on its own, in one of twelve fonts (sans serif, serif, condensed, handwriting or script).

My text is too long.

We shrink text to fit each label, so one label does not push the others. Labels that had to be shrunk or shortened are listed by row number in the preview, so you can fix them before printing.

Can I print names and addresses in Arabic, Chinese, Hindi or other languages?

Yes, in 24 writing systems. Arabic and Hebrew run right to left, Chinese, Japanese and Korean use matching fonts, and scripts such as Hindi, Bengali, Tamil, Thai and Burmese are shaped correctly, on the same sheet as English. If a character is in no font we have, it would print as an empty box, so the preview warns first and names the rows and the characters, and you can change them before printing. See the guide on labels in other languages.

Can I add a QR code, a barcode or a logo?

Yes. Under "Picture, QR code or barcode", make a QR code from any column (a link, an SKU), a barcode from any column (Code 128 for item codes and asset tags; EAN-13 or UPC-A for product numbers), or put the same picture on every label. They appear in the PDF. If a code would be too small to scan on your label, the preview lists the rows. Code 128 holds unaccented letters, digits, spaces and common symbols. For EAN-13 and UPC-A the check digit is added when your number leaves it out, and a number with a wrong check digit is not printed; the numbers themselves must be registered with GS1 for products sold in shops. See the guides on QR code and barcode labels.

Can I save my label setup for next time?

Yes. The add-on remembers the last setup for each spreadsheet by itself, and under "Saved designs" you can keep up to 20 named designs, for example "Christmas cards", and open one in a click.

Does it work with A4, UK and European labels?

Yes: Avery L7160, L7161, L7162, L7163, L7165, L7159, L7651, Avery Zweckform and more. If A4 labels drift down the page, your printer or browser is probably set to Letter: set A4 and Actual size.

Is there a limit on the free plan?

Peelstack Label Maker is free for up to 30 labels per run, one full sheet of Avery 5160 address labels, with the same features as the paid plans, and you can run it as often as you like. A longer list prints its first 30 labels on the free plan, and the preview shows those labels. The test pages are free. A paid plan removes the 30 label limit: $29 for one year or $59 once. No subscription, nothing renews. The free and paid plans read a sheet the same way; a paid plan prints a longer list in one run.

I have more than 30 addresses. Can I still use the free plan?

Yes. Each run prints up to 30 labels, so you can print the list in parts: select the rows for one sheet, choose "Rows I selected in the sheet", print, then select the next rows. A paid plan prints the whole list in one run, up to 50,000 labels and 10,000 rows at a time.

Does it work on a phone or tablet?

It works in Google Sheets™ and Google Docs™ on a computer, in a desktop browser. The Google Sheets™ and Google Docs™ mobile apps do not run add-ons.

The add-on will not open, or says authorization is required.

This usually means you are signed in to more than one Google account in the browser. Open the sheet in a window where only one account is signed in (a separate browser profile or a private window). At school or work, your administrator may need to allow the add-on: see "School and work accounts" on this page.

My file is an Excel file (.xlsx) and I do not see the add-on.

Add-ons only run in Google Sheets™ files. Choose File, Save as Google Sheets™, then open the add-on in the new file.

Should I print the PDF or the Google Doc™?

Print the PDF for the best alignment: it is made at your label sheet's published sizes. Use the Google Doc™ when you want to change a single label by hand; if you print the Doc, set margins to None and scale to 100%.

Why do you need these permissions? Is my list safe?

We read only the spreadsheet you have open, and create only the files you ask for (the PDF in your downloads, and a Google Doc™ or a PDF in your Drive if you choose). We cannot see your other files. Your list is turned into labels in your browser and your Google account; it is not sent to our servers. The add-on calls our server only about your plan: to check it, with a token signed by Google that holds your Google account ID (if you installed from the Google Workspace™ Marketplace, it can also carry your email address and name; our server reads only the account ID and stores neither), and, when you choose a paid plan, to start the checkout, with your account ID, the plan and your language. The privacy policy has the details.

Do you ask for reviews in return for free use?

No. The free plan has the same features as a paid plan, so there is nothing to unlock.

Used Peelstack Label Maker? An honest review on the Google Workspace™ Marketplace helps other people find it. Reviews are public, and we do not offer anything in return.

Guides

English