Automatically Generate ER Diagrams from SharePoint ERD Generator

Source: Dev.to

Overview

SharePoint is widely used as a lightweight data platform within Microsoft 365 environments.
To simplify documentation of SharePoint list structures, a browser extension called SharePoint ERD Generator was created. The extension extracts metadata from lists in a SharePoint site and automatically generates:

• PlantUML ER diagram code
• Excel‑based table definitions (one sheet per list)
• Lookup relationship mappings
• Optional list filtering

This enables quick visualization and documentation without manual diagram creation.

How to Use

1. Open the SharePoint site that contains the lists you want to document.
2. Click SharePoint ERD Generator in your browser toolbar.
3. Configure the options you need (see below).
4. Click Generate Diagram.

The extension will then produce UML code and provide:

• Excel export
• List filtering
• PlantUML preview
• Copy‑to‑clipboard for the UML code

Configuration Options

• Language – Choose Japanese (JP) or English (EN); this setting affects both the UML output and Excel headers.
• Column name style – Select either Internal Name or Display Name for column identifiers.
• Custom Excel columns – Add extra columns such as Notes or Description to the exported Excel file.

Use Cases

• Reviewing existing SharePoint‑based systems
• Creating structured design documentation
• Performing impact analysis
• Preparing migration to Dataverse
• Improving governance and visibility

Feedback and feature suggestions are welcome.

---

Note: This article is based on a Japanese post originally published on Qiita and translated into English.
Original post on Qiita