Template for Avery labels

[Gordon L]

For years I've used PagePlus for my Christmas Card mail labels. My computer with PagePlus has died but I exported the data to a spreadsheet. Can I import and print the data into an Avery label template on AP? Does anyone know where to find such a template?

Thanks in advance.

[BobMoyer]

Avery.com has a complete listing of free templates in various formats for their labels.  I have successfully used them with the Affinity line of products.

[Gordon L]

Thanks you. I had a look but Avery.com doesn't recognise my label number. I guess this is because its a UK A4 size label. The Avery UK website has the correct template but only for MS Word. However, it does have its own online version that appears to work well so I'll use that come December.

[Alfred]

4 minutes ago, Gordon L said:

The Avery UK website has the correct template but only for MS Word.

Doesn’t the UK site offer PDF files, too?

 

[MikeTO]

It appears that Avery.co.uk offers only MS Word templates while Avery.com also offers PDF, InDesign, Pages, and more. I checked the standard 7160/5160 sizes.

When scripting becomes available, I might write a script to generate Publisher templates for every Avery label size. I've done this before for another application and it's an easy script to write.

[walt.farrell]

13 minutes ago, MikeTO said:

It appears that Avery.co.uk offers only MS Word templates

Which should work as long as they're .docx format. If they're .doc they can be resaved using LibreOffice.

[MikeTO]

25 minutes ago, walt.farrell said:

Which should work as long as they're .docx format. If they're .doc they can be resaved using LibreOffice.

They're docx format but it still won't work if you convert them to docx. Even if you draw a text frame the exact right size (you'll need to calculate the size using the template's margins), the template's shapes will be in the wrong locations in Publisher and the table for data entry will be the wrong size, so the text won't align with the labels.

I tried it and the result was a mess. It would be better to use the move / duplicate feature to build your own template.

[wonderings]

there are free online converts for word to PDF.

https://acrobat.adobe.com/link/acrobat/word-to-pdf?x_api_client_id=adobe_com&x_api_client_location=word_to_pdf

Not sure if that is free or if you need an adobe account. If not free there are others that come up with a simple google search. 

 

A template is easy, but not necessary. In a matter of minutes you could have a document market out with the spacing required for what you plan to print onto the Avery label sheets. You are going to have to step and repeat anyways to fill up a page, measuring out the first label and the space between is not all that much more to do. 

 

[PaulEC]

11 minutes ago, wonderings said:

there are free online converts for word to PDF.

If you open a .doc in LibreOffice you can convert it to PDF from there, but I don't know if that helps to create label templates in APub. Personally I've always found it easier to create my own templates!

[pioneer]

Just as a thought, in the short term would it not solve the problem by just reinstalling pageplus on your PC? Xmas card labels Avery 7160 I think is the template I use for my Xmas card from PagePlus. PageplusX9 works fine on my win11 PC.

[Gordon L]

Thanks to all for the knowledgeable comments. My old PP disc and install code is long gone. I'd find creating my own template beyond me I think. I will investigate the suggestions for converting a word template or, as mentioned, the Avery online version looks doable.

 

[Alfred]

18 hours ago, MikeTO said:

I checked the standard 7160/5160 sizes.

US size 5160 is 1″ × 2.625″ (30 labels per US Letter sheet) but UK size L7160 is 1.5″ × 2.5″ (21 labels per A4 sheet). Not the same animal at all!

The L7xxx series of UK Avery labels is intended for use with laser printers. There’s also a J8xxx series for inkjet printers, but since the sizes and layouts are exactly the same we don’t need to concern ourselves with the slight difference in numbering.

[Komatös]

I've made templates from some Avery labels. All metric.

• Avery_Zweckform_37-RND.aftemplate
• Avery_Zweckform_C2355 Karten A6 .aftemplate
• Avery-Zweckform 50x37mm oval.aftemplate
• Avery-Zweckform 3490 70x36 mm.aftemplate
• Avery-Zweckform 4747 59 x 50 mm.aftemplate
• Avery-Zweckform_4782.aftemplate
• Avery-Zweckform_J8165.aftemplate
• Avery-Zweckform_L4746.aftemplate

Avery-Zweckform Vorlagen - Templates.rar

[Spicesman]

Hey guys,

 

Not sure if the best place to ask this question but giving it a try.

I am struggling with adding my design to the template. There is an icon from the logo we use in our product label design (yellow organic circle). When i put this on the template, it is overlapping on the next label on the template. How can i get rid of this. See attached.

 

Thank you!

Avery Template 105x74-R.pdf

[Alfred]

22 minutes ago, Spicesman said:

See attached.

It would be more readily viewable if you were to attach it as a JPEG or PNG image which could be viewed directly in the browser.

[PaulEC]

As far as I can tell, this template is just a sheet with rectangles on it, so if you put something on it that isn't within one rectangle it will overlap onto the next one. The easiest solution would be to change the shape so that it fits on a single rectangle and doesn't overlap.

[Alfred]

4 hours ago, PaulEC said:

The easiest solution would be to change the shape so that it fits on a single rectangle and doesn't overlap.

And the easiest way to change the shape to fit would be to clip it to the rectangle (not actually changing the shape, but using a clipview window to restrict what the user can see). Alternatively, you can intersect the shape with a copy of the rectangle.

[Lir]

All suggestions above are outdated. You no longer need to download templates and do copy pasting. Canva and adobe express have apps where you just select the brand and code of your label sheets (avery as well) and they generate the exact printout for you. Search their apps for labels to find the app. Otherwise you can take your label designs, upload to hlabels.com and do the same thing.

[MikeTO]

On 2/2/2025 at 11:03 AM, Lir said:

All suggestions above are outdated. You no longer need to download templates and do copy pasting. Canva and adobe express have apps where you just select the brand and code of your label sheets (avery as well) and they generate the exact printout for you. Search their apps for labels to find the app. Otherwise you can take your label designs, upload to hlabels.com and do the same thing.

Although Publisher doesn't have this feature built in, once it has scripting which is in development now, anybody will be able to do this on their own. I've previously written a script with a UI for another app that generated templates for the entire Avery catalog, so I might do the same for Publisher.

[AlanPickup]

 

Just come across this thread whilst browsing and interested in the one asking about using spreadsheets and the data merge. I recently did individual party invites for a friend's birthday and part of it was to have addressed envelopes. I used a 63.5x38.1 label as the document size which would fill a page of 21 to view labels. Then put the data merge field on and generated the labels. I set AFPub print to the sizes and margins in the screen clip and printed the labels off. I have saved this now as a print profile and single label 21 to view template for reuse (names and addresses blacked out).