Welcome to SPO Sripts – your source of high quality PowerShell Scripts about M365 and SharePoint. 

PowerShell is the language when it comes to automation of Microsofts collaboration products. In this blog I want to show you step by step how you can automate things with SharePoint PowerShell scripts. My aim is to democratize the automation so everybody can make their processes more efficient. 

If you have any cases, where you think I should set up a blog post or you have feedback for me, contact me. I appreciate it.

In this Blog I am writing about SharePoint Server, SharePoint Online, Windows PowerShell and Azure AD.

Jump directly to the categories

SharePoint Online PowerShell Scripts
SharePoint Online
SharePoint Server PowerShell Scripts
SharePoint Server
PowerShell Scripts

Latest Posts – SharePoint PowerShell scripts

  • SharePoint Online: How to get all lists and libraries
    Learn how to get all lists and libraries with two PowerShell scripts to understand what is going on in your SharePoint tenant.
  • Upload documents to SharePoint with PowerShell solution
    Learn how to upload documents to SharePoint with PowerShell. Integrating different systems to SharePoint can be achieved easily with this.
  • SharePoint Site Usage: Get active Sites for last 6 months with PowerShell
    When migrating our SharePoint to SharePoint Online, it can be really hard to separate the wheat from the chaff. SharePoint Site usage helps you find, what is actually used in your current farm. SharePoint farms grow by new projects and with the change of structures. If you want to have an overview, it is every time a good idea, to get rid of old stuff.
  • SharePoint get all sites and subsites PowerShell script
    SharePoint sites are created very fast. With a few clicks, admins and users can create dozens of sites and subsites. Since it is so easy to create sites, we as admins should have an overview, what is going on at our SharePoint environment. I wrote scripts for this purpose to get all sites and subsites of your SharePoint, so you can trim your SharePoint to your business needs. You will find a script for SharePoint Server and SharePoint Online.
  • SharePoint PowerShell add site collection administrator
    When you administer the SharePoint, you might need access to all sites. I have provided a collection of PowerShell scripts, so you can access all sites after running a script
  • Business Process Automation: How to make customers happy
    Business process automation can help you to design a more efficient organization. With business process automation, you can guide your users through your processes, so your users know what to do and when to do it. In this article, I want to show you my key success factors, to make your customers happy. I also have talked in the PowerShell […]
  • Run PowerShell script | a clear tutorial made for beginners
    Every journey starts with the first step. PowerShell is the langauge, when it comes to task and configuration automation. In this article I want to cover a basic: How to start a PowerShell Script.
  • SharePoint Downloader | Comfortable file download in 2 steps
    In this article, you’ll learn how to download SharePoint files in the GUI and with PowerShell. I also provide my tool, the “SharePoint Downloader” – a ready-to-run script, which you can use to download your SharePoint files.
  • How to restore SharePoint files with PowerShell
    It is easy to delete SharePoint files by mistake. In this article, I will how you can restore SharePoint files in the GUI and also with PowerShell. You will also learn how to filter on specific deletors, to restore only the SharePoint files, deleted by a specific user. Enclosed there is a ready-to-run script, which you can use to restore your SharePoint files.

Image sources:

PowerShell icon by Icons8

MS Sharepoint icon by Icons8

Microsoft Sharepoint 2019 icon by Icons8