Business requirement: Bulk update of a field for existing SharePoint list items.
Suppose you have created a
SharePoint list or
document library with some metadata columns. End-users start adding list items to this
SharePoint list. After a while, they want to change the value for a particular column of already created list items. They could do this manually through the
Edit in Datasheet mode, but suppose they have already created hundreds of list items in the
SharePoint list... It would save a lot of time if an option would exist to bulk update a
SharePoint field from one value to another in all list items for a particular
SharePoint list.
An ideal scenario is off course a
SharePoint column created with as
type of information Lookup. Changing the value of the item where the
Lookup column is getting its information from would update in mass all already existing
SharePoint list items. But if this isn't the case, there is no real out-of-the-box
SharePoint functionality to bulk update a field (except the
Edit in Datasheet mode).
Solution: Use the SharePoint SUSHI application to bulk update SharePoint list fields.
Joseph Fluckiger created a solution called SharePoint SUSHI. SUSHI (SharePoint Utility with a Smart, Helpful Interface) is a user-friendly SharePoint application enabling you to accomplish SharePoint administrative and development tasks.
The following step-by-step description is a guide how you can do a mass update on a SharePoint list field with the SharePoint SUSHI application.
- Create an Issue Tracking list.
- Create several list items in the Issue Tracking list and make sure there are different values present for the field Issue Status, as this is the field we are going to use to do the bulk update.
Your Issue Tracking list should look like this:

- Suppose the end-users now want to change value for the Issue Status column. They want the Issue Status Active to be called Started from now on. And off course, they want to change the column value for all existing issues as well to have a consistent look and feel over all issues.
- Edit the column Issue Status: change the choice value Active to Started. As such, upon creation of new Issue Tracking list items, end-users will have to choose the value Started in stead of Active for the Issue Status column. However, for existing list items, the value Active isn't changed towards Started. The next steps describe how this can be achieved.

- Download the SharePoint SUSHI application from CodePlex and install the executable on your SharePoint server. Start up the application.
- Select Meta Data in the left menu and enter the url of your SharePoint site containing the Issue Tracking list to the right.
- Click Retrieve Lists and choose the Issue Tracking list in the Target Document Library drop down box.
- Choose the Issue Status column in the Metadata Column Name drop down box.
- Choose Active in the Current Value drop down box.
- Type Started in the text box New Value.

- Click Update values in column to new value.

- Go back to the Issue Tracking list on your SharePoint site: all values are updated.

Continue reading......