SharePoint ToolBox

SharePoint ToolBox is a PowerShell WinForms GUI application for administering SharePoint Online sites. It provides a suite of audit, analysis, search, and provisioning tools — all without requiring any manual scripting.


Features

Connection & Profiles

Connect to SharePoint Online with saved profiles and a multi-site picker with session caching.

Permissions Report

Full audit of site permissions exported as CSV or interactive HTML with sort, filter, and group-by-user.

Storage Metrics

Per-library storage analysis showing total size, version bloat, item count, and last-modified date.

Templates

Capture and re-apply site structure, permissions, settings, and logos to new or existing sites.

File Search

KQL-powered file search with regex, date, author, type, and path filters with auto-pagination.

Duplicate Detection

Find redundant files or folders using flexible matching criteria with a visual HTML report.

Configuration

JSON data folder, language selection (English / Français), and how to add new languages.

Output Files

Reference for all generated file names, naming conventions, and how to open each format.


Quick Start

1. Install the prerequisite module

Install-Module PnP.PowerShell -Scope CurrentUser

2. Register an Azure AD application

See Getting Started for the full step-by-step guide to creating an App Registration with the required delegated permissions.

3. Launch SharePoint ToolBox

# Navigate to the folder containing the script
cd C:\Tools\SharepointToolBox

# Launch the application
.\SharepointToolBox.ps1

4. Enter your connection details

Fill in the Tenant URL, Client ID, and Site URL fields, then click Connect. Once connected, switch to any tab to begin your analysis.


At a Glance

PropertyValue
PlatformWindows, PowerShell 5.1 or later
AuthenticationAzure AD App Registration, delegated permissions, interactive browser login
Output formatsCSV (Excel-compatible) and HTML (interactive, self-contained)
LanguagesEnglish (US), Français
Configuration storageJSON files in a user-configurable data folder

See Also