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.


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:

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

Selected Template

  • 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.

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.

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.


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

Last updated