...
All fields must only contain one value to be used for the import to work. Example: Item number and name cannot be within the same field; they must be separate in two columns.
Column
It does not matter which columns contain the data, however it must be specified in the import dialog window. Only the columns specified for import will be read. Read more: Introduction: Import/update with Excel-file
Identifier
When Excel-file is used for import, the file has to contain a identifier. Which values that can be used as a identifier can be displayed and selected within the import and update window. Bellow is an example on the identifier for updating Items.
...