Skip Navigation

Spreadsheet

Structured Interview Scorecard & Question Bank — Candidate Evaluation Template for Excel & Google Sheets

A structured interview scorecard for Excel & Google Sheets — score every candidate on the same competencies, auto-rank your slate, plus 100+ questions.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Rate each candidate 1–5 on eight weighted competencies — the weighted score, percentage, rank, and recommendation compute automatically
  • Compare your whole slate side by side, auto-ranked, with a Strong Yes / Yes / Maybe / No recommendation for each
  • 100+ interview questions by competency, each with what a strong answer shows and a follow-up probe
  • Fair & legal interviewing guidance — what to avoid and the job-related question to ask instead
  • One owned file — Excel, Google Sheets & LibreOffice, no per-seat fees

Hire on evidence, not a gut feeling

Most small teams interview the way they always have: a friendly chat, a gut feeling, a quick huddle afterward. It feels efficient, and it’s widely considered one of the least reliable ways to hire. This structured-interview kit fixes it without turning hiring into a bureaucracy — a competency-based scorecard that rates every candidate against the same criteria, plus a bank of over 100 interview questions organized by competency.

Ask every candidate the same job-related questions, score the answers on the same 1–5 scale, and compare like-for-like. You interview consistently, decide on evidence you can point to, and keep a defensible record of why each hire was made.

Score every candidate the same way

The Candidate Scorecard is the heart of the kit. Rate each candidate 1–5 on eight weighted competencies and the workbook does the rest:

  • A weighted score and percentage — each rating counts by its competency’s weight, so what matters most counts most
  • An automatic rank across your whole slate
  • A clear recommendation for every candidate — Strong Yes, Yes, Maybe, or No — from the same thresholds every time

No more comparing a shortlist from memory. The ranking falls out of the scores, and every recommendation traces back to ratings you can point to.

A 100+ question bank, ready to use

The Question Bank gives you over 100 behavioral and situational interview questions organized by the competency each one is built to reveal. Every question is paired with what a strong answer actually shows and a follow-up probe to push past a rehearsed reply. Pick two or three per competency, ask the same ones of every candidate, and you’re ready.

Structured interviewing is fairer by design — everyone gets the same job-related questions. The Fair & Legal Interviewing tab lists the topics to keep off the table and the job-related question to ask instead, plus the bias traps that quietly turn a structured interview unstructured. The Decision Log keeps a dated, audit-ready record of each hire.

What you get

  • A 7-tab workbook — Read Me, Scoring Guide, Competencies, Candidate Scorecard, Question Bank, Fair & Legal Interviewing, and Decision Log
  • A one-click Google Sheets copy — a ready-made native version, no importing
  • Four PDF guides — a Start Here method guide, a scoring guide with a worked five-candidate example, a printable question bank, and a printable per-candidate scorecard with a fair-hiring quick card
  • A pre-loaded worked example you overwrite with your own candidates

Works in Excel, Google Sheets, and LibreOffice. Edit the competencies and weights to fit any role — the scorecard follows.

Own it, don’t rent it

This is a file you own outright — no per-seat fees, no monthly subscription, no vendor holding your hiring data. It sits right where you need it: more than a blank spreadsheet or a free template, without the overkill of a full applicant-tracking suite built for a company ten times your size. Buy once, reuse it for every role you hire for.

Try it first: the free single-role interview scorecard shows the like-for-like scoring on one candidate before you get the full kit.

A hiring decision aid and record-keeping template — not HR, legal, or professional advice, and not a guarantee of a good hire or a lawful process. The fair-hiring guidance is general good practice; rules vary by locality, so check with your own counsel. The example role and candidates are fictional. A score is a decision aid, not a verdict.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 7-tab workbook (.xlsx): Read Me, Scoring Guide, Competencies, Candidate Scorecard, Question Bank, Fair & Legal Interviewing, Decision Log
  • One-click Google Sheets copy — a ready-made native version, no import needed
  • Start Here method guide (PDF)
  • Scoring Guide & Worked Example guide (PDF)
  • Interview Question Bank (PDF)
  • Printable Scorecard & Fair-Hiring Card (PDF)
  • Pre-loaded worked example you overwrite with your own candidates

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$24.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.