Excel
Universal Import reads the modern Excel format .xlsx and maps the cells of your workbook to the fields of the selected target table in Business Central.
Last updated
⌘Ctrlk
Universal Import reads the modern Excel format .xlsx and maps the cells of your workbook to the fields of the selected target table in Business Central.
Supported format: .xlsx (modern Excel format)
First data row:
row 1: column headings (header row)
row 2: the actual data
After uploading the mapping list displays the Excel column letters (A, B, …, AA, AB, …) next to the column names.
This allows you to see at a glance which column in the file is being referred to.
Order:
Columns are displayed in the order of the worksheet not sorted alphabetically.
The “Sort by Default” action resets the column order to the position in the sheet.
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.
You can define the decimal separator for each column: Automatic uses either a period or a comma depending on the Business Central server locale.
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.
Last updated