Skip to content
The title slide and first slides of the Issue Log template

Issue Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Style
Modern
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

The Issue Log is for teams who need a clear record of problems as they come up and how each was settled. The Issues tab holds one row per issue, with its area, priority, owner and status. Days open counts up until an issue is resolved. The Dashboard shows open issues by priority and by area, so urgent work is easy to spot.

It comes with sample data for a small office team. Make a copy and replace the sample rows. The formulas, dropdowns and charts update on their own.

Useful for

  • Logging operational problems in an office or workshop
  • Tracking software faults raised by staff
  • Reviewing unresolved issues at a weekly team meeting

What's included

  • 3 tabs: Dashboard, Issues, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Issues: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Issues tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Issue Log template free?

Yes. Make a copy in Google Sheets or download the .xlsx file for Excel. There is no charge for the template.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel. The formulas, dropdowns and charts work there as well as in Google Sheets.

How does the days open count work?

Days open is the number of days from the raised date to today while an issue is open. When you enter a resolved date, the count stops at that date.

  • #risk-register
  • #issue-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Project management

All project management templates
Get this template

Preparing your template…