Active Sites Export Misses Recent Sites: Root Cause and Fix

When you export the list of active sites from the SharePoint admin center, you may notice that recently created or modified sites do not appear in the CSV file. This problem occurs because the export feature relies on cached data that refreshes on a fixed schedule rather than in real time. The missing sites can cause confusion during audits or site inventory reviews. This article explains why the export is incomplete and provides a reliable method to force the data to refresh so that all active sites are included.

Why the Active Sites Export Does Not Include Recent Sites

The Active Sites list in the SharePoint admin center displays all sites that are not in the recycle bin and have not been deleted. However, the data shown in this list is not pulled from the live SharePoint database every time you open the page. Instead, the admin center uses a cached data store that is updated on a periodic schedule. Microsoft does not publish the exact refresh interval, but testing shows the cache typically updates every 24 hours.

When you create a new site or restore a deleted site, the change is written to the SharePoint database immediately. The site becomes active and usable right away. But the Active Sites export function reads from the cache, not the live database. If the cache has not refreshed since the site was created or modified, that site will be missing from the export file.

This behavior is by design to reduce load on the backend systems. The export is intended for periodic inventory reports, not real-time monitoring. If you need a complete list that includes every active site up to the current moment, you must either refresh the cache manually or use a different data retrieval method.

Steps to Force a Refresh and Export All Active Sites

1. Sign in to the SharePoint admin center
   Go to https://admin.microsoft.com and sign in with a Global Admin or SharePoint Admin account. In the left navigation, select Show all then Admin centers then SharePoint.
2. Open the Active sites page
   In the SharePoint admin center left menu, select Active sites. The site list loads using cached data. You will see a timestamp at the top of the page that says “Last updated” followed by a date and time. This indicates when the cache was last refreshed.
3. Click the Refresh button
   On the toolbar above the site list, click Refresh. This triggers a manual request to update the cache from the live database. The “Last updated” timestamp will change to the current time after the refresh completes, which may take 30 seconds to 2 minutes depending on the number of sites in your tenant.
4. Verify that recent sites appear
   After the refresh, scroll through the list or use the search box to find a site you recently created. If it appears, the cache now includes that site.
5. Export the site list
   Click Export on the toolbar. The export generates a CSV file containing all sites currently shown in the list. Because you refreshed the cache, this file will include the recent sites.

If you prefer to use PowerShell for a more direct approach, run the following command in the SharePoint Online Management Shell:

Get-SPOSite -Limit All | Select-Object Url, Title, LastContentModifiedDate | Export-Csv -Path "C:\temp\AllSites.csv" -NoTypeInformation

This command retrieves site data directly from the backend and bypasses the admin center cache entirely. The output includes every active site in the tenant regardless of when it was created or last modified.

If the Active Sites Export Still Misses Sites After Refreshing

“I refreshed the cache but the site is still missing from the export”

If you clicked Refresh and the site still does not appear, the cache update may have failed silently. Try refreshing the page first by pressing Ctrl+F5 in your browser to force a full page reload from the server. Then repeat the steps above.

“The site was deleted and restored, but it does not show in active sites”

When you restore a deleted site from the SharePoint recycle bin, the site becomes active again. However, the Active Sites list may not include it until the cache refreshes. Use the Refresh button or the PowerShell command to verify the site is back in the list.

“The export file contains duplicate entries for the same site”

Duplicates can occur if the same site is listed under multiple URLs due to site collection renaming or redirection. Check the site collection URL in the export. If duplicates persist, run the PowerShell command with the -IncludePersonalSite $false parameter to exclude OneDrive personal sites, which sometimes appear as duplicates in the admin center export.

“The export takes too long to generate”

For tenants with more than 10,000 sites, the export may time out. In that case, use the PowerShell approach with a filter to export sites in batches. For example:

Get-SPOSite -Limit 5000 -Filter "Url -like 'https://yourtenant.sharepoint.com/sites/'" | Export-Csv -Path "C:\temp\SitesBatch1.csv"

Active Sites Export vs PowerShell: Key Differences

Item	SharePoint Admin Center Export	PowerShell Get-SPOSite
Data source	Cached data refreshed every 24 hours or on demand	Live SharePoint database
Refresh control	Manual Refresh button available	Always real-time, no refresh needed
Maximum sites	Up to 10,000 sites in one export	Tenant-wide with Limit All parameter
Filtering options	Basic search in the admin center UI	Full filtering with -Filter parameter
Output format	CSV file with predefined columns	Customizable via Select-Object
Authentication	Browser session (admin center login)	SharePoint Online Management Shell login

The admin center export is convenient for quick reports but relies on cached data. PowerShell gives you complete control and real-time accuracy at the cost of requiring the SharePoint Online Management Shell module. For regular inventory tasks, schedule a PowerShell script to run daily and export the site list automatically.

Now you can ensure that every recent site appears in your Active Sites export. Use the Refresh button in the admin center before exporting to update the cache. For critical audits, rely on the Get-SPOSite PowerShell cmdlet to bypass the cache entirely. Consider setting up a recurring PowerShell export to maintain an always-current site inventory without manual steps.