An open point list template for Excel is a tracker for unresolved issues, decisions, actions, or defects: give each item an ID, description, owner, due date, priority, and status, then use filters to see what needs attention. You can build one in Microsoft Excel for Microsoft 365 by pasting the column headings below into a worksheet and formatting the range as a table.
What an open point list is for
An open point list records matters that still need a response or a completed action. Teams use similar lists during project meetings, construction handovers, product reviews, audits, event planning, and day-to-day operations. The term is not a universal formal standard, so teams may also call the same document an issue log, action tracker, punch list, or follow-up register.
The useful distinction is that the list is about follow-through, not simply meeting notes. A note such as “discussed access problem” is hard to act on. A trackable point says what the problem is, who will do what, and when the team expects an update or resolution. The list can then serve as a shared record between meetings.
Excel is suitable when a team needs a straightforward, editable register and does not require a dedicated workflow system. It provides sorting, filters, tables, and basic visual indicators without requiring specialist software. A spreadsheet does not, by itself, guarantee that people will update the information or receive notifications; those responsibilities need to be agreed.
Copyable Excel template columns
Start with a single worksheet named Open Points. Paste or enter these headings in row 1, in this order. Each row below the header represents one distinct open item.
| Column | What to record |
|---|---|
| ID | A short, unique reference such as OP-001 |
| Date raised | When the item was first recorded |
| Description | The issue, question, decision, or required action |
| Owner | The person responsible for the next step |
| Due date | The agreed target date for resolution or an update |
| Priority | For example, High, Medium, or Low |
| Status | Open, In progress, Waiting, or Closed |
| Closed date | The date the item was confirmed resolved |
| Days open | Optional calculated measure of elapsed time |
| Overdue? | Optional indicator based on the due date |
| Latest update / next action | The most recent progress note and immediate next step |
Keep the description specific enough that someone who missed the discussion can understand it. For example, “Confirm whether the supplier can deliver the revised cable by 12 November; Alex to contact the supplier” is more useful than “Cable issue.” Put the action in the update field if the description needs to remain a stable summary.
For a small team, these columns are usually enough. If the list has many workstreams, add a Project or Category column. If points need a location, add Area or Reference. Avoid adding fields just because they might someday be useful: every extra field takes time to maintain and can leave the sheet looking complete while important details remain outdated.
Set up the worksheet in Excel
- Open a blank workbook and enter the headings in row 1. Use one row per point, with no completely blank rows inside the list.
- Select the headings and the rows you have entered, then choose Insert > Table. Check that My table has headers is selected and confirm. In Excel for Microsoft 365 on Windows, Ctrl+T also opens the Create Table dialog; on Mac, Cmd+T is the common shortcut. The Insert menu is a reliable alternative.
- Give the table a clear name from the Table Design tab, such as OpenPoints. Table Design appears when a cell in the table is selected. Use a short name without spaces if you plan to refer to the table in formulas.
- Set the date columns to a date format. Select the relevant column and use Home > Number Format, choosing a date style that your team can read consistently. A real Excel date is preferable to typing dates as text, because sorting and date comparisons depend on Excel recognizing them as dates.
- Adjust column widths, wrap text in Description and Latest update / next action, and freeze the header if the list is long. On Windows, use View > Freeze Panes > Freeze Top Row. The View tab also provides Freeze Panes on Mac, though the ribbon layout can vary slightly by release.
Excel tables add filter buttons to the header row and extend formatting and calculated-column formulas when new rows are added. This makes a table easier to maintain than a range with manually applied colors. If you paste new data, check that it has entered the table and that date and status values have not been imported as unexpected text.
Choose clear statuses and priorities
A status should describe where work stands, not how important it is. Keep the two concepts separate: a high-priority point can be waiting on an external response, while a low-priority point can be in progress. A compact status set might be Open, In progress, Waiting, and Closed. Define what each means before several people start using the sheet.
- Open: recorded but work has not started.
- In progress: an owner is actively working on the next step.
- Waiting: progress depends on a named person, decision, delivery, or other dependency.
- Closed: the team has confirmed the point is resolved or no longer requires action.
For priorities, High, Medium, and Low are usually easier to apply consistently than a numeric scale with no explanation. Agree what High means—for example, a blocker to a key deliverable or a safety concern—rather than letting each contributor define it differently. If timing is the main concern, the due date and overdue view may be more useful than adding more priority levels.
To reduce spelling differences, select the Status cells and choose Data > Data Validation. In the validation dialog, set Allow to List and enter the permitted choices in Source, separated by commas, such as Open,In progress,Waiting,Closed. Repeat for Priority if appropriate. Data Validation is available in Excel for Microsoft 365 on Windows; the dialog and ribbon placement on Mac may differ slightly, but the Data tab includes Data Validation. A dropdown helps prevent variations such as “In progress,” “In Progress,” and “Progress” from becoming separate filter values.
Use formulas for aging and due dates
Formulas are optional. A team can manage a short list manually, but calculated fields make it quicker to spot aging or overdue work. The examples assume the headings above are in columns A through K: Date raised is in B, Due date in E, Status in G, Closed date in H, Days open in I, and Overdue? in J. Enter each formula in row 2, then fill it down or let the Excel table copy it into the calculated column.
With the date raised in B2 and the closed date in H2, enter this in I2 to calculate elapsed days, stopping at the close date when one is present:
=IF(B2="","",IF(H2="",TODAY()-B2,H2-B2))
For example, if B2 contains 1 November 2026, H2 is blank, and the computer date is 3 November 2026, the result is 2 days. TODAY updates when Excel recalculates, so an open item’s displayed age changes over time. A closed item’s age remains based on its recorded close date. Confirm that B2 and H2 contain actual dates, not text that merely looks like a date.
With the due date in E2 and status in G2, enter this in J2 to show whether an unclosed item is late:
=IF(OR(G2="Closed",E2=""),"",IF(E2<TODAY(),"Overdue","On track"))
This example treats an item due today as On track and only marks it Overdue after its due date has passed. It leaves the result blank for a closed item or a missing due date. If your team uses a different status label, change the text Closed in the formula to match it exactly. The displayed result depends on the computer date and Excel recalculation, so the formula is a prompt for review, not proof that a point has actually been resolved.
Filter, sort, and highlight work
Use the table’s header filters to show only Open or Waiting items, one owner’s work, a category, or a particular priority. Sorting Due date from oldest to newest brings the nearest deadlines into view. You can also filter the Overdue? column to show only overdue items. Clear filters when the team needs the full register; a filtered-out row is still in the table, but it may be overlooked by someone who does not notice the filter.
Conditional formatting can make important information easier to scan. Select the relevant cells or table column, then choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains and enter Overdue to apply a visual style to overdue results. Choose subtle, readable colors and retain the text labels: color alone is not accessible to every reader and may not print clearly. Avoid applying so many colors that the sheet becomes harder to interpret than the original list.
For a weekly review, filter Status to exclude Closed, sort by due date, and discuss the oldest or highest-priority items first. Update the owner, due date, status, and next action during the review. When an item is complete, record the closed date and change its status to Closed instead of deleting the row. Keeping resolved entries preserves a useful history and helps explain why a previous issue was considered finished.
Ownership, updates, and common problems
A list only works when people know who maintains it. One person can coordinate the register, while individual owners remain responsible for providing accurate updates. Set a regular review interval—such as at each project meeting—and agree who may change due dates or close items. For a shared workbook, store it in a location where intended collaborators can access the current version, and avoid circulating separate email copies that can quickly diverge.
Common problems are usually process problems rather than Excel problems. An item with no owner has no clear next step. A vague due date such as “soon” cannot be sorted or checked. A point with several unrelated actions may need to be split into separate rows, each with its own owner and deadline. Conversely, do not create a new row for every minor update to the same issue; use the update field to keep the current record readable.
Other pitfalls include closing items without confirming the outcome, leaving old filters on, and relying on color without a written status. If an item is waiting on someone else, name the dependency and decide when to follow up. If a due date changes, record the new agreement in the update field when the reason matters. These small conventions make the workbook a more trustworthy record than a sheet that merely contains many rows.
When Excel is enough—and when to use another tool
Excel is a reasonable choice for a modest list with a manageable number of contributors, simple statuses, and no need for automated reminders or approval flows. It is familiar, flexible, and useful when the team wants to analyze or export the data. A table can be filtered for a meeting or copied into a report without adopting a larger system.
A shared task-management or project platform may be a better fit when the team needs notifications, assignment workflows, file attachments, comment history, permissions, or dashboards that update automatically. A formal quality, safety, or construction process may also require specific records or approvals that a general spreadsheet does not provide. Choose a tool based on the work’s actual controls and collaboration needs; do not assume that a spreadsheet’s presence alone satisfies a formal recordkeeping requirement.
If the list remains in Excel, protect it from accidental changes sensibly: keep a backup or use the workbook’s version history where available, limit editing access where appropriate, and make a copy before major structural changes. Protection features can prevent some edits, but they are not a substitute for access controls or a reliable backup.
Frequently Asked Questions
What should an open point list include?
A useful minimum is an ID, description, owner, due date, status, and latest update or next action. Add date raised and priority when they help the team monitor aging and decide what to handle first.
Is an open point list the same as an action log?
They often overlap. An action log usually emphasizes assigned tasks and follow-up, while an open point list may also include unresolved questions, defects, risks, or decisions. Teams define the terms differently, so agree on what belongs in the register.
How do I make a status dropdown in Excel?
Select the Status cells and choose Data > Data Validation. Set Allow to List and provide the allowed status values in Source. Use the same spelling in the dropdown, formulas, and any reports that depend on status.
Should closed points be deleted?
Usually, keep them and mark them Closed with a close date. Retaining resolved points preserves context and helps the team review completed work. Filter them out during routine follow-up if they clutter the active view.
Can multiple people update an Excel open point list?
Yes, if the workbook is shared through a location that supports collaboration and contributors have access. Agree who owns updates, avoid maintaining disconnected copies, and check the workbook’s sharing and version-history options for your Microsoft 365 setup.
What is the difference between a punch list and an open point list?
A punch list commonly refers to defects or unfinished work identified before a project handover, especially in construction. Open point list is broader and can cover actions, questions, and dependencies across many types of work. Their exact scope depends on the team.
Related
- Microsoft Excel Project Timeline Template: How to Build One
- Microsoft Excel Protected Sheets: Setup, Limits & Fixes
- Microsoft Excel Quick Repair: Steps and What It Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Calculate Age in Excel From Two Dates: Exact YearsTo calculate someone’s age in completed years from a birth date and a second date, enter the birth…
- How to Join Two Columns in Google Sheets With a FormulaTo join two columns in Google Sheets, enter a formula such as =A2&" "&B2 in an empty column,…
- Excel Military Time: Convert and Format ItIn Excel, convert a four-digit military-time entry stored as text in A2 into a real time with =TIME(VALUE(LEFT(A2,2)),VALUE(RIGHT(A2,2)),0).…
- Excel Won’t Group Columns? Causes and FixesIf Excel will not group columns, select the column headers you want to fold, then choose Data >…
- How to Edit a Filter in Google Sheets Without Losing DataTo edit a filter in Google Sheets, click the filter icon in the column header, change the selected…
- Excel Text Upside Down: What Works and What Doesn’tIn Excel for Microsoft 365 on Windows, you cannot rotate text inside a worksheet cell a full 180…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.