How to create envelope labels from a numbers.app file

Avery has just released a free program designed to be able to print on any of their labels, of course you can use them to print on anything, but they work well with the Avery stuff because you can just type in the number from the packet and it has all the sizes already. It’s a free download from here. I just downloaded it (262 MB!) and it looks pretty good.

Thanks to Paul Sheely for this pointer on how to export from an apple numbers file into the avery application:

1. Export your numbers file as a CSV file (make sure that you’ve made the first line in each column a heading)

2. Download the design pro app from Avery (http://www.avery.com/avery/en_us/Templates-&-Software/Software/Avery-DesignPro-for-Mac.htm)

3. Follow the simple instructions…. you choose a label type… an avery number… a design type… you mail merge your CSV file… and you’re away.

Very simple once you’re set up. The Avery app allows you also to merge directly from Address Book or Mail and you can upload artwork or photos.

Posted

December 28, 2008

labels, numbers

New Posts

New ThemeAugust 16, 2023
Can I zoom the MacBook Pro camera in a Zoom meeting?July 30, 2023
How to sync your iPad without using your iCloud dataJuly 28, 2023

Latest Comments

Wayne on GTD with Apple remindersAugust 16, 2023
Yes, I just used relative rage is in the last year.
Stephen on GTD with Apple remindersAugust 16, 2023
One Last question, how did you filter your overdue smart list. I have been using relative range past year but…
Wayne on GTD with Apple remindersAugust 14, 2023
I’ve got to admit the iOS app is not as easy to use as the desktop one!

Article Categories

Comments

13 responses to “How to create envelope labels from a numbers.app file”

Rhonda
November 30, 2010
THANK YOU!! I have called AppleCare and did not get this answer. Prior to that I searched Apple help, Googled, this and no answers. This worked and was quick to print my former excel file, now in Numbers on Avery labels without having to add everything into address book. Praise God! I’m so excited. Thank you, thank you!
Reply
4busmom
October 2, 2011
Great solution!!! I had my labels done within 5 minutes of downloading the program! Super easy and just what I needed for keeping track of costumes for the drill team!!
Reply
JT
September 19, 2012
Works like a charm!!!!!! Simple to use.
Reply
Mo
October 18, 2012
How do I “save” to send it with someone who may not have the Avery Program?
Reply
Mo
October 18, 2012
Like how can I “export” it possible to share it with someone who does not have Avery Pro for Mac?
Reply
Colin Batt
February 23, 2013
I have a large spread sheet in pages and would like to be able to print address labels, how can I do this? can anybody help.
Reply
1. Ken Davis
  July 28, 2013
  Avery.com has a “Make Labels Online” that supposedly replaced Design Pro. I was able to use, but not nearly as easy as design pro was. Anybody have a better way? Does Labels and Addresses app easily merge from Numbers?
  Reply
Kim Clemets
October 8, 2013
Great instructions – imported data from a large numbers file into mailing labels using design pro! Thank you, thank you, thank you!
Reply
AF
April 23, 2014
How do I get this to work with my gmail contacts? I’ve gone through all the steps to export them as a CSV file, and I get to the next to last step and click on “export” and NOTHING HAPPENS. No drop down window, no save, no nothing.
Aaaaaaaaaaaaaaaaaaaaaauuugh
Reply
Terrie
May 30, 2014
I downloaded the Avery app. When I import I get the same addressee name on every envelope. I mush have my numbers spreadsheet formatted wrong. I have a blank column on the left and a blank line on the top as I understood the directions above from Paul Sheely. What are the fields that are to be drug into the form. Are they supposed to correspond to column letters? Can anyone explain what I might be doing wrong. Thanks so much.
Reply
Debbie
August 25, 2014
Absolutely fantastic. I maintain a mailing list for my local tennis club and usually dread printing the mailing labels, and as a new Mac / Apple user I was trying to escape the job. This guide was exactly what I wanted – and made the whole thing simpler than it has ever been!! Thank you.
Reply
Alison Steadman
January 8, 2015
I installed the MacFonts label making program and it has disappeared into the innards of my IMac. I was on the phone with Apple for almost an hour and they were unable to find it. Can I please get some help from the creators of this thing?
Thanks.
Reply
Ted Truitt
April 28, 2019
This saved me so much time and was so easy. Thank you, thank you!
Reply