Why are cells missing when I import from Microsoft Excel?
What causes it?
When a .xls file is imported by the Windows Batch Sender each column is given a type (number, text etc.). This is based on the sort of data which the Batch Sender finds in the column. If the Batch Sender comes across information of an unexpected type (for example, text in a column which is mostly made up of numbers) then the information is ignored to ensure consistency.
How do I fix it?
When importing a Microsoft Excel spreadsheet format (.xls) file, you need to make sure that all the data in a particular column are of the same data type.
If, for example, you have a column which contains text for some entries and numbers for other then you will need to open the file in Excel, select the column and format it appropriately as 'text'.
By making sure that your columns are all formatted properly in this way the Windows Batch Sender will always import the data properly.
Useful articles
