SharePoint Active Sites Export Misses Recent Sites: What Site Owners Should Check

When you export the list of active sites from the SharePoint admin center, you might notice that recently created or modified sites are missing from the CSV file. This typically happens because the export operation captures a point-in-time snapshot that does not include sites still being processed or those that have not yet been indexed. In this article, you will learn why recent sites are omitted from the export and which settings and filters to verify to ensure your export includes every active site.

Why Recent Sites Are Missing from the SharePoint Active Sites Export

The SharePoint admin center Active sites page shows all sites in your tenant. When you click Export, SharePoint generates a CSV file containing the list of sites at that exact moment. The export process does not include sites that are still being provisioned, sites that have not been fully indexed by search, or sites that were created within the last few minutes. This is by design: the export relies on a cached data set that updates periodically, not in real time.

Another reason sites may be missing is the default filter on the Active sites page. By default, the page shows only sites with the status Active. If a site is stuck in a provisioning state or has a status like Error or Provisioning, it will not appear in the default view and therefore will not be included in the export. Additionally, the export does not include private channel sites or sites that were recently deleted but still appear in the recycle bin.

How the Export Cache Works

The Active sites export pulls data from a background cache that refreshes every 24 to 48 hours. Sites created or modified within the last few hours may not yet be in that cache. If you need a real-time list, use the SharePoint Online Management Shell (PowerShell) instead of the admin center export. The Get-SPOSite cmdlet returns current site data directly from the SharePoint backend without cache delay.

Site Status vs. Site Activity

The export CSV includes columns like Status, Last activity, and Template. A site with status Provisioning or Error will not appear in the export if the filter is set to Active only. Similarly, a site that has zero activity since creation may still be listed if its status is Active, but it will show no last activity date. Do not confuse missing activity dates with missing sites — the site is present in the export even if the activity column is blank.

Steps to Verify and Fix the Missing Sites in the Export

1. Check the site status filter before exporting
   Go to SharePoint admin center > Active sites. Click the filter icon at the top of the site list. In the Status filter, select All instead of Active. This ensures that sites with status Provisioning, Error, or Redirect are also included in the export. After changing the filter, click Export again.
2. Wait for provisioning to finish
   If you just created a site, wait at least 30 minutes before exporting. Provisioning can take up to 15 minutes, and the cache update can take another 15 to 30 minutes. To confirm the site exists, search for its URL in the Active sites search box. If it appears in the list, it will be included in the next export.
3. Use PowerShell to export site data in real time
   Open SharePoint Online Management Shell as an administrator. Run the following command to export all site collections to a CSV file:
   Get-SPOSite -Limit All | Export-Csv -Path "C:\SitesExport.csv" -NoTypeInformation
   This command bypasses the admin center cache and returns all sites, including those still provisioning. Replace the file path as needed.
4. Verify the site is not a private channel site
   Private channel sites are not listed in the Active sites page by default. To include them, use the PowerShell command Get-SPOSite -IncludePersonalSite $true -Filter "Url -like '-my.sharepoint.com/personal/'". For private channel sites connected to Teams, use Get-SPOSite -Filter "Url -like '/sites/' -and Template -eq 'TEAMCHANNEL#1'".
5. Check the SharePoint activity report in Microsoft 365 admin center
   Go to Microsoft 365 admin center > Reports > Usage > SharePoint activity. This report shows site creation dates, file activity, and user counts for all sites. If a site appears here but not in the export, the site is active and the export filter is the cause. Use this report as a cross-reference.

If SharePoint Still Has Issues After the Main Fix

Export CSV Contains Duplicate Site URLs

Duplicate rows in the CSV often occur when a site has multiple URLs due to a rename or a redirect. Check the Original URL column in the export. If you see two rows with different URLs but the same site ID, one is a redirect site. Remove the redirect row manually. To prevent duplicates, avoid renaming sites frequently.

Export CSV Is Empty or Contains Only Headers

An empty CSV usually means no sites match the current filter. Go to SharePoint admin center > Active sites and clear all filters. Set the Status filter to All. If the CSV is still empty, your account may lack the SharePoint Administrator role. Verify your role in Microsoft 365 admin center > Users > Active users > select your account > Roles.

Recent Site Appears in Search but Not in Export

Search indexing updates faster than the Active sites cache. If a site appears in SharePoint search results but not in the export, wait 24 hours and re-export. Alternatively, use PowerShell to confirm the site exists. Run Get-SPOSite -Identity "https://yourtenant.sharepoint.com/sites/YourSite".

Active Sites Export vs. PowerShell Export: Key Differences

Item	Admin Center Export	PowerShell Export
Data freshness	Cache-based, up to 48 hours old	Real-time from SharePoint backend
Site status filter	Defaults to Active only	Returns all statuses by default
Private channel sites	Not included	Included with correct filter
File format	CSV with predefined columns	CSV with customizable columns
Permissions required	SharePoint Administrator	SharePoint Administrator or Global Admin

Use the admin center export for a quick, filtered list of active sites. Use PowerShell when you need a complete and current inventory, especially for troubleshooting missing sites.

You can now identify why recent sites are missing from the SharePoint Active sites export and apply the correct fix. Start by checking the site status filter and waiting for provisioning to complete. For a more reliable export, use the SharePoint Online Management Shell with the Get-SPOSite cmdlet to capture all sites in real time. If you frequently need fresh site lists, schedule a PowerShell script to run daily and save the CSV to a SharePoint document library.