Before importing an inventory you need to make sure that your Excel sheet is correctly formatted to prevent any errors when importing items to Labregister.

Requirements for all import files

• The import file must be a .xlsx file.
• Please note, when importing, one Excel worksheet corresponds to one inventory category. While you can only import one worksheet at a time your Excel may contain multiple sheets.
• The import file should contain fewer than 10,000 items/rows and be smaller than 25 MB.
• Include a header row in your file (example screenshot below).
  • The first row of your Excel sheet (header) should correspond to an attribute that exists for the inventory list being imported.
  • During the import process, column headers of the Excel file will match to the category’s attributes in the Labregister. Where needed, you can manually map your column headers to attributes.
  • Avoid merging cells in your sheet. One header should be associated with only one column.
• Excel columns must correspond to one of the following Labregister attribute types:
  • Short Text: This allows all character types, such as letters, special characters, and numbers (up to 200 characters).
  • Long Text: In contrast to Short Text, here up to 16000 characters are supported.
  • Number: Allows numeric values only! If hyphens or units are also displayed an error will occur. Please note that Labregister indicates decimals with a dot (so 1,25 will be displayed as 1.25)
  • Hyperlink: This allows the display of URLs in the Labfolder inventory.
  • Dates: All dates are displayed in the format DD.MM.YYYY, thereby date formats from Excel may be converted if stated as 01-Jan or 16/01/2020.
  • Dropdown: Allows to create of a predefined selection of attribute values. All character types, such as letters, special characters, and numbers can be used here.
  • Barcode: Can be added as a numeric value and be visualized either as code 128 or data matrix.
• Please note that previously exported item IDs of a category cannot be uploaded, as Labregister does not recognize duplicates, and item IDs are auto-generated when adding a new item.
• The Name attribute cannot be empty!