Sitenalyzer is an open-source inventory and data dictionary tool for SharePoint Online. It runs on a page in your site and reports the site's lists, document libraries, columns, permissions, agents, and site skills. It can also save that report as an Excel data dictionary. It is designed for data stewards, research teams, SharePoint administrators, developers, security analysts, and data analysts.
With Sitenalyzer, you can:
- Review every list and library, with its columns, descriptions, and item counts, every site page, and the agents and site skills saved on the site.
- Check permissions for the site and for each list or library, including apps that have access.
- See who can open what, by person or group, with the members of each SharePoint group, and check what one person can do.
- Spot guests, organization-wide access, and sharing links that anyone can use, and find lists and libraries to review.
- Save a data dictionary or a permissions workbook as an Excel file, or print the whole report or save it as a PDF.
- Move between an Overview, Contents, Permissions, Taxonomy, and Site review, and search the whole report, with results grouped by kind.
- Edit site, list, column, and term descriptions, if you own the site.
- Turn on technical details to see internal names, and copy the site, list, and library IDs needed for Microsoft Graph and Microsoft Entra apps.
- Hide values that look like personal information, such as phone numbers, on screen, in printouts, and in workbooks, until you choose to show them.
- First, make sure the "Modern Script Editor" app is installed. If it isn't available, ask your site administrator to install it.
- In your site's Site Assets library (Settings > Site contents > Site Assets), create two folders named
scriptsandstyles. - Copy every file from dist/SiteAssets/scripts/ to your site's
SiteAssets/scriptsfolder. - Copy every file from dist/SiteAssets/styles/ to your site's
SiteAssets/stylesfolder. - Go to your site's home page and create a new page from the Modern Script Editor template (Home > New > Page > Modern Script Editor). Use
sitenalyzerfor the page title, so the page address ends in/SitePages/sitenalyzer.aspx. - Select the "{ }" button under Edit HTML Code to open the code editor. Copy the contents of dist/SitePages/sitenalyzer.html.txt and paste them into the code editor. Select Save in the code editor to close it, then select Save on the page to leave edit mode.
- Refresh the page.
- Enter a site address, or keep the current site's address in the box, and select Extract site information.
- To save the data dictionary as a spreadsheet, select Data dictionary (.xlsx). To save every permission, select Permissions workbook (.xlsx).
To install a newer version, copy the files from dist/SiteAssets again and replace the old ones. You don't need to change the page.
- Complete documentation: See the
/docsfolder in this repository: installing and using Sitenalyzer, troubleshooting, architecture, and building and testing. - Overview for researchers and developers: Visit the Health Research Resource Library for a high-level summary, key features, and important assumptions.
- Project instructions for contributors and AI coding tools: See AGENTS.md and the skills index.
- This script was created to facilitate the process for creating Microsoft Entra applications at Michigan Medicine. For more information, see "How to Connect to SharePoint from Scripts, Workflows or Data Pipelines" (UM login required).
The Mobile Technologies Core provides investigators across the University of Michigan the support and guidance needed to utilize mobile technologies and digital mental health measures in their studies. Experienced faculty and staff offer hands-on consultative services to researchers throughout the University – regardless of specialty or research focus.
Learn more at: https://depressioncenter.org/mobiletech.
To get in touch, contact the individual developers in the check-in history.
If you need assistance identifying a contact person, email the EFDC's Mobile Technologies Core at: efdc-mobiletech@umich.edu.
- Eisenberg Family Depression Center (@DepressionCenter)
- Jeremy Gluskin (@jerm-ops)
- Shelley Boa (@blondilox-ai) - Program Manager, Internal Medicine / Pulmonology & Critical Care, Michigan Medicine.
- DataLaVista™. A lightweight, client-side reporting and dashboard toolkit. This project re-uses some of the SharePoint connection functions.
- Modern Script Editor - The PnP/SPFX delivery vehicle used to deploy this "Unit" into modern SharePoint environments.
- Microsoft SharePoint REST API - The primary data uplink for retrieving SharePoint List items and Document Library metadata.
- SheetJS - Reads and writes spreadsheet files. Sitenalyzer uses it to save the data dictionary as an Excel file. A copy of SheetJS Community Edition 0.20.3 is included in
dist/SiteAssets/scripts. License: Apache License 2.0. - Tabulator - Creates interactive tables. Sitenalyzer uses it to show columns and folders in searchable tables. A copy of Tabulator 6.6.1 is included in
dist/SiteAssets. License: MIT. - See THIRD-PARTY-NOTICES.md for the full license texts of the included libraries.
Copyright © 2026 The Regents of the University of Michigan
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program. If not, see https://www.gnu.org/licenses/gpl-3.0-standalone.html.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. You should have received a copy of the license included in the section entitled "GNU Free Documentation License". If not, see https://www.gnu.org/licenses/fdl-1.3-standalone.html
If you find this repository, code or paper useful for your research, please cite it.
Mongefranco, Gabriel (2026). Sitenalyzer. Eisenberg Family Depression Center, University of Michigan. Software. https://github.com/DepressionCenter/Sitenalyzer DOI: 10.5281/zenodo.23371816
Copyright © 2026 The Regents of the University of Michigan