Export a List of All Site Collections in SPO

Native Solution

Microsoft 365 Permission Required

High

Global Admin or SharePoint Admin.

Option 1 Using SharePoint Online Admin Center

Login to the SharePoint Online admin center.
Navigate to Sites»Active Sites. Under the Active Sites page, you can view all the SharePoint Online sites in Microsoft 365.

The ‘Active sites’ page lists all the site collections, encompassing both hub and channel sites, but won’t list the root websites within SharePoint Online.

Option 2 Using Windows PowerShell

Connect to SharePoint Online PowerShell using the below cmdlet.

Windows PowerShell

 Connect-SPOService -Url https://-admin.sharepoint.com

Run the below cmdlet to get all SharePoint Online sites using PowerShell.

Windows PowerShell

 Get-SPOSite | Where-Object { $_.Status -eq "Active" } | Select-Object Url, Title

The above cmdlet will display all the sites along with the root websites of each site collections.

AdminDroid Solution

More than 150 reports are under free edition.

AdminDroid Permission Required

Delegated

Any user with report access delegated by the Super Admin.

StepsUsing AdminDroid

Login to the AdminDroid Office 365 reporter.
Navigate to the All Site Collections report under Reports»SharePoint»Site Collections.
Using the easy filter option, set the following condition.

Utilize the above highlighted 'Total Sites' column to access all the sites within a site collection. Additionally, you can view the site type, site’s current storage, and the owner of the site collection.

In addition, the report includes built-in graphs that specifically show different types of site collection, such as communication sites and team sites.

Explore a full range of reporting options

Master your SharePoint Online management with precision!

Eliminate the challenges of navigating through multiple sites! Gain a unified view of all the SharePoint Online site collections with AdminDroid.

Witness the report in action using the

Live Demo

Important Tips

Enhance SharePoint Online security by restricting SharePoint site access to predefined sharing configurations by consistently reviewing and managing site settings.

Monitor SharePoint Online external sharing to get a detailed analysis of file access activities performed by external users, preventing sensitive data leaks.

Manage SharePoint Online storage by either increasing the allocated space or removing unused content from sites that have exceeded allocated storage limits.

SharePoint OnlineManage SharePoint Online Site Collections and Sites in Microsoft 365

Showing 1 of 7

What are the different types of SharePoint Online sites? How to create a site collection in SharePoint Online? How to manage site creation in SharePoint Online? How to create a subsite in SharePoint Online? How to create a hub site in SharePoint Online? How to sync hub permissions to associated sites in SharePoint Online? How to manage SharePoint Online permissions?

What are the different types of SharePoint Online sites?

A SharePoint Online site functions like a website featuring various SharePoint web parts such as document library, calendar, task list, and more. It provides a centralized location for creating, sharing, and managing content.

Also, it’ll be helpful in enhancing collaboration, and information management within organizations. It caters to a wide range of use cases across different departments and teams.

There are two primary types of SharePoint Online sites: Communication sites and Team sites.

Communication Sites

Communication sites are designed for sharing information to a broad audience and are not typically used for collaboration. While these sites cannot currently be used for external collaboration, they are suitable for securing access to a large, automatically updated group, such as all staff in a faculty.

Team Sites

Team site with Microsoft 365 group: A team site with Microsoft 365 group provides a platform integrating SharePoint Online with Office 365 services like Teams, Outlook, and Planner, facilitating seamless collaboration with shared resources like calendars, task management tools, and centralized permissions.
Team site without Microsoft 365 group: A team site without Office 365 group lets you customize who can access them directly within the site. It plays a vital role for document storage and collaboration, and don't have as many integrated tools such as Outlook, Teams, and Planner for communication.

With AdminDroid’s export functionality, you shall easily export all SharePoint sites to CSV and other formats according to your preferences. Along with that, you shall easily schedule and email those reports based on your chosen settings.

How to create a site collection in SharePoint Online?

Site collections serve as groups of multiple sub sites, typically organized in a hierarchical structure where a parent site contains several subsites.

Follow the steps below to create a site collection in SharePoint Online:

