# 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](/instruction/workspace.md#toolbar):

![Custom Excel Settings under Import of the toolbar](/files/lC2zXolTyjWI9klMlpfV)

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

![Custom Excel Settings Window](/files/rJUYNf6CYTrspkBTdaGK)

### Selected Template

![Template Selection area of the Custom Excel Settings window](/files/BxI6sfIcGpmlTwLbpPU6)

* **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

{% hint style="info" %}
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.
{% endhint %}

### 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](/files/8Qffn04FJtl9j3mw6gL2)

### 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](/files/arfZzWfstZk8vTm4IsWC)

### 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](/files/8fF2mG4uFq2JEpMAQMo8)

## Import

After you have made your settings and are ready to import, follow the steps described [here](/instruction/import-forms.md#custom-import-form) to get your data into the tool.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://automation-docs.lazymerch.com/helpful-features/custom-excel-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.