How to Export Azure AD SAML Certificate Expiration Dates to Excel
Question details
The user needs to export certificate expiration dates for over 1,000 SAML enterprise applications from Azure AD to Excel to manage renewal reminders.

- Product
- Azure Active Directory
- Device & OS
- not provided
- Scenario
- Managing large-scale SAML enterprise applications and ensuring certificates do not expire unnoticed.
- Observed behavior
- Azure AD does not offer a native bulk-export button to download all SAML certificate expiration dates directly to an Excel or CSV file.
Verify that you have Global Administrator or Application Administrator privileges in your Azure portal and have access to run Azure AD PowerShell scripts in your environment.
Use Azure AD PowerShell to Export Expiration Dates to CSV
Since Azure AD lacks a bulk export button, using a PowerShell script is the most efficient way to extract certificate expiration dates for multiple applications.
By utilizing Azure AD PowerShell or the Microsoft Graph API, you can programmatically iterate through all your enterprise applications. The script can extract the KeyCredentials property, which houses the certificate end dates, and output them into a structured format like a CSV file that easily opens in a spreadsheet application.
Launch Windows PowerShell on your system with Administrator privileges.
Run the command `Connect-AzureAD` and log in with your administrator credentials.
Execute a custom script to loop through `Get-AzureADServicePrincipal` and capture the `EndDate` from the `KeyCredentials` property.
Pipe the script's output to the `Export-Csv` cmdlet, specifying a file path (e.g., `Export-Csv -Path C:\saml-certs.csv -NoTypeInformation`). You can then open this file in your spreadsheet software.

Configure Individual Email Notifications in Azure AD
For critical applications, you can configure Azure AD to send automated email reminders when a SAML certificate is nearing its expiration date.
Manage Your Exported Azure AD Certificate Data with WPS Office
Once you have successfully exported your SAML certificate expiration dates to a CSV file, you need a reliable spreadsheet tool to track and filter the renewals. WPS Office is a highly compatible, lightweight, and free alternative to Microsoft Office that handles large datasets effortlessly.
- 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
- 2. Open Your Exported Data: Launch WPS Spreadsheet and open the CSV file you exported from Azure AD.
- 3. Sort and Track Dates: Use the built-in sorting and conditional formatting tools to highlight certificates that are approaching their expiration dates.

Frequently Asked Questions
Is there a built-in button in Azure AD to export all SAML certificates?
No, Azure AD does not currently offer a native bulk-export feature in the portal. Administrators must use the Microsoft Graph API or PowerShell scripts to extract expiration dates for multiple applications at once.
How early does Azure AD send SAML certificate expiration notifications?
If you configure a notification email address in the SAML Signing Certificate settings, Azure AD typically sends automated email reminders 30, 15, 7, and 1 day before the active certificate expires.
How do I correctly view the exported CSV file?
You can open the exported CSV file using any standard spreadsheet software like WPS Spreadsheet or Microsoft Excel. Make sure to select the correct delimiter (usually a comma) so the application names and expiration dates format into separate columns cleanly.




