SharePoint Online: How to See Who has viewed a File?

Requirement: See who has viewed a document in SharePoint Online. How to see who viewed a document in SharePoint? Yes! We can track who has viewed a file in SharePoint online with this nifty feature, “SharePoint Viewers”. To see who has viewed a document in SharePoint, do the following: Go to Site…

Read more

Download SharePoint Documents from CSV File using PowerShell

Requirement: Download files in SharePoint document library from a CSV file to local disk. PowerShell Script to Download Documents from SharePoint : My CSV has “URL” and “FileName” columns in it, and here is the PowerShell to download SharePoint documents from a CSV file to a local disk or network drive. The…

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: Link to Force Download a Document Instead of Open

Requirement: Force download a file instead of opening in SharePoint Online. SharePoint Online: URL to Document Download Instead of Open Documents linked in SharePoint Online pages, navigation menu, lists, etc. opens in the browser (or in client application!) directly either in Read-only mode or in Edit mode, based on user permissions. What…

Read more

SharePoint Online: Upload Large Files using PowerShell

Requirement: Upload large files to SharePoint Online using PowerShell PowerShell to Upload a large file to SharePoint Online If you try to upload files with > 250 MB file size to SharePoint Online using CSOM Files.Add method, or PnP PowerShell Add-PnPFile methods you’ll end up in errors: “The remote server returned an…

Read more

How to Add File Size Column to SharePoint Online Document Library?

Requirement: Add file size column to SharePoint Online How to Show File Size in SharePoint Online? You can add the “File Size” column to any list view of the SharePoint Online document library to get the size of each file. Just follow these steps to add the file size column to SharePoint…

Read more

SharePoint Online: Find All Files Exceeding Maximum URL Length Limitation using PowerShell

Microsoft Office Excel files stored in deep Folder, sub-folder structures with long names often result in an error when they exceed the maximum file URL length of 218 characters as in my other article  SharePoint Online: URL Length Limitation of 218 Characters in Excel Files. So, we wanted to proactively scan the…

Read more

How to Copy Files from OneDrive to SharePoint Online?

Requirement: Copy files from OneDrive to SharePoint Online How to Copy Files from OneDrive for Business Site to SharePoint Online? To copy files from OneDrive to SharePoint Online, do the following: Navigate to the OneDrive for Business site >> Select the files and folders to copy and click on the “Copy to”…

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

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