...
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. Even if the selected sheet has other columns, but are not specified for import, they will not be read. Read more: Introduction: Import/update with Excel-file
Identifier
When Excel-file is used for importupdate, the file has to contain a an 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.
...