Customer Support >> Import Inventory to BrightLab

How to Import Inventory into BrightLab

Follow the instructions below to import your inventory list to BrightLab using our batch upload Excel template.

1. From the Inventory module, click Add Inventory to get started.

BrightLab Add Inventory

2. Select the option to Add Multiple Items and click Download Template.

BrightLab Download Template

3. Copy and paste, or type directly, your inventory details into the Excel template. The required fields are marked with an asterisk (*). For expected data formats and attribute descriptions, please refer to the header comments.

Here are a few helpful tips to keep in mind when filling out the template:

  • Count: the number of times a material is repeatedly added.
  • Quantity: This is the starting quantity in a full container. Quantity + Unit of Measure is the starting quantity of the material when you add it again. Note: Files with .xlsx extension can’t be uploaded. Please use the template file (.xls extension) to upload and add inventory.
  • If you enter Sigma-Aldrich as the Manufacturer and a Sigma-Aldrich Catalog Number, we will look up the following fields for you from our database:
    • Name
    • CAS #
    • Boiling Point
    • Melting Point
    • Flashing Point
    • GHS Information
  • Be sure to double-check for accuracy before saving!

Please refer to the examples below on how to enter material details in the template.

BrightLab Batch Upload Template

4. Once your batch upload template is saved, you may Drag and Drop the file into BrightLab, or select the file from its folder location on your device in order to complete the upload. Click on Add when finished.

BrightLab Drag and Drop