Bulk create folders in document library

Hi Beth_Culpepper,

you can try to do this by using PowerShell:

1. Prepare an Excel file with the following columns:
   • State
   • Theater
   • AdditionalFolder
   • Subfolder1
   • Subfolder2
2. Save the Excel file to your local computer.
3. Open a PowerShell console and connect to your SharePoint site.
4. Run the following PowerShell script:

# Import the CSV file
$CSVFile = Import-Csv "C:\Path\To\CSVFile.csv"

# Get the document library
$Library = Get-PnPList -Identity "DocumentLibraryName"

# Create each folder in the document library
ForEach($Row in $CSVFile) {
    $FolderURL = $Library.RootFolder.ServerRelativeUrl + "/" + $Row.State + "/" + $Row.Theater + "/" + $Row.AdditionalFolder + "/" + $Row.Subfolder1 + "/" + $Row.Subfolder2
    Resolve-PnPFolder -SiteRelativePath $FolderURL | Out-Null
}

1. Replace C:\Path\To\CSVFile.csv with the path to your CSV file.
2. Replace DocumentLibraryName with the name of your document library.
3. Run the script.