SharePoint Information Organizer has a feature for importing metadata from an Excel file to SharePoint Lists and Libraries.
|1.||To launch SharePoint Information Organizer, please visit Launch SharePoint Information Organizer|
|2.||Click on the Import metedata to SharePoint lists link from the homepage of the SharePoint Information Organizer. Import metadata to SharePoint Lists page appears as shown below.|
|3.||Browse the Excel file (.xlsx) from the application and click on import button to update the metadata in SharePoint Lists and Libraries.|
|4.||The format of the Excel file to upload should be as given below,|
|5.||The first column of the Excel should be the 'Path' column, which is the URL of the List Item or a File from SharePoint Lists and Libraries.|
|6.||The other Columns will be the field names from the SharePoint List or Library. And the row values should be the metadata values to be updated.|
|7.||The user can also use Export metadata to Excel feature from SharePoint Information Organizer to create the Excel file by selecting the specific Lists and fields to update.|
|8.||User can edit the metadata in the file exported and upload the same to the Import metadata feature.|
Note: If the given URL in the Excel is of SharePoint folder, all the items in the folder including the subfolders will be updated to the given field value.