Ensure the file you upload is in XLSX format (Excel 2007 and above), and has the exact same columns as shown in this example:

The following rules apply:

1. The value in the ProductCode column will be used to determine whether to add the component as a new item if no component exsists in the database with the same code, or to update an existing component if there is one with the same code in the database.
2. The values in Level1 and Level2 must already exist in the database otherwise the component will be skipped.
3. Valid values for Orientation are L, R and LR
4. The sheet must be called components, not Sheet 1
5. If you have any rows with a description or specification greater than 255 characters in length, ensure that one of these row appears first to ensure the fields will not be truncated.