Data Import

Merge Fields

Using variables to create dynamic labels

Merge Fields

Merge fields (also known as variables or placeholders) are the magic behind printing 100 distinctive labels from one single design.

What is a Merge Field?

A merge field is a placeholder text that gets replaced by data from your spreadsheet when generating the PDF.

  • Design View: Hello, {{First Name}}
  • Printed Label 1: Hello, John
  • Printed Label 2: Hello, Mary

Syntax

We use the "Mustache" syntax: double curly braces.

{{Column Name}}

  • The text inside the braces must exactly map to the header in your data source (case sensitive).

How to Insert Fields

  1. Go to the Data Source tab.
  2. You will see a list of available columns.
  3. Drag a column name onto the canvas.
  4. It will automatically create a text box containing that field.

Method 2: Typing

  1. Create a normal text box.
  2. Type {{ and a dropdown list of available columns will appear.
  3. Select the field or finish typing the name manually.

Image Placeholder: [GIF showing the autocomplete dropdown when typing {{]

Combining Fields

You can mix static text and multiple fields in a single text box.

Examples:

  • Address Line: {{City}}, {{State}} {{Zip Code}}
  • Price Tag: Price: ${{Cost}} only!
  • Greeting: Dear {{Title}} {{Last Name}},

Missing Data Handling

If a cell is empty in your spreadsheet for a specific row:

  • The {{Field}} will be replaced by an empty string (nothing).
  • The label will print without that specific bit of text.
  • It will NOT print "undefined" or {{Field}}.

Tip: If you have an address line 2 that is often empty, placed it on its own line. Our renderer will not collapse the empty line automatically yet, so consider combining it in your spreadsheet if spacing is critical.

Best Practices

  • Keep Headers Simple: Rename columns in Excel to simple names like "Phone" instead of "Customer Contact Phone Number (Mobile)" to keep your design formulas clean.
  • Preview often: Use the preview arrows to check for long names that might break your layout.