Login to the SharePoint Online admin center.
Navigate to the ‘Active sites’ under Sites, and then click on Create.
Select the type of site you want to create: A Team site or a Communication site.
Then, in the Template selection section, choose a team site template and click ‘Use Template’.
Now, enter the site name, group email, site address, and group owner information.
Set language and privacy settings, then click Create site in SharePoint Online and add desired members to complete team site creation.

Create a new site collection in SharePoint using PowerShell

Run the below cmdlet to create a new SharePoint site collection using PowerShell.

New-SPOSite -Url https://yourtenant-admin.sharepoint.com/sites/yoursitename -Owner youradmin@domain.com -StorageQuota 1000 -Title "yoursitename" -Template STS#0

When a site is created in SharePoint Online, the default groups are automatically generated. These groups are configured with the default permission levels, granting users with specific rights and access.

Site Visitors- have read-only access.
Site Members- can read, download, and manage documents.
Site Owners- have full control over the SharePoint site, including security, adding web parts, and navigation control.

Using AdminDroid, you can easily retrieve a comprehensive list of site collections and their properties in SharePoint Online.

Also, it’ll provide detailed insights on total subsites, site types, and site storage information. It enables effective organization and utilization of your SharePoint environment to meet organizational needs.
Pro-tip: Use the easy filter option with ‘Site type - Team sites’ to get all the team sites created within your SharePoint Online environment.

How to manage site creation in SharePoint Online?

As a SharePoint admin, you can empower your users to create and manage their SharePoint sites independently. You can customize the permissions to allow only specific users to create a SharePoint site.

By default, users can create both communication sites and team sites that are linked to their Microsoft 365 groups.

Enable site creation in SharePoint Online

Login to the SharePoint Online admin center.
Click the ‘Settings’ tab . Then, on the Site creation page, check the 'Users can create SharePoint sites' box. Enable options for creating sites and shared libraries.
Then, specify settings for Microsoft 365 group-connected team sites, including time zone and storage limit. Now, select ‘Save’.

Enable subsite creation in SharePoint Online

Login to the SharePoint Online admin center.
Click the ‘Settings’ tab and navigate to the ‘Classic settings page’.
Under the ‘Subsite creation’ section, select the ‘Enable subsite creation for all sites’ option, and click ‘OK'.
Then, select the ‘Show the create site command’ option in the ‘Site creation’ section.
If you choose not to activate this feature, keep the default setting, which is disabled.

Pro Tip: Optimal SharePoint Online management involves disabling subsite creation and utilizing hub sites for centralized control over permissions, storage, add-ons, services, and sharing at the site collection level.

How to create a subsite in SharePoint Online?

A SharePoint Online subsite refers to a website nested within a parent SharePoint site, enabling users to efficiently organize and manage content with tailored permissions and configurations.

Discover the techniques for creating and overseeing subsites in SharePoint to enhance team collaboration.

Follow the steps below to create a subsite in SharePoint Online:

Go to your SharePoint Online site.
Click on Site contents in the left panel. Once navigated, click +New and select Subsite.
Fill in the required information based on your needs.
Choose a template from the Templates selection. If it's for document collaboration, the default Team site template is usually a good choice.
Decide on permissions. If you want a new set of permissions, choose 'User unique Permission'. Otherwise, it will inherit the permissions from the parent site.
Click on Create.

When creating a new SharePoint Online subsite, you can choose either to inherit permissions from the parent site or have unique permissions for the subsite. If necessary, permission settings can also be modified to switch between inheritance and unique permissions.

Move a subsite within the site collection

If you’re willing to move the third-level subsite to another second level (i.e.) to a parent site, follow these steps to organize subsites in a nested structure.

Access the ‘site manager’ page using the provided link:

https://yourtenant.sharepoint.com/sites//_layouts/15/sitemanager.aspx

- On the site manager page, you will see a tree view displaying sites, folders, lists, and libraries. Locate the subsite you wish to move
Select the desired subsite and click on Move.
A new window will appear after selecting the move operation. Here, specify the target site within the site collection.
Choose the destination SharePoint site and confirm your selection by clicking the 'OK' button.

Note: The site manager page can only be accessed by SharePoint administrators and Global administrators.

