Format your import data correctly on your computer to prevent any errors when importing items to Labfolder’s Material Database.
Requirements for all import files
The import file must be an .xlsx file.
Please note, when importing, one Excel worksheet corresponds to one MDB 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.
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 Labfolder Material Database. 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 MDB attribute types:
Text: Allows for all character types, such as letters, special characters and numbers.
Number: Allows numeric values only! If hyphens or units are also displayed an error will occur. Please note that Labfolder’s MDB indicates decimals with a dot (so 1,25 will be displayed as 1.25)
Hyperlink: Allows for the display of URLs in the Labfolder MDB.
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.
The Name attribute cannot be empty!