SharePoint Online: Bulk Update Metadata Properties from a CSV File using PowerShell

Requirement: Bulk Update Metadata of Multiple Documents from a CSV in SharePoint Online. SharePoint Online: PowerShell to Bulk Edit Metadata Properties from a CSV File We’ve a document library with a 100s of documents in several sub-folders and wanted to bulk update metadata of all those documents. While quick edit is one…

Read more

SharePoint Online: Update List Items from a CSV File using PowerShell

Requirement: Update SharePoint Online List from a CSV using PowerShell. PowerShell to Update SharePoint Online List from CSV File We have a list called “Projects” with a bunch of columns and wanted to update items from a CSV file. Here is the PowerShell CSOM script to update the SharePoint Online list from…

Read more

SharePoint Online: Get File Size using PowerShell

Requirement: Get file size in SharePoint Online using PowerShell How to Get the File Size in SharePoint Online? To get the size of a file, you can follow these approaches:  Edit the list view of the document library and include the “File Size” column in it Go to the “Storage Metrics” page,…

Read more

SharePoint Online: Import Files from a CSV using PowerShell

Requirement: Upload files from a CSV to SharePoint Online. SharePoint Online: How to Import Files from a CSV using PowerShell? We have got a CSV file with a list of files pointing to a network file share. We wanted to import all files from a CSV file to the SharePoint Online site….

Read more

Get Documents Inventory for a Site Collection using PowerShell

Requirement: Get All documents inventory in a CSV format from a SharePoint Site collection. PowerShell to Get Documents Inventory of a SharePoint Site: This PowerShell gets all document details from a given site. To generate a report on all documents in a SharePoint Online site collection, use: SharePoint Online: Get All Documents…

Read more

SharePoint Online: Bulk Delete Folders from a CSV using PowerShell

Requirement: Bulk Delete Folders in SharePoint Online. How to Bulk Delete Multiple Folders in SharePoint Online? To bulk delete folders with its sub-folders and files, we can use a CSV file with PowerShell script. Here is my CSV file with a list of folder names and the site relative URL of its…

Read more

SharePoint Online: Create Multiple Lists from a CSV File using PowerShell

Requirement: Bulk create lists in SharePoint Online from a CSV File. How to Create Multiple lists from CSV File? We can use the combination of CSV and PowerShell to create multiple lists in bulk in SharePoint Online. Here is my CSV File: You can download this CSV here: PowerShell to Create Multiple…

Read more

SharePoint Online: Bulk Delete Files from a CSV using PowerShell

Requirement: Delete multiple files from SharePoint Online document libraries from a CSV using PowerShell. How to Delete Multiple Files in SharePoint Online Site from a CSV file? We have a CSV file with a list of URLs of various files in multiple document libraries in SharePoint Online. I wanted to bulk delete…

Read more

SharePoint Online: Site Documents Inventory (Library, Folder, Sub-Folder and Files) Report using PowerShell

Requirement: Generate an Inventory report that contains all document Libraries, Folders, Sub-Folders, and Files detail from a SharePoint Online site collection. SharePoint Online: Site Inventory Report using PowerShell We wanted to find the number of files and folders, sub-folders in each document library in a SharePoint Online site. This PowerShell script extracts…

Read more

Office 365: Get OneDrive for Business Usage Report using PowerShell

Requirement: Get OneDrive for business usage report using PowerShell How to Check the OneDrive for Business Usage for a User in Office 365? OneDrive for Business is Microsoft’s cloud-based storage solution that lets you store and work on files that are personal to you. It’s similar to any other document library in SharePoint…

Read more