With AdminDroid, you can easily view the list of all subsites within a SharePoint Online site collection.

Make use of the interlinks in the Total sites column to view all the sites within the site collection. Also, it is important to note that the count may include the parent site, so you can easily find the subsites by excluding the parent site.
Screenshot Hint: The highlighted one below is the parent site, while the others are subsites within the collection.

How to create a hub site in SharePoint Online?

Hub sites in SharePoint Online offer a flexible and efficient way to organize related sites into a central portal and manage all the connected sites based on organizational attributes such as projects, concepts, teams, departments, divisions, and regions.

A SharePoint hub site can be linked to both modern team sites and communication sites.

To create a hub site, you must register a site to a hub and then associate other sites to the registered hub site.

Register a hub site in SharePoint Online:

Login to the SharePoint Online admin center.
Select the site, navigate to Hub on the command bar, and then click Register as a hub site.
Enter a name for the new hub in the panel that appears on the right.
Specify users who can associate sites with the hub.
Click the 'Save' button at the bottom of the panel.

After completing these steps, the selected site becomes the hub site for a newly created hub. Now, you can proceed to associate other SharePoint sites with this hub as needed.

Associate a SharePoint site with a hub site:

Login to the SharePoint Online admin center.
Select the site you want to associate with another hub. Then, in the Hub dropdown, select "Associate with a hub option".
On the next screen, select a hub you would like to associate with.
Also, if you wish to associate multiple sites to a hub, select those sites and click on the 'Bulk edit' button in the command bar.
Now, click on the hub association option. Once done, a panel will appear, then choose a hub for associating the site(s). Click the ‘Save’ button.

Using Microsoft PowerShell

Run the below cmdlet to register a new site collection as a hub site using PowerShell.


Register-SPOHubSite https:///sites/ -Principals $null

Run the below cmdlet to associate a site with a hub site using PowerShell.


Add-SPOHubSiteAssociation -SiteUrl  -HubSiteId

Efforlessly monitor the hub sites creation in SharePoint online Using AdminDroid.

you can get comprehensive insights into the users responsible for creating these hub sites and their associated sites.
Also, the alerting feature will keep you informed whenever a new hub site is registered in your SharePoint environment.

How to sync hub permissions to associated sites in SharePoint Online?

SharePoint Online sync hub permissions will be helpful in giving users visitor access to all the sites within a hub without having to manually add them to each site. Associating a SharePoint site with a hub site facilitates seamless exploration of related content, news, and site activity across all associated sites.

Follow the steps below to enable hub sync permissions in SharePoint Online.

Go to the parent hub site. Click on the Gear Icon»Site Permissions.
Navigate to the hub tab and activate the 'Sync hub permissions to associated sites' toggle switch. Then, include the user/group of your choice to grant read-only access to both the hub and all associated sites.

Note: You cannot grant permissions exclusively to a distribution list.

You can also enable the sync permissions from any of the associated sites.

Navigate to one of the associated sites and select Gear Icon»Site Permissions, then click on the Hub Tab at the top.
Enable the toggle switch to sync Hub permissions to this site.

With AdminDroid, you can effortlessly track whether permission sync has been enabled for a hub site to ensure consistent access across all associated sites within the hub. As an administrator, monitor visitors' access permissions and who assigned them.

How to manage SharePoint Online permissions?

To prevent data leaks and work efficiently in SharePoint Online, it's important to set permissions based on user’s roles and tasks. There are different permission levels for the entire site collection, specific sites, lists, and individual items. For instance, a site owner can create or delete pages, while a site member can only edit or view them.

SharePoint utilizes permission levels, such as Full Control, Design, Edit, Contribute, and Read to define specific actions users or groups can perform.

Access is granted through two methods in SharePoint Online:

By direct assignment to SharePoint sites, lists, or list items with a particular permission level.
By adding users or security groups to a SharePoint group already assigned with a specific permission level.

Understanding these levels is crucial before making any modifications.

Create custom SharePoint groups and permissions:

To create a custom SharePoint permission,

