How to style parts of your text with tags or from Excel

AzureLabel lets you apply different formatting to individual parts of text while retaining the same wrapping, layout, and automatic font size adjustment as Plain text.

You can add formatting using simple inline tags in static text or in values from any supported data source, such as Excel, CSV files, databases, Google Sheets, or APIs. AzureLabel can also preserve supported formatting already applied to text in Microsoft Excel.

In the element properties, select Plain text with tags from the Display as list.

Select 'Plain text with tags' from the 'Display as' list in the element properties.

Use inline formatting tags

To format part of the text, wrap it in the appropriate opening and closing tags. For example, <b>Milk</b> displays Milk in bold.

You can combine tags by wrapping the same text in multiple tags. For example, <u><b>Milk</b></u> displays Milk in bold and underlined.

Supported tags

The following inline tags are supported:

  • <b>...</b> — bold text
  • <i>...</i> — italic text
  • <u>...</u> — underlined text
  • <s>...</s> — strikethrough text
  • <font color="...">...</font> — colored text

For text colors, you can use a hexadecimal HTML color value such as #D32F2F, or one of the supported color names: red, blue, green, black, white, yellow, orange, and gray.

For example:

<font color="red">Red text</font>
<font color="#D32F2F">Custom color</font>

Example with multiple formatting styles

Ingredients: <b>Wheat</b> flour, sugar, vegetable oil, <b>MILK</b> powder, cocoa, <b>EGGS</b>, <i>natural vanilla flavour</i>, salt, <b>SOY</b> lecithin. <b> Contains: WHEAT, MILK, EGGS, SOY.</b>
<font color="#D32F2F"><b>KEEP REFRIGERATED</b></font> after opening.

Example result:

Text with inline bold, italic, and color formatting.

Import formatted text from Excel

When importing data from Microsoft Excel, AzureLabel can preserve supported formatting applied to individual parts of a cell. Bold, italic, underline, strikethrough, and text color formatting are converted during import so they can be displayed using Plain text with tags.

Open Import settings. On the Data fields tab, select a field that contains formatted text, then select Simple (no CSS) from the Excel text formatting to HTML list.

Import formatted Excel text using the Simple (no CSS) option.

How to print labels from Excel

How to print labels from Google Sheets

How to print labels from CSV