Blank LabelsCustom Labels
Home Articles How To Create A Mail Merge Data List

How To Create A Mail Merge Data List

Updated 01/31/2020
Creating a data list to use the mail merge function in Maestro Label Designer

To use the mail merge function in Maestro Label Designer, you'll first need to create a data list. Below, we walk you through the process in Excel and Notepad so you can make labels with customized information.

Making a Data List in Microsoft Excel

  1. Add your column titles to the first row of your document.

    Note: Avoid duplicates in column titles. Special characters will not transfer. If inserting dollar signs, make sure the cell is formatted as "Text."

    Adding the first row of a data list
  2. Enter your information in the appropriate columns.

    A completely filled out data list
  3. Open the menu in the top left-hand corner and click "Save As."

    Saving a Microsoft Excel document
  4. Name your file then click on the dropdown next to "Save as type." Maestro Label Designer will accept any of the following document types:

    • CSV (Comma delimited)
    • Text (Tab delimited)
    • Excel Workbook
    • Excel 97-2003 Workbook
    Choosing a file format in Excel

Making a Data List in Notepad

  1. Type your column titles in the first row of your document, separating each one with the "Tab" button on your keyboard.

    Note: Use only one tab between columns and avoid special characters and duplicates titles.

    Establising columns in Notepad
  2. Enter your information following the same format.

    Note: Your columns may not necessarily appear lined up. This is okay and will not affect your results.

    A filled out Notepad file
  3. Click "File" in the top left-hand corner and click "Save As."

    A filled out Notepad file
  4. Name your file and select Text Documents (*.txt) as the "Save as type."

    Choosing a file format in Notepad

Once you have your file saved, launch Maestro Label Designer and continue to the mail merge tutorial.




For additional help creating a data list, customer service is available at 1-888-575-2235.


Share What You Learned