Output Files

SharePoint ToolBox generates several types of files across its various features. This page documents every generated filename, its naming convention, its format, and how to open it.

Summary Table

File	Feature	Format	Description
`Sharepoint_Export_profiles.json`	Profiles	JSON	Saved connection profiles
`Sharepoint_Templates.json`	Templates	JSON	Captured site templates
`Permissions_<site>_<date>.csv`	Permissions Report	CSV	Raw permissions audit data
`Permissions_<site>_<date>.html`	Permissions Report	HTML	Interactive permissions report
`Storage_<site>_<date>.csv`	Storage Metrics	CSV	Raw storage metrics data
`Storage_<site>_<date>.html`	Storage Metrics	HTML	Interactive storage report with charts
`FileSearch_<date>.csv`	File Search	CSV	File search results
`FileSearch_<date>.html`	File Search	HTML	Interactive sortable file search results
`Duplicates_Files_<date>.csv`	Duplicate Detection	CSV	Duplicate file scan results
`Duplicates_Files_<date>.html`	Duplicate Detection	HTML	Interactive duplicate file report
`Duplicates_Folders_<date>.csv`	Duplicate Detection	CSV	Duplicate folder scan results
`Duplicates_Folders_<date>.html`	Duplicate Detection	HTML	Interactive duplicate folder report

Naming Conventions

Date Format

All report files use the ISO 8601 date format without separators: YYYYMMDD

Example: a report generated on March 10, 2025 uses the suffix _20250310.

Site Name

The <site> component is derived from the last segment of the site URL. Special characters are removed or replaced with underscores.

Site URL	Resulting <site> segment
`https://contoso.sharepoint.com/sites/HR`	`HR`
`https://contoso.sharepoint.com/sites/Project-Alpha`	`Project-Alpha`
`https://contoso.sharepoint.com/sites/Finance 2024`	`Finance_2024`

Multiple Sites

When a report is run against multiple sites simultaneously, each site produces its own report file named individually per site.

Data Files

Sharepoint_Export_profiles.json

Stores all saved connection profiles. See Connection and Profiles for the full format.

Location: Configured data folder (default: application folder)
Updated by: Saving, renaming, or deleting a profile
Safe to edit manually: Yes, if JSON syntax is preserved

Sharepoint_Templates.json

Stores all captured site templates. See Templates for the full format.

Location: Configured data folder (default: application folder)
Updated by: Capturing or deleting a template
Safe to edit manually: Yes, with care — logo data is base64-encoded and large

CSV Files

All CSV files share these properties:

Encoding: UTF-8 with BOM (Byte Order Mark)
Delimiter: Semicolon (;)
Line endings: Windows (CRLF)
First row: Column headers

Opening in Microsoft Excel

⚠️ Note: Because the delimiter is a semicolon, double-clicking a .csv file may display all data in a single column if your Windows regional settings use comma as the list separator.

Recommended approach:

Open Excel.
Go to Data > From Text/CSV.
Select the file.
In the import wizard, set the delimiter to Semicolon.
Click Load.

Opening in Power BI

In Power BI Desktop, click Get Data > Text/CSV.
Select the file.
Confirm the delimiter is detected as semicolon.
Click Load or Transform Data.

HTML Files

All HTML reports are fully self-contained — all CSS and JavaScript is embedded inline. No external fonts, scripts, or stylesheets are loaded. No internet connection is required to open the file.

Interactive Features by Report Type

Report	Features
Permissions	Column sort, real-time filter, group-by-user toggle
Storage	Bar charts, collapsible folder tree, column sort
File Search	Real-time filter, column sort
Duplicates	Collapsible group cards, value highlighting, expand/collapse all

Sharing HTML Reports

Email the .html file as an attachment
Upload to a SharePoint document library
Copy to a shared network folder

Recipients do not need SharePoint ToolBox or PowerShell installed to view the report.

Output Folder

The output folder for all reports is configured in the Output folder field on the connection panel. See Connection and Profiles. The folder must exist before a report is generated — the tool does not create it automatically.