Board of Directors Spreadsheet Template

What a board of directors spreadsheet tracks

A bank’s compliance team asks for your current board and officers, with proof of when each was appointed. You know the names — the dates, resolutions, and signing authority live in someone’s inbox, not in one place. This board of directors spreadsheet template — a board register — turns that scatter into one standing record of who governs an entity.

It captures directors, officers, and committee members, along with the appointments, terms, meetings, and decisions that prove they hold authority. It’s what you produce when a bank, auditor, or acquirer’s counsel asks who’s authorized to act for this company — and whether you can prove it.

It comes up more often than founders expect — opening a bank account, closing a financing round, responding to a subpoena, or renewing a D&O policy. Each moment asks for the same facts: current directors and officers, their terms, and the resolutions that put them in place.

Most teams assemble those facts from disconnected emails, PDFs, and memory. A board register exists so that work is already done.

Directors, officers, and committees

A board register tracks governance at three layers, and conflating them is where most homegrown trackers go wrong. Directors sit on the board itself and hold fiduciary duties to the entity as a whole.

Officers — CEO, CFO, Secretary, and similar roles — run day-to-day operations under authority the board delegates to them. One person can hold both roles at once. Committees are board subgroups — Audit, Compensation, Nominating — with their own membership and meetings, distinct from the full board.

Each layer needs its own appointment history. A director’s board term and an officer’s title term don’t run on the same clock. A committee assignment can start or end independently of either.

The Board Members sheet is the roster: one row per person, with title, member type, and term dates already there. It doesn’t ship with email or phone columns. The workbook’s column conventions let you add your own — a contact column or two — without disturbing the structure the rest of the workbook depends on.

Register versus minute book

A board register and a minute book answer different questions. A corporate minute book stores minutes of what happened at a meeting — the discussion, in narrative form.

A board register stores the state that meeting produced instead — who was appointed, what was resolved. When outside counsel asks who held a title on a given date, the register answers directly. A minute book means rereading a decade of narrative to find the same fact.

Neither is a state filing. A resolution appointing an officer is an internal governance act, while a state filing naming that officer is a separate, external record.

Some actions require that filing; others don’t, and the resolution always comes first. The distinction matters enough to cover in detail below.

What’s inside the workbook

This board of directors spreadsheet template ships as one Excel workbook with 19 visible worksheets — a Start Here guide plus 18 data sheets. A hidden Options sheet powers 23 dropdown lists, so board type, meeting type, resolution type, and the rest stay consistent from row to row.

Start Here walks through column conventions and three habits that keep the file usable a year from now. Keep the header row intact, use one record per row, and add new rows rather than rearranging existing ones.

The 18 data sheets, in the order they appear:

• Boards
• Board Members
• Board Appointments
• Board Meetings
• Board Meeting Attendees
• Board Resolutions
• Board Consents
• Committees
• Committee Members
• Committee Appointments
• Committee Meetings
• Committee Meeting Attendees
• Committee Resolutions
• Officers
• Officer Appointments
• Corporate Seals
• Seal Usage Log
• D&O Questionnaires

Boards, members, and appointments

Boards, Board Members, and Board Appointments form the core chain. A Board row defines the governance body — type, quorum requirement, meeting frequency. A Board Member row links a person to that board with a title, and a Board Appointment row logs each term that person served.

Officers and Officer Appointments mirror the same structure for corporate officers. Splitting the person from the term keeps one clean member row while a director’s second or third term stacks up underneath it. Term expiration dates drive succession planning — a lapsed appointment sitting unnoticed is a governance gap, not a paperwork one.

Committees, charters, and seals

Committees, Committee Members, and Committee Appointments repeat the board pattern one level down. Each committee reports to a board, and the workbook tracks its membership and terms the same way it tracks board membership.

Corporate Seals and Seal Usage Log cover a narrower need: which seals the entity holds, who has custody, and when each gets affixed. That usage log is the custody audit trail a lender or counterparty asks for when a sealed document’s authenticity is in question.

Meetings, resolutions, and consents

Board Meetings and Committee Meetings, each paired with an Attendees sheet, exist to prove quorum. That means showing not just that a meeting happened, but that enough voting members were present for its decisions to count. A resolution passed without quorum is vulnerable to challenge later, by anyone with standing to contest it.

Board Resolutions and Committee Resolutions form the board resolution tracker template at the center of the workbook. Together they record what was decided, distinguishing ordinary business from special resolutions and unanimous consents.

Board Consents captures written consents in lieu of a meeting — a distinct decision path covered in more detail below. D&O Questionnaires rounds out the sheet set, tracking each director’s and officer’s annual disclosure status against the proxy deadline it’s due by.

Building and using it in Excel