Select the desired site. Then, under Gear Icon»Site Permissions.
Now click ‘Advanced permission settings’ and navigate to 'Permission Levels,' to ‘Add a Permission Level, by specifying the desired permissions, and establish the group for the newly created permission level.

To create a SharePoint group with the custom permission level,

Once navigated to the Advanced permission settings under 'Site Permissions' by clicking ‘Site settings’.
Create a 'Group' from the 'Permissions' tab and fill out details. Now select the desired custom permission level and create the group for site access.

Add members to your SharePoint team site:

To give user access to a SharePoint Online site, navigate to the desired site and select "Add members" under Site permissions and proceed by selecting the desired options provided below.

To Add Members to Office 365 Group:

Choose Add Members to Group.
Enter a name/email and click 'Save'.

To Share Site Only (Without Office 365 Group):

Select Share Site Only.
Enter a name or email, choose permission level, and click 'Add.'

AdminDroid SharePoint Online ReporterElevate Your SharePoint Online Management to New Heights!

Featuring AdminDroid's SharePoint Online management tool an asset to elevate your capabilities in optimizing SharePoint Online. This tool provides comprehensive insights into critical aspects such as SharePoint site permissions, external file sharing, site storage utilization, ownership details, group memberships, and more. By closely monitoring these reports, you can prevent data misuse within the organization.

Explore the advanced capabilities of AdminDroid for comprehensive SharePoint Online administration.

With All Site Collections report you can view all sites and subsites in SharePoint Online, including their type and storage details. This facilitates the efficient management of SharePoint Online site collections, empowering admins to maintain a secure and organized collaborative environment.

A Quick Dive into the Functionalities

Track File Access Activities in SPO

Secure your environment with AdminDroid's detailed SharePoint file access report. With this report, you can easily get insights into user activity and file interactions.

Monitor Site Collection Admin Changes

Audit SharePoint site collection admin additions within your Microsoft 365 environment to efficiently track all admin-related changes, ensuring that only legitimate users are added as admins.

Alerts on Site Collections Deletions

Receiving real-time alerts on SharePoint Online site collection deletions helps admins to stay updated and promptly identify any changes that require immediate action.

Visualize SharePoint Data with Graphical Charts

Leverage the SharePoint analytics dashboard to get a comprehensive view of SPO sites, inactive sites, sharing configurations, and site storage usage.

Comprehensive SharePoint Online Oversight

Getting hands on SharePoint Online insights enables you to visualize site collections, lists, external sharing settings, and SharePoint groups effectively.

Review SharePoint Online DLP

Keep an eye on the SharePoint Online DLP rule matches report for detecting and preventing the loss of sensitive information.

In summary, these tips and best practices offer a practical roadmap for SharePoint admins to efficiently configure SharePoint site and manage site access permissions in Microsoft 365. By following these insights, admins can enhance SharePoint security measures to safeguard against potential vulnerabilities and elevate their overall SharePoint Online management with ease.

Kickstart Your Journey with AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities!

Download

Common Errors and Resolution Steps related to SPO sites in SharePoint Online

The following are the possible errors and troubleshooting hints while getting all SPO sites in SharePoint Online.

Error: Get-SPOSite: The term 'Get-SPOSite' is not recognized as the name of a cmdlet.

This error occurs when the SharePoint Online Management Shell module is not installed or imported.

Troubleshooting hint :Run the below cmdlet for installing it.

// Run the below cmdlet for installing it.
Install-Module -Name Microsoft.Online.SharePoint.PowerShell -Force -AllowClobber
// Run the below cmdlet for importing it.
Import-Module Microsoft.Online.SharePoint.PowerShell

Error: Connect-SPOService: Unable to connect to the SharePoint Online service.

This error occurs when there is an issue with authentication or the provided credentials.

Troubleshooting hint :Recheck and update the SharePoint Online admin credentials. Use the following cmdlet to connect.

Connect-SPOService -Url https://-admin.sharepoint.com -Credential $adminCred

Error: Get-SPOSite: Access is denied. You do not have permission to perform this action.

The Microsoft 365 user running the PowerShell cmdlet lacks the necessary permissions to retrieve site information.

