Create Bulk "Document Set" and Add Respective Column Properties in SharePoint Using Excel Metadata File

Question

I need solution for Bulk "Document Set" Creation in SharePoint using Excel Metadata File as:

1. Creating multiple Document Set in SharePoint Using Metadata Excel file with Key Column to use unique Document Set names.
2. During Creation of Document Set, Columns metadata/properties should also be updated as in Excel Metadata file. (Files will be uploaded later in respective sets).
3. Excel Rows will be used for creating Document Sets and Excel Columns will have the values of Document Set properties.
4. Is it possible to add the multiple attachments for each set from PC along with.
5. So, I need help in creating Document Sets and updating the metadata values of sets?

Answer 1

Hi @Asif Rehan,

SharePoint Server allows for the creation of Document Sets. Document Sets can be created manually or programmatically using PowerShell scripts. However, there is no built-in functionality to create Document Sets in bulk using an Excel metadata file. You can look for help from third-party tool vendors. The tools may allow you to create Document Sets in bulk and update the metadata values of sets using an Excel metadata file.

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.