Issue Tracking Template

Track project issues as they arise with this Excel template. Define priority of each issue, assign to key people on the team and check off when complete. Issues are problems and with this issue tracking template you have the means to solve those problems.

Download Now

✅ Great! Please check your email for your download link.

Just enter your business email below and we’ll email you the link to the download:

Why You Need Better Issue Tracking

When you’re talking about an issue in project management, you really mean a problem, but specifically a problem that is related to a project. This problem may be about to happen or is currently happening, but it must be resolved as quickly as possible or else risk the whole project.

An issue, however, is different from a risk in a project. A risk basically is something that hasn’t occurred but may disrupt the project. An issue is imminent or occurring. It’s a somewhat subtle distinction, but one that demands attention. That’s why our free Excel issue tracking template is a great start to corralling and correcting issues as they arise in a project.

Related: Project Reporting Tools

Once you download and create your own issue tracking template you can collect those issues. First you have to identify them, of course, and the template is where they go. Only after having identified them can you begin to create some plan of action. Use your project team to brainstorm ideas. Collaboration is a great tool for tackling a problem as it gives you many different perspectives and comes from experience and skills you may not have.

How you address the issue is as open-ended as how many issues may arise in a project, which is more reason you need a place to collect these ideas. The issue tracking template makes sure that everything you do is clearly documented.

How that action is going to resolve the issue could be a change of scope or requirements, but whatever that may be you’ll need to define it, negotiate it and have it approved. Then you can add it to your template.

You’ll want to implement that action quickly, and the risk tracking template allows you to do so systematically and clearly. The template is great, too, for multiple issues and keeping them all straight. You’re likely to have more than one issue in a project, so you need a document to keep track of one and all.

How to Use’s Issue Tracking Template

Once you’ve got your free Excel template and have downloaded it, you’ll want to create one to suit whatever issues you’re having on your project. The first step is filling in the blank fields with the pertinent information.

Describe Issue and Determine Status

issue description and status in log
This is where you list your issues, so you’ll want to number them first to keep them from getting confused. Then there’s a column in which you can note the status of the issue. Is is done, in progress, open, blocked, etc.? Of course, you’ll need to describe the issue, and be precise but not wordy.

What’s the Category, Priority and Who’s the Issue Assigned to?

project issue log with category and issue priority level
Depending on the issue, the category is going to be different from issue to issue. For example, the issue may be with a vendor or a website build. Whatever it is, here’s the place to put it. Then you’re going to need to prioritize. Is it high, medium or low priority? Note that. Then, assign the issue to someone to oversee its path towards being resolved. If you don’t, the issue will undoubtedly be lost in the shuffle.

Who Raised It, When Was It Opened/Closed and Comments

issue tracking in project management
It’s good to note who raised the issue. That may help resolve it. There a good person to go back to, even if they’re not the one who will own the issue. That’s why you want to write it down here. The date the issues is opened and closed is also helpful when tracking, so there are columns for both. Finally, you’ll have a column in which to add comments that don’t fall under any of the already assigned columns.

Issue tracking works best when it’s part of the whole project management solution. By pulling in team members to not only raised the issue, but will lead the task to resolve them, you’re making it more likely that the issue will not fall through the cracks. When this part of your project tracking solution is part of a larger project management software tool, then you’re managing issues, rather than have the issues drive your management of the project.

How to Import an Issue Tracking Template

To import your issues template into go to the Gantt View of a project, which features seamless import and export with MS Project, Excel, and CSV format.

  • Simply click the import button in the ribbon menu above the Gantt chart
  • Add the file you wish to import and click “Import”.
  • Map the columns you want to import on the Import Tasks mapping popup.
  • Remember to exclude the header row if you have one by selecting Yes or No to the question at the bottom.
  • Click “Import” to import your tasks into a project.

How to Use Issue Tracking Templates in

Tag and Track Issues

Individual tasks can have a tag to help provide more context. For example, people can tag a task with a marker label like “Issue.” This gives managers and teams more flexibility when controlling issues as they arise. Since you can filter by tags, as well, it also supports the ability to let teams define issues and filter all tasks with the tag issues to see just those.

Make Issues a Separate Project

If you’d prefer to pull out the issues as a separate project, you can do that by keeping the imported template as its own project. Now you can view the issues distinct from the larger project, which makes it easier to track and resolve them. They can be viewed as a kanban board, with each task its own card, or in the Gantt or list view. 

issue logging & tracking in's online software

Assign Issues and Track Progress

Issues must be assigned to someone on the team who owns them, which means they’re tasked to resolve them. A priority level for each issue can be created, along with a deadline. Then, track their progress on the issue with our project dashboard, which collects data in real time. The dashboard also gives you the functionality to filter data to see only what you need.

Related Content

Issues are problems, but that’s merely a quick and easy why to describe them. There’s much more about managing and tracking issues, and if you want to take a deep dive into the topic, then there’s no better place than the blog. To get you started, we’ve selected the top three articles and tutorial videos on the subject, which are listed below.

Now that you’ve downloaded your free Excel issue template, you’ve created one to use for your project and you’ve seen how these documents are critical pieces of project management, are you ready to take the next step? A standalone, static template is helpful, but it can be so much more useful, efficient and productive when part of a suite of project management software tools. is a cloud-based, online software that offers project managers and their teams the tools they need to work together and get the project completed faster, better and cheaper. Not only does it have features to track issues, but there’s so much more. From planning, monitoring and reporting on the project, sees you through every phase in the project’s lifecycle.

Our award-winning software has been rated #1 by Gartner’s GetApp in its project management app category, which is collected by actual users of the software. Why not see for yourself what can do for you and your team by taking this free 30-day trial.

Related Posts

Deliver Your Projects
On Time and Under Budget

Start planning your projects.

Start 30-Day Free Trial