How to Make Address Labels in Publisher From a Comma Separated List

Written by meg north
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make Address Labels in Publisher From a Comma Separated List
Create address labels in Microsoft Publisher from a spreadsheet created in Microsoft Excel. (box image by Pefkos from

A comma separated values list is a file format in which data is saved from a spreadsheet and can be merged to create address labels. Microsoft Excel has the capability to save spreadsheets as comma separated lists, which then can be merged into Microsoft Publisher to create address labels. Once the addresses have been entered into Excel, the merging feature combines the two file formats. This eliminates having to enter each address separately and saves time creating labels.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Microsoft Publisher
  • Microsoft Excel

Show MoreHide


  1. 1

    Open a new spreadsheet in Microsoft Excel. Create the following column headings: First Name, Last Name, Address 1, Address 2, City, State and Postcode. Fill in the information in the Excel rows.

  2. 2

    Select "Save As" from the Excel "File" menu. Choose the .csv file extension from the "Save File As" drop-down menu, label the Excel file and save it to the desktop. Close the Excel file.

  3. 3

    Open Microsoft Publisher. In the opening catalogue, select "Labels" and then "Mailing Address" labels. Choose the size of the address labels, then click the "Start Wizard" button.

  4. 4

    Follow the instructions in the "Label Wizard" to add a colour scheme and design, then click "Finish Wizard."

  5. 5

    Select "Mail Merge" from the "File" menu, then click "Open Data Source." Select the Excel file with the address information. Add the fields (column headings from the Excel file) to the mailing labels and click "Merge."

  6. 6

    Merge the fields. The address labels should now contain the information from the Excel file.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.