Add multiple buildings to the same new location in the spreadsheet

Procedure

  1. In the spreadsheet editor, set the Action column to Add.
  2. Leave the Bldg ID column blank, then fill in the other building data columns as needed, until you reach the Loc ID column.
  3. Type any non-blank value in the Loc ID column. For example, type HomeOffice.
  4. Fill in the remaining location data columns as needed.
  5. For additional buildings at the same location, repeat steps 1 and 2. Then copy the remaining range of cells beginning with Loc ID, to the corresponding range in each subsequent row. Note that each building with an identical Loc ID value is added to the same location.
  6. Save and import the spreadsheet.