Web and SSL Certificates · #66
Online Certificate Inventory and Renewal Calendar
Sorts certificate expiry dates, marks the renewal window and creates a calendar file.
- Data is processed in your browser and not sent to a server
- Export: CSV, ICS
Tool
What does this tool do?
An expired certificate stops a website, VPN, email or RADIUS authentication instantly. When certificates are spread across providers and teams, reminder emails get missed. The tool turns one list into a status table and an ICS file for Outlook or Google Calendar.
How to use it
- CSV header:
name, not_afterrequired;host, issuer, owneroptional. DateYYYY-MM-DDorDD.MM.YYYY. - Enter how many days before expiry renewal should start and optionally a reference date (empty = today).
- Press Run; download the table as CSV and reminders as ICS.
Fields
- Certificate list (CSV)
- Take the expiry date from the PEM Certificate Decoder.
- Renewal lead time (days)
- Reminder this many days before expiry.
- Reference date
- Empty means today.
Worked example
| Input | Value |
|---|---|
| Certificate list (CSV) | |
| Renewal lead time (days) | 30 |
| Reference date | 2026-11-22 |
Expected result: As of 22 November 2026 old-portal expired 52 days ago; vpn (8 days) and www (18 days) are in the 30-day renewal window; mail in 113 days.
Sorting starts with the most urgent. The ICS file contains two all-day events per certificate: a renewal reminder (today if the window has already started) and the expiry day. No events are created for expired certificates.
Second scenario
| Input | Value |
|---|---|
| Certificate list (CSV) | |
| Renewal lead time (days) | 60 |
| Reference date | 2026-11-22 |
Expected result: Semicolon list with DD.MM.YYYY dates: with a 60-day window RADIUS (23 days) must be renewed; the wildcard in 70 days.
Method and assumptions
Days left = expiry − reference date (UTC days). Status: < 0 expired, ≤ lead time due, otherwise fine. ICS: RFC 5545 all-day events with stable UIDs so re-imports do not duplicate.
Using the result and troubleshooting
Import the ICS into the team calendar and update the list with every new certificate. For auto-renewed (ACME) certificates, verify that renewal actually works.
Limits and common mistakes
- Certificates are not read remotely; accuracy depends on the input. Time zone differences are ignored in day counts.
Frequently asked questions
Will events duplicate when the ICS is imported again?
Each event's UID is derived from the certificate name and expiry date, so most calendars update rather than duplicate it.
Related tools and service
- PEM Certificate DecoderDecodes the PEM certificate you paste in your browser only; it does not connect to any server.
Related service: Web Application Security and WAF