Troubleshooting hint :Ensure that the account has the required SharePoint admin or site collection administrator permissions. Verify permissions using the SharePoint admin center.

// Run the below cmdlet for Connecting to SharePoint Online Tenant Admin.
Connect-SPOService -Url https://-admin.sharepoint.com -Credential $adminCred
// Run the below cmdlet to disable the ‘DenyAddAndCustomizePages’ flag.
Set-SPOSite Url https://-admin.sharepoint.com -DenyAddAndCustomizePages $False

Error: Get-SPOSite: The site with the URL '' could not be found.

The specified SharePoint Online site URL is incorrect or does not exist.

Troubleshooting hint :Double-check the site URL and verify whether the site exists. Ensure proper connectivity and that the site is accessible.

Error: Set-SPOSite: The site is locked for editing and cannot be modified.

This error indicates that the SharePoint site is currently locked for editing, and modifications are not allowed.

Troubleshooting hint :Check if the site is locked and unlock it using the following cmdlet.

Set-SPOSite -Identity  -LockState Unlock

Delivering Reports on Time

Want a desired Microsoft 365 reports every Monday morning? Ensure automated report distribution and timely delivery with AdminDroid’s Scheduling to your email anytime you need.

Schedule tailored reports to execute automatically at the time you set and deliver straight to the emails you choose. In addition, you can customize report columns and add intelligent filtering to the activities just from the previous day to suit your Microsoft 365 report requirements.

Set It, Schedule It, See Results - Your Reports, Your Way, On Your Time!

Time Saving Automation Customization Intelligent Filtering

Give Just the Right Access to the Right People

Grant fine-tuned access to any Microsoft 365 user with AdminDroid’s Granular Delegation and meet your organization’s security and compliance requirements.

Create custom roles loaded with just the right permissions and give access to admins or normal users within AdminDroid. The result? A streamlined Microsoft 365 management experience that aligns your organization's security protocols and saves your invaluable time and effort.

Align, Define, Simplify: AdminDroid's Granular Delegation

Smart Organizational Control Effortless M365 Management Simplified Access

Advanced Alerts at a Glance

Receive quick notifications for malicious Microsoft 365 activities. Engage with the AdminDroid’s real-time alert policies crafted to streamline your security investigations.

Stay informed of critical activities like suspicious emails and high-risk logins, bulk file sharing, etc. Through creating and validating ideal alert policies, AdminDroid provides a comprehensive approach to real-time monitoring and management of potential threats within your organization.

AdminDroid Keeps You Always Vigilant, Never Vulnerable!

Proactive Protection Real-time Monitoring Security Intelligence Threat Detection

Merge the Required Data to One Place

Combine multiple required columns into one comprehensive report and prioritize the information that matters most to you with AdminDroid’s Advanced Column Customization.

This column merging capability offers a flexible way to add different columns from various reports and collate all the essential data in one place. Want to revisit the customized report? Save it as a 'View’, and your unique report is ready whenever you need it.

Merge with Ease and Save as Views!

Custom Reporting Unique View Desired Columns Easy Data Interpretation

Insightful Charts and Exclusive Dashboards

Get a quick and easy overview of your tenant's activity, identify potential problems, and take action to protect your data with AdminDroid’s Charts and Dashboards.

With AdminDroid charts and dashboards, visualize your Microsoft 365 tenant in ways you've never thought possible. It's not just about viewing; it's about understanding, controlling, and transforming your Microsoft 365 environment.

Explore Your Microsoft 365 Tenant in a Whole New Way!

Executive overviews Interactive insights Decision-making Data Visualization

Efficient Report Exporting for Microsoft 365

Downloading your reports in the right file format shouldn’t be a hassle with AdminDroid’s Report Export. Experience seamless report exporting in various formats that cater to your needs.

Navigate through diverse options and export Microsoft 365 reports flawlessly in your desired file format. Tailor your reports precisely as you need them and save them directly to your computer.

Take Control, Customize and Deliver- Your Office 365 Data, Exported in Your Way!

Easy Export Seamless Downloading Data Control Manage Microsoft 365

How to Get a Report on All Site Collections in SharePoint Online