Sharepoint folder creation in bulk

Question

Hello All,

I am trying to create multiple folders in a sharepoint library. I have list of folder names in an excel spreadsheet. Is there a better way to do it instead of creating and naming folder by folder.

Answer 1

Hi Priya1331,

Thank you for querying in this forum.

From your description, it seems that you want to create folders in bulk, and those folders names are listed in Excel file, and you don’t want to create and name folder one by one.

If my understanding is right, we’d give you the suggestions below and hope that will help you:

You can go to your Excel file and put the name of folders in column A, then you can go to column B and use the formula = "md Path"&A2. Please take note that path is the location on your computer you would like to create. For example, as shown below:

After you completed the table in Excel workbook. Open Cmd command as admin. As shown below:

Then copy the list in column from Excel workbook and paste to Cmd command and Enter, as shown below:

The command will run automatically as create a list of folders under the target location. In this case, the folders are created under C:\Users\Administrator\Documents. Then, you can drag the folders and upload to your SharePoint library. As shown below:

At the same time, you can also refer to this thread to use PowerShell to create folders in bulk, for your reference: How to create folders in bulk in SharePoint with list of folder names in excel sheet?

If the scenario above is not consistent with yours, you can also post back and provide more details about your requirement.

Best Regards,

Sukie

Answer 2

Hi Priya1331,

May I know if you have seen my reply? May I know if you still need help? If so, you can post back and we will try our best to help you.

Best Regards,

Sukie

Answer 3

Thank you ,this resolved my issue.I have one more issue which I do not know if there is such simple solution.So once after this multiple folders have been created,I have files  in different other folders (for eg: Folder A,B,C,D).I have move files to this newly created folders based on their names.Is there a way to do it other moving it manually?

Answer 4

Hi Priya1331,

We appreciate that you posted back and shared the information with us. We’re sorry for the late reply due to the weekend.

Per your description, it seems that you have multiple other folders with a lot of files, you have moved those files to new folders, you want to know the other ways to move files manually.

If my understanding is right, generally, if we want to move files, we can go to that folder > select all files > click Move to, as shown below:

Then we can select the folder to move to, as shown below:

At the same time, you can also refer to this article: How to copy, move, and clone files and folders in SharePoint - Exploring All Options to check more options to move files.

Disclaimer: Microsoft provides no assurances and/or warranties,implied or otherwise, and is not responsible for the information you receivefrom the third-party linked sites or any support related to technology.

Regards,

Sukie