> 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/readme.md).

# Functional Scope of Universal Import

**Solutioo Universal Import** is an extension for **Microsoft Dynamics 365 Business Central** that allows you to import data from **Excel, CSV, XML, and JSON files** into any tables. You can define flexible mappings between file columns and BC fields, review records in the import preview, and keep track of each run in the import log.

## Core Concepts

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><h4><i class="fa-arrow-up-to-dotted-line">:arrow-up-to-dotted-line:</i></h4></td><td><strong>Import-Mapping</strong></td><td>An <strong>import mapping</strong> is a reusable template for assigning file columns to fields. It can be reused for recurring imports.</td><td></td><td></td><td><a href="/pages/7FvWQMF0kTK7HGhlQfmo">/pages/7FvWQMF0kTK7HGhlQfmo</a></td></tr><tr><td><h4><i class="fa-bullseye-arrow">:bullseye-arrow:</i></h4></td><td><strong>Target Table</strong></td><td>Practically any suitable <strong>BC table</strong> can be selected as the <strong>target table</strong>, for example <strong>items, customers, vendors, price lists</strong>, and many more.</td><td></td><td></td><td><a href="https://github.com/GitbookIO/gitbook-templates/blob/main/product-docs/broken-reference/README.md">https://github.com/GitbookIO/gitbook-templates/blob/main/product-docs/broken-reference/README.md</a></td></tr><tr><td><h4><i class="fa-magnifying-glass">:magnifying-glass:</i></h4></td><td><strong>Import Preview</strong></td><td>The <strong>import preview</strong> shows what would happen: which lines would be inserted, updated, or skipped, and where errors might occur.</td><td></td><td></td><td><a href="/pages/QPzbTvC6XsT5gERiU43E">/pages/QPzbTvC6XsT5gERiU43E</a></td></tr><tr><td><h4><i class="fa-page">:page:</i></h4></td><td><strong>Import Log</strong></td><td>The <strong>import log</strong> documents each run in a traceable way and provides a complete <strong>audit trail</strong> for your data imports, including export to Excel where supported.</td><td></td><td></td><td></td></tr><tr><td><h4><i class="fa-gauge-max">:gauge-max:</i></h4></td><td><strong>Quick Import...</strong></td><td> ...automatically identifies the appropriate <strong>import mapping</strong> based on the column headers in your file. It is ideal for recurring imports.</td><td></td><td></td><td></td></tr><tr><td><h4><i class="fa-arrows-left-right-to-line">:arrows-left-right-to-line:</i></h4></td><td><strong>Virtual Columns...</strong></td><td>...allow you to add fixed or calculated values to the import that are not included in the source file, for example default values.</td><td></td><td></td><td></td></tr></tbody></table>

## Supported File Formats

The app supports importing the following file formats:

* **Excel** (`.xlsx`)
* **CSV**
* **XML**
* **JSON**

## Column Mapping

In addition to field-level mapping, you can conveniently manage the assignment of source columns to target fields, including by drag and drop in the interface. For more details, see [Assign Columns](https://docs.solutioo.de/universal-import/universalimport_en_us/pages/i73g4LZQanoLj7XtSO18#id-2.-spalten-zuordnen).


---

# 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/readme.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.