Custom Excel Import

Introduction to the limitless import function with Custom Excel Import

With our Custom Excel Import feature you can use all tables for import to LazyMerch. For example, if you have your own tables that you have created individually for your workflow and write your listings in them. With the Custom Excel Import feature there are almost no limits. It also makes it easier for you to switch to LazyMerch if you already have Excel templates from your work with other tools.

Settings

To ensure a problem-free import, a few settings must be made. You will also learn how powerful this feature can be. You can find the settings under the Import item in the toolbar:

Custom Excel Settings under Import of the toolbar

By clicking on “Settings Custom Excel” you will get to the window where you can specify your custom Excel tables.

Custom Excel Settings Window

Selected Template

Template Selection area of the Custom Excel Settings window

• Template Dropdown - choose from existing template settings

• Add Icon - create new templates by clicking on the + icon. When creating new templates you can also copy the settings from existing templates

• Edit - edit the name of the selected template setting

• Delete - delete the selected template

This way you can create several templates for different needs, which is especially useful if you have filled the fields with cloze texts, but then need to change to a cloze text in another language.

Single Column

When specifying a single column name between two curly brackets, you can refer to the contents of a single column in the table. When importing to LazyMerch, the cell entries from this column would now be loaded into the tool here.

Single Column References

Compound Columns

You can merge the values of several cells, so that you get a Description from several column entries for example. Furthermore, you can insert text in the Custom Excel Import Settings to build templates for cloze texts. This is shown in the following screenshot.

Combine multiple columns to result in a desired value

Text Information

It is not mandatory that every value to be imported comes from an Excel table. If you know in advance that you prefer to always upload with a specific color, you can specify this value textually directly in the settings, as marked in the following screenshot.

Colors filled with text rather than a column reference

Import

After you have made your settings and are ready to import, follow the steps described here to get your data into the tool.