• Working in Excel, find the first cell of the column requiring an Import ID.
 
  • In that cell, start the Import ID using the format of your initials, today's date, and a unique identifier. For example, if Robert Hernandez was populating an import ID on September 1, 2017, the starting ID would be RH090117-1 or RH09012017-1
    Start of Import ID
 
  • Click on the cell entered in the previous step.
 
  • On the lower right of the cell, move the pointer until a + appears. 
    Import ID with +
 
  • Left mouse click when the + appears and drag down to fill the column. Unique IDs will populate on each row after the hyphen.
    Filled in Import ID