Hi
As mentioned by Scott, "Bulk editor" is the tool which is required by you.
Please go through this reference community article for your reference:-
Link:- http://www.terrabeata.com/2015/06/bulk-edit-in-adobe-experience-manager-6-1/
//Page Bulk Edit in Adobe Experience Manager 6.1
Documentation link:- https://docs.adobe.com/docs/en/aem/6-1/administer/operations/bulk-editor.html
//
Searching and Editing Content
To use the bulk editor to edit multiple items simultaneously:
In the Tools console, click the Importers folder to expand it.
Double-click the Bulk Editor to open it.
Enter your selection requirements:
Click Search. The Bulk Editor displays the results.
For the example above, all the pages that meet your search criteria are returned and displayed with the requested columns.
Make any changes you need by double-clicking in a cell.
Click Save to save your changes (the Save button will be activated once you have edited a cell).
Video:- https://www.youtube.com/watch?v=lCkoi4gGXg8
I hope this will be of some use to you.
Thanks and Regards
Kautuk Sahni