A corporate secretary building a board of directors tracking spreadsheet from scratch usually follows the same sequence.

Set up boards and members

Start in Boards, adding one row per governance body. Then populate Board Members and Officers — one person, one row, even if that person holds more than one role.

Resist the urge to combine a director-and-officer into a single row with a combined title. The two roles have separate terms and separate appointment history.

Track appointments and terms

Log each appointment in Board Appointments or Officer Appointments with a start date and, once it ends, an end date. Sort either sheet by end date and expiring terms rise to the top.

That’s the mechanism most organizations use to catch a lapsing directorship before it lapses. The same discipline applies to D&O Questionnaires: update status as responses come in, checked against the proxy deadline rather than the deadline itself.

Prove quorum, record consents

Add a row per attendee in Board Meeting Attendees or Committee Meeting Attendees every time a meeting is held. That attendee list, not a note in the minutes, is what evidences quorum later. Use this sheet as a board meeting tracker in Excel — filter and sort by date or attendee in seconds.

When the board acts without convening, use Board Consents instead. A written consent in lieu of a meeting is a fully valid way to pass a resolution. It belongs in its own sheet rather than being forced into the Meetings row structure.

Whichever path a decision takes, never delete a superseded appointment or resolution row. End-date it and add the new one instead. The register still shows what used to be true.

Or skip the setup — the template above has all of this built in.

Board of directors spreadsheet vs. minute book

An auditor’s document request usually breaks into three separate questions: who governs, what was decided, and who owns what. Reaching for the wrong document wastes the time this template is meant to save.

This board register template records meeting outcomes and attendance — who was appointed, what was resolved, who was present. It pairs with, rather than replaces, a separate agenda or minutes template that captures the discussion itself.

A board resolution and the filing it sometimes triggers are easy to conflate. A resolution is the board’s own authorization — appointing an officer, approving a transaction, amending a bylaw. Any resulting state filing is a separate record, made by a different authority, that follows the resolution rather than replacing it.

When a spreadsheet stops scaling

A board of directors spreadsheet template like this one handles most organizations well for a long stretch. Where it strains is specific and predictable: there’s no point-in-time view. Answering “who sat on the audit committee on March 31” means checking dates by hand across several sheets, because a spreadsheet only shows current state.

Nothing fires automatically when a term nears expiration or a D&O questionnaire deadline approaches, so someone has to remember to check. Once an appointment or resolution row gets overwritten instead of superseded, its prior state is gone — no version history recovers it. Multi-entity organizations feel a fourth strain: nothing stops someone from editing another entity’s rows, or separates who can see one entity’s record from another’s.

None of that means the spreadsheet was the wrong starting point — it means recognizing when its job is done. This workbook’s column headers match Lextree’s CSV import templates, so it imports directly into board governance record keeping software — no re-keying, no remapping. From there, appointments, resolutions, and consents live in the Board Governance module with real version history and term-expiration reminders. Access control is scoped to each entity.

Frequently asked questions

What should a board of directors register include? A board register covers every board and committee, who serves on each with title and term dates, and every meeting held with attendance for quorum. It also tracks resolutions and written consents, officer appointments, and D&O questionnaire status.

How do I track board of directors and officers in Excel? Seed Boards, Board Members, and Officers first — one person, one row. Then log appointment start and end dates in the child sheets, and sort by end date to surface expiring terms. Record meetings and resolutions as they happen.

How do I keep a board register up to date? Update it the moment something changes — a new appointment, a meeting held, a resolution passed. Don’t wait for a fixed schedule. Add a new row for each event instead of overwriting the last one.

What is the difference between a board resolution and a filing? A resolution is the board’s internal authorization to take an action. A state filing is a separate, external record — required for some resolutions (like an amendment) and not others. The resolution always comes first.

Can I track board committees and their members in the template? Yes. Committees, Committee Members, and Committee Appointments are separate worksheets linked back to the board each committee reports to. The workbook tracks each committee’s meetings and resolutions alongside them.

Is a written consent the same as a board meeting? No. A written consent (tracked in Board Consents) is a decision made without convening a meeting — every director signs instead of voting in session. Both are valid ways to pass a resolution; the template tracks them separately.

Does the template work in Google Sheets? Yes — upload or open it in Google Sheets and the column layout and dropdown lists carry over. The file is built and tested in Excel, so that’s where it works best, but Google Sheets is a fine place to use it too.

Does this work for a nonprofit board of directors? Yes. Board type supports Directors, Advisory, and Supervisory boards, and the Committees sheet covers Audit, Governance, and other committees common to nonprofit governance. The same structure works for corporations, nonprofits, and LLCs with formal boards.

Is the template really free? Yes. Enter your email below and the workbook is sent immediately — no credit card, no sales call.