Is there a way to create address labels in Google Docs based on my Gmail contacts (even better would be a group of contacts I made)? Essentially allowing me to easily create all my address labels for mailing out invitations or Christmas cards or whatever in just a few steps.

2 Answers 2

  1. It seems to me if you use the Print option in the contact manager.
  2. You can select to print just addresses. That opens a new browser window and formats it for printing.
  3. Use 'Ctrl-A' selecting all the information, including headers.
  4. Paste it into Excel.
  5. Save the Excel file.
  6. Run a mail merge using MS Word.

It seems like a lot of steps but it works rather smoothly and doesn't take much time at all. Once in the mail merge labels you can reformat the font just about any way you want.

  • Thanks for those steps. But what I was really looking for was a solution to do this with Google docs. This is definitely the next best solution though. Jul 8, 2010 at 11:55

You can use one of the sheets' templates available on Google Drive. Usually are configurated for Avery labels.

Examples (you need to be logged in with a Google account):

Edit: It seams that Avery Labels' Google Docs official templates are not available any more

Try with:





Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.