Find & Replace Tool for SharePoint & SharePoint Online (Office 365)
This tool will search for and replace text contained within a specified SharePoint List Column.
The Kintivo Find & Replace Tool for SharePoint is WAY faster than writing custom scripts (not to mention a bit less aggravating).
How it works
Provide your SharePoint site URL and login information.
SharePoint On-Prem Example:
SharePoint Online (Office 365) Example:
- Select desired List and Column.
- Enter the text you wish to search for.
- Enter the text you wish to replace it with.
The above example is based on the Use Case of when a company changes their corporate email addresses. The List called “People” has hundreds of contacts using the old email, and we want to update the old email addresses with the new ones. The ONLY part of the person’s email address that needs updated is the “@NorthSlope.com”, because the new email is “@NorthSlopeSystems.com”.
In this case, we only wanted to update items associated with the “US” based company, hence the optional condition. Leaving the “Condition” set to the default value of “All Instances” would find and replace all instances in the List. Clicking the “Replace” button will search the “Email Address” column and find every instance of “@NorthSlope.com”, and replace it with “@NorthSlopeSystems.com” when “Company” = “North Slope, Inc. (US)”.
Example: “jane@NorthSlope.com” will be updated to “jane@NorthSlopeSystems.com”