How to set up my Excel import file for the inventory?

Modified on Wed, 06 Jul 2022 at 04:05 PM

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!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article