Sitenalyzer
Data dictionary and security information extraction for SharePoint sites
Documentation from the repository README
Sitenalyzer
Description
Sitenalyzer is an open-source SharePoint Online inventory and data-dictionary tool built as a single HTML and JavaScript file. It catalogs lists, document libraries, columns, descriptions, internal IDs, and permissions, and can export the resulting SharePoint data dictionary to a spreadsheet.
Embed Sitenalyzer with the Modern Script Editor web part to document site structure, review permissions, edit list or column descriptions when authorized, and collect identifiers needed for Microsoft Graph and Microsoft Entra applications. It is designed for SharePoint administrators, developers, data stewards, and research operations teams.
Quick Start Guide
- First ensure you have the "Modern Script Editor" app installed. If not available, contact your site administrator to install it
- Go to your site's home page and create a new page using the Modern Script Editor template. Use "Sitenalyzer" for the page title.
- In the "Modern Script Editor" webpart, click "Markup" then click the "{ }" button to open the code editor.
- Copy and the paste the code from Sitenalyzer.html into the script editor.
- Note: If your SharePoint tenant has CSP restrictions that block inline JavaScript, you may need to separate the contents of the JavaScript file into its own .js file and store it in your site's Site Assets library. Then, update the script tag near the bottom of the file to point to htttp://you-tenant.sharepoint.com/sites/your-site/SiteAssets/Sitenalyzer.js.
- Save, and refresh the page.
Documentation
- The full documentation is available at: https://michmed.org/efdc-kb
Additional Resources
- 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).
About the Team
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.
Contact
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: [email protected].
Credits
Contributors:
- Eisenberg Family Depression Center (@DepressionCenter)
- Gabriel Mongefranco (@gabrielmongefranco)
- Jeremy Glskin (@jerm-ops)
This work is based in part on the following projects, libraries and/or studies:
- 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 - A library for reading, processing, and writing spreadsheet data.
- Tabulator - A library for creating interactive, data-rich tables and grids.
License
Copyright Notice
Copyright © 2026 The Regents of the University of Michigan
Software and Library License Notice
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.
Documentation License Notice
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
Citation
If you find this repository, code or paper useful for your research, please cite it.
Citation Example:
Mongefranco, Gabriel (2026). Sitenalyzer. University of Michigan. Software. https://github.com/DepressionCenter/Sitenalyzer
Copyright © 2026 The Regents of the University of Michigan

