Data import · Microsoft Dynamics 365 Business Central

Import data without copy & paste.

File → mapping → preview → import – reusable, traceable, without custom code.

Business Central

Easy to use

Instead of copy & paste or one-off scripts, you run imports where your master data already lives. Map columns, check the preview, import – including an audit trail in the log.

Quick Import often recognizes the right mapping automatically from column headers. Details are in the Universal Import documentation.

Benefits at a glance

From the file straight into Business Central.

File

Provide Excel, CSV, XML or JSON.

Im ERP · Business Central

Data in BC

Into the selected table.

Universal Import

Mapping, preview & log.

Data import

Why Universal Import.

FACTS
4
File formats
Excel, CSV, XML and JSON
1×
Maintain mapping
Save import mappings and reuse them
0
Custom code
Import without programming
Features

Universal Import feature set at a glance.

File formats

Import mapping

Preview & control

Log & target

Before / After

Import without typing and guesswork.

Without Universal Import

With Universal Import

In just a few steps

How to import.

1

Choose a file

Upload Excel, CSV, XML or JSON.

2

Map fields

Assign columns to BC fields.

3

Validate

Import preview and validation.

4

Import

Data lands in the target table – with a log.

Questions & Answers

Frequently Asked Questions

Excel (.xlsx), CSV, XML and JSON – details are in the documentation at docs.solutioo.de/universal-import.

No. You save import mappings as templates and reuse them for recurring imports. Quick Import often recognizes matching mappings automatically from column headers.

Which rows would be inserted, updated or skipped – and where errors might occur before anything is written to Business Central.

Into virtually any suitable BC table, for example items, customers, vendors or price lists.

Yes. The import log documents every run as a traceable audit trail.

At docs.solutioo.de/universal-import – from quickstart through mapping to FAQ.

By default, AppSource detects the browser language and sets it accordingly, but the billing country is always set to “USA”. Our offers are only available in Germany and a few other selected countries, so you cannot install the app in that case. What to do? Click the country button at the top left next to the profile icon in Microsoft AppSource and change the billing country to your correct country. You will then see whether our app is available for you.