...
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
...