> For the complete documentation index, see [llms.txt](https://docs.solutioo.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.solutioo.de/universal-import/universalimport_en_us/step-by-step-guide/integrations/excel.md).

# Excel

## Grundlagen

<table data-view="cards"><thead><tr><th></th></tr></thead><tbody><tr><td><strong>Supported format:</strong> <code>.xlsx</code> (modern Excel format)</td></tr><tr><td><p><strong>First data row:</strong> </p><ul><li><strong>row 1</strong>: column headings (header row)</li><li><strong>row 2</strong>: the actual data</li></ul></td></tr><tr><td><p><strong>After uploading</strong> the mapping list displays the Excel column letters (<code>A</code>, <code>B</code>, …, <code>AA</code>, <code>AB</code>, …) next to the column names.</p><p>This allows you to see at a glance which column in the file is being referred to.</p></td></tr><tr><td><p><strong>Order:</strong> </p><p>Columns are displayed in the order of the worksheet not sorted alphabetically.</p></td></tr><tr><td>The “Sort by Default” action resets the column order to the position in the sheet.</td></tr></tbody></table>

## Item import

* For **item**-imports, **item attributes** and the application of an **item template** are supported.
* **Configurable product prefix**: Items whose number starts with the configured prefix are skipped during import. This is typically used to filter out configurable products from Magento or Shopware exports.

## Numbers and decimal separators

You can define the decimal separator for each column:\
Automatic uses either a period or a comma depending on the Business Central server locale.

{% hint style="warning" %}
Make sure that your Excel file has unique headings in **row 1**. These are used for column detection and for Quick Import matching with saved mappings.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.solutioo.de/universal-import/universalimport_en_us/step-by-step-guide/integrations/excel.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.