How to Find and Export a List of SharePoint Apps and Web Parts to Excel
Question details
A training team needs a reference list of SharePoint apps and web parts with descriptions, ideally in a spreadsheet format, to help staff identify useful tools.
- Product
- SharePoint, Excel
- Device & OS
- not provided
- Scenario
- Gathering reference materials for team training to help staff discover useful site tools.
- Observed behavior
- Users need to locate available built-in and third-party SharePoint components and manually compile them into a spreadsheet because no direct Excel download is provided.
Ensure you have adequate permissions (such as Site Owner or Designer) on your SharePoint site to view site contents and access the SharePoint Store.
Locate Built-in Apps and Web Parts via Site Contents
Use your SharePoint site's native menus to view available built-in applications and modern web parts.
Navigate to your SharePoint site and log in. Click on the gear icon to open Settings, then select 'Site contents'.
Click the 'New' button at the top of the Site contents page, then select 'App' from the dropdown menu to view built-in applications.
To explore external tools, click on 'SharePoint Store' from the left sidebar or visit the Microsoft AppSource website.
Manually Export the Web Part List to a Spreadsheet
Since an official downloadable Excel file isn't provided by Microsoft, manually copy the catalog lists into a spreadsheet for local filtering and saving.
Organize Your SharePoint App Lists Seamlessly with WPS Office
While SharePoint doesn't natively export its app catalogs to Excel, you can easily copy and paste the reference information into WPS Spreadsheet. WPS Office is a free, lightweight suite that offers robust spreadsheet tools, allowing your training team to filter, format, and share tool lists effortlessly.
- 1. Download and Install WPS Office: Get WPS Office for free from the official website and follow the simple installation instructions.
- 2. Create a New Spreadsheet: Launch WPS Office, select 'Spreadsheet', and open a new blank workbook.
- 3. Paste and Organize Data: Paste your copied SharePoint web parts list and use the built-in Data tools to filter and sort your training references.
Frequently Asked Questions
Can I download a complete list of SharePoint web parts directly to Excel?
No, Microsoft currently provides this information only as web articles. You must manually copy and paste the tables into a spreadsheet program like WPS Spreadsheet or Excel to save and filter them locally.
Where can I find modern page components for SharePoint?
Modern page components and web parts are documented extensively on Microsoft's official support site. You can also view available web parts by editing any modern SharePoint page and clicking the '+' icon to open the web part toolbox.
Why is the 'App' option missing from my Site Contents menu?
The 'App' option requires specific site permissions. If you do not see it under the 'New' menu, contact your site administrator to grant you Site Owner or Designer privileges.
