Free permit register template for energy projects

One row per permit or approval, with the law behind it, the event that starts the clock, the deadline and the person who owns it. In Excel and CSV, in English, Greek, Italian and German. Free to use and adapt, with no sign-up.

permit-register-template.xlsx
Permit or approvalDeadlineDays left
Environmental permit · renewal2027-05-24214
Connection offer · validity2027-01-0676
Building permit · start of works2026-11-1221
Days left
amber under 90 daysred under 30

Illustrative rows, not a real project.

Download

The template in four languages

The Excel file works out the days left to each deadline, colours the ones that are close and offers the status as a list. The CSV holds the same columns for any other tool.

The columns

What each column is for

The first row of each file is an example in square brackets. Overwrite it with your first permit.

ColumnWhat goes in it
ProjectThe project the permit belongs to, so one register can hold a whole portfolio.
Permit or approvalThe permit, licence, opinion or approval, named the way the authority names it.
AuthorityThe body that issues it, and the office that handles the file.
Legal basis (law and article)The law and article that require it and set its deadline. Without them, nobody can check the deadline later.
Event that starts the clockWhat starts the deadline: a filing, a notification, the date a decision takes effect.
Start dateThe date of that event.
DeadlineThe last day, worked out from the start date and the legal basis.
Days leftWorked out by the Excel file from the deadline: amber under 90 days, red under 30. Nothing to type.
OwnerOne person per row, who answers for the next step.
StatusChosen from a list: not started, in preparation, filed, granted, refused, expired.
Documents (link)A link to the application, the decision and the evidence, wherever they are kept.
Guarantee or contract tied to itThe letter of guarantee or contract that depends on this permit, so the two dates are read together.
NotesWhatever the next person needs to know.
Keeping it useful

Three habits that keep a register honest

  1. 01

    One register for the portfolio

    Keep every project in one file, so the next 90 days show across all of them.

  2. 02

    The legal basis on day one

    Fill in the law and article when you add the row, not when someone asks for them.

  3. 03

    A weekly look at the next 90 days

    Sort by days left every week and go through the first rows with their owners.

Beyond the spreadsheet

When a spreadsheet stops being enough

Several jurisdictions, a team instead of one owner, guarantees and contracts tied to permit dates, or lenders asking for evidence. Then the upkeep, not the tool, becomes the risk.

The law behind each requirement

Every requirement carries the article of law behind it, cited and clickable. Change one fact and the whole path re-derives.

Deadlines

Statutory clocks with their legal reference, on a rolling 90-day timeline with a live flag feed.

Guarantees and contracts

On the same record as the permits, with expiry alarms that reach the dashboard.

Compare MitOS and spreadsheets, task by task

Questions about the template

Is the template really free?

Yes. Download it, change it and share it. There is no sign-up and no email address to give.

Does it open in LibreOffice and Google Sheets?

Yes. The Excel file is a standard .xlsx, and the CSV opens in any spreadsheet or database tool.

Why a column for the event that starts the clock?

Because a deadline is only as right as its starting point. With the event and its date on the row, anyone can check the deadline again later.

What if the register outgrows the spreadsheet?

Bring a real project to the demo. We walk through how its permits, documents and dates would sit in MitOS, so the team can decide on its own data.

Bring a project to your demo

Choose a project and the issue you want to resolve. We will focus the walkthrough on the information your team needs to make its next decision.

Explore the workflows