Preparing the workbook data

The iMIS workbook is comprised of many different Excel spreadsheet tabs. Each tabs has its own specifications of what data is allowed to be imported and how it should be formatted. Carefully read the information below while creating your workbooks.

Before you begin

Copy the sample Excel workbook file (see Locating the Workbook Converter), and rename the sample Excel workbook file. Note that the sample workbook is designated as read-only, so you must save changes to a new file. The file must be saved in an .xlsx format. Other file formats are not supported.

Note that numeric columns must use a numeric format of either General or Number. If Number is selected, make sure the option Use 1000 Separator (,) is not selected, and the Negative numbers format should be -1234.10.

Understanding the Workbook Converter tabs and how to add data