Help Center

Search:

Creating a Data List

Creating a Data List that can be imported into Maestro Label Designer

Where to begin? Creating your file...

It might all seem intimidating at first, but Mail Merges are actually pretty simple. At its most basic level, your Data List may contain information such as NAME, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, etc. The first row of data is usually the name/label of the column, and subsequent rows contain the actual data. It's that simple! Listed below, you'll find two popular programs that we recommend for creating Data Lists, along with sample template files for your convenience:

Supported filetypes and how to create your file:

Microsoft Excel : Download a Sample Template
Supports .CSV (recommended), .XLS, .XLSX, .TXT

1. Open Microsoft Excel and add in any pertinent data:
Open Microsoft Excel and add in any pertinent data.

2. Once completed, go to the main menu of Excel and click SAVE AS:
Once completed, go to the main menu of Excel and click SAVE AS.

3. From here, you can save the file as a *.CSV (separated by commas), *.TXT (separated by tabbed spaces), *.XLS, or *.XLSX file. Note that while in Excel, the program will automatically arrange your data based on which filename you choose to SAVE AS:
From here, you can save the file as a *.CSV, *.TXT (tab delimited), *.XLS, or *.XLSX file.

Notepad : Download a Sample Template (Right Click, SAVE LINK AS...)
Supports .TXT (recommended), .CSV

1. Open your favorite text-editor (we recommend Notepad) and add in any pertinent data, separated by tabs (for .TXT files) or commas (for .CSV files), as shown below. There should be one tab between each column (columns may not necessarily appear lined up):
Open your favorite text-editor (we recommend Notepad) and add in any pertinent data, separated by tabs, as shown below.

2. Once completed, go to the FILE tab and click SAVE AS. From here, you can save the file as a *.TXT file (if separated using tabbed-spaces) or a *.CSV file (if separated using commas):
Once completed, go to the FILE tab and click SAVE AS. From here, you can save the file as a *.CSV or *.TXT file.

Customer Support Shopping Miscellaneous Company Information  
Facebook Logo Twitter Logo

Toll Free: 1-888-575-2235
Local: 407-949-6499
Fax: 1-866-406-7341

Online Labels, Inc.
975 Bennett Drive
Longwood, FL 32750 USA

The Print Guide Recommended Label Supplier Visit Consolidated Label for custom printed labels. BizRate Circle of Excellence Site – MERCHANT Reviews at Bizrate
Switch to Mobile Version