You can choose from two methods to update existing items. Both methods provide the same result.
Microsoft® Office Excel spreadsheet - use this method if any of the following apply:
You need time to determine the changes to make. You can save the spreadsheet and work on it later.
When you have less than 200 items to update.
You want to update many different types of item fields at once. For example, you want to update many items' attributes, organizations, and categories at the same time.
Mass update function - Use this method if any of the following apply:
Change control is necessary.
Your environment is characterized by many items and/or organizations.
You want to update certain fields for many items. Choose from the following mass update functions:
Update Master Item Attributes
Update Organization Item Attributes
Assign Items to Organizations
Assign Items to Categories
Unassign Items from Categories
Reassign Categories