Hi Katy,
In response to "is it possible to use the upload spreadsheet to upload archival objects into a specific location in the inventory, instead of being appended at the end?"
Selecting the record in the resource hierarchy that you would like the new records to appear after and then selecting the load via spreadsheet button in edit mode should add whatever is in your bulk sheet after that record. Keep in mind that the number you
assign them in the hierarchy column will determine if they are children or siblings to the selected record (1=sibling, 2=child etc).
Best,
Anton