Do you want to make mailing labels in Google Docs™? Peelstack Label Maker, an add-on, opens inside a Google Doc™. You copy your address list, paste it into the add-on, type the number on your label box and download a PDF made to the label sheet's published sizes, ready to print.
The list does not have to live in the Doc. You paste it into the add-on, so it can come from Google Sheets™, Excel or a CSV file. If your addresses are already in a Google Sheet™, you can also open the add-on there and skip the copying; this guide is for people who are working in Docs.
Step 1: Copy your address list
Put one address on each row and the column names, such as Name, Address, City, State and ZIP, in the first row. Select the cells including that first row and copy them (Ctrl+C, or Cmd+C on a Mac). In Excel and in a CSV file it works the same way.
Format the ZIP column as plain text first (Format, Number, Plain text in Google Sheets™), so codes like 02134 keep their leading zero. What your sheet shows is what prints.
Step 2: Open the add-on in a Google Doc™
- Open any Google Doc™, even a blank one.
- Choose Extensions, Peelstack Label Maker, Create labels. First time here? Choose Extensions, Add-ons, Get add-ons and search for Peelstack Label Maker.
- Allow the permissions Google shows. The add-on works on a computer in a desktop browser; the Google Docs™ mobile app does not run add-ons.
Step 3: Paste your list
Open Or paste a list (from Excel, a CSV file or anywhere), click into the box and paste. The list stays in the add-on window while you work.
Step 4: Pick your label code
Type the number on your label box, for example 5160 for Avery® 5160 (30 labels per sheet, US Letter) or L7160 for A4. The add-on draws the sheet so you can compare it with your own. See the list of supported label sheets, or enter a custom size under "My labels are not listed".
Step 5: Check what goes on each label
The add-on fills in the lines from your column names, for example {City}, {State} {ZIP}. Each box is one line: change them, add a line, or make a line bold. A line whose columns are all empty is left out, so a missing Address 2 does not leave a gap.
Want the same text on every label, such as a return address? Tick Same text on every label (for example a return address), type your address and choose how many labels you want.
Step 6: Look at the preview and print
- Read the live preview with your own addresses. Long text is shrunk to fit, and the preview lists the rows it had to shrink.
- Click Download PDF.
- Print the PDF at Actual size (or 100%) with "Fit to page" turned off, on the paper size of your label sheet. Print one page on plain paper first and hold it over a label sheet against a window.
If the labels are slightly off, print the test page on plain paper and set the small offset it shows: see how to fix misaligned labels. Got a half used sheet? Click the first empty label in the preview and printing starts there.
Can I edit one label by hand in the Doc?
Yes: under Editable Google Doc™ the add-on can create a Google Doc™ copy, so you can change a single label by hand. For the closest alignment print the PDF; if you print the Doc, set margins to None and scale to 100%.
What about a list that is already in a Google Sheet™?
Then open the add-on from the Sheet itself and it reads the rows you choose, so there is nothing to paste. The steps are in how to print address labels from Google Sheets™, and mail merge and mailing labels from Google Sheets™ explains copies, filters and numbering.
What it costs
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. The free and paid plans read a sheet the same way; a paid plan prints a longer list in one run. A paid plan removes the 30 label limit: $29 for one year or $59 once. No subscription, nothing renews.
Avery® is a trademark of Avery Products Corporation. Taskivator is not affiliated with Avery.