M365Tools

A repository for utilities and tools to help with working with Microsoft 365. At this stage, there's just the one, but in time the intent is to build up the kit bag.

SharePoint Site Item Level Permissions Viewer (CSV → HTML)

A lightweight, single-page HTML viewer that helps SharePoint site owners and administrators understand item-level permissions at scale — by loading a CSV export and presenting a readable, filterable view of what’s been uniquely shared (libraries, folders, and items).

This tool is designed for scenarios where organisations want visibility into where unique permissions exist and who has access, to support oversharing reviews and security conversations.

---

What it does

• Loads a permissions export (CSV) and presents an interactive view of:
  • Resource paths (site/library/folder/item)
  • Permission levels
  • Users / groups and their types
  • Link-based sharing (where available)
• Supports column aliasing (so you can adapt to your export headers)
• Provides quick filtering/slicing to help answer:
  • “How much unique sharing exists in this site?”
  • “Which libraries/folders/items have unique permissions?”
  • “Who has access, and is it via direct permission or sharing link?”

Note: SharePoint does not reliably expose “when sharing occurred” in a simple exportable way for all scenarios. This viewer focuses on current state visibility from your export.

---

Who this is for

• SharePoint site owners doing periodic security reviews
• Microsoft 365 / information management teams assessing oversharing risk
• Consultants running discovery/remediation engagements across many sites

---

Quick start (end-to-end)

Step 1 — Export the report from SharePoint (XLSX)

1. Open the SharePoint site you want to review.
2. Go to Settings (⚙️) → Site usage.
3. Scroll to the bottom of the page to the export section.
4. Click Export report.
5. When prompted, choose a location in the site to generate and save the report (SharePoint will create an .xlsx file in the library/location you select).
6. Once the report is generated, download the .xlsx file to your computer.

Step 2 — Convert the XLSX to CSV

1. Open the downloaded .xlsx file in Excel.
2. Choose File → Save As.
3. Select CSV (Comma delimited) (*.csv) as the file type.
4. Save the .csv file.

You now have the CSV export needed for this viewer.

Step 3 — Load the CSV into the HTML viewer

1. Open the HTML file in a browser (Edge or Chrome recommended).
2. Click Load CSV and select your saved .csv file.
3. Use the filters/search to explore unique permissions and sharing links.

---

CSV format expected

The viewer expects a CSV containing the following fields (case-insensitive). Column aliases are supported, but these are the canonical names:

Canonical Column	Description
Resource Path	Full path to the library/folder/item
Item Type	e.g. Site, Library, Folder, File, List Item
Permission	Permission level/role assignment
User Name	Display name of the user/group
User Email	Email (if applicable)
User Or Group Type	User / M365 Group / SharePoint Group / Guest, etc.
Link ID	Identifier for sharing link (if applicable)
Link Type	e.g. Anonymous / Organisation / Specific People
AccessViaLinkID	Reference to link access relationship (if applicable)

Example header row

Resource Path,Item Type,Permission,User Name,User Email,User Or Group Type,Link ID,Link Type,AccessViaLinkID