Others

How to Export Azure AD SAML Certificate Expiration Dates to Excel

Bushra ParveenBushra Parveen Nov 4, 2026 870 views

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.

How to Export Azure AD SAML Certificate Expiration Dates to Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open PowerShell

Launch Windows PowerShell on your system with Administrator privileges.

2
Connect to Azure AD

Run the command `Connect-AzureAD` and log in with your administrator credentials.

3
Run the Extraction Script

Execute a custom script to loop through `Get-AzureADServicePrincipal` and capture the `EndDate` from the `KeyCredentials` property.

4
Export the Results

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.

Use Azure AD PowerShell to Export Expiration Dates to CSV
Custom Scripting Assistance: If you are unfamiliar with writing PowerShell scripts from scratch, consider browsing the Microsoft GitHub Community or Microsoft DevBlogs for pre-written scripts designed to find expiring certificates.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
  2. 2. Open Your Exported Data: Launch WPS Spreadsheet and open the CSV file you exported from Azure AD.
  3. 3. Sort and Track Dates: Use the built-in sorting and conditional formatting tools to highlight certificates that are approaching their expiration dates.
Fully compatible with Microsoft Excel formats (.xlsx, .csv, .xls)Lightweight design ensures large Azure AD data logs open instantlyCompletely free to use for tracking SAML expiration dates and IT assetsFamiliar spreadsheet interface requires no learning curve
microsoft office alternative - wps office

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.