Free Student Communication Preference Register Excel Template 2026
Free 2026 Excel template for tracking student communication preferences, contact status, approved channels, review dates, record errors, and follow-up.
Direct download · XLSX checked with LibreOffice Calc
This free Excel template helps teams manage student communication preference register. This free Student Communication Preference Register Excel template for 2026 helps course operations teams maintain one current communication preference record per student reference ID. Record student contact status, preferred and backup communication channels, channel-specific use settings, contact timing, language, ownership, source, and important dates.
Built-in calculations identify upcoming or overdue reviews, data-quality errors, and records needing attention, while the Dashboard summarizes the information entered in the register.
Preview 1 — “Dashboard” sheet Click to enlarge
In practice
What this template helps you manage
✓
Keep student communication preferences in a structured register with one current row per student reference ID.
✓
Distinguish among Contact Allowed, Temporary Hold, and Do Not Contact before choosing a communication channel.
✓
Record a preferred channel, an optional backup channel, and separate use settings for Email, Text Message, Phone Call, and Portal Mail.
✓
Standardize entries with dropdown lists for programs, enrollment statuses, contact statuses, channels, contact windows, time zones, languages, preference sources, and staff owners.
How to use it
How to use the workbook
Start on the Instructions sheet, then open the Preference Register and search for the student reference ID before entering another row. Maintain one current row per student reference ID and set Overall Contact Status first. When contact is allowed, select one Preferred Channel and mark that same channel as Preferred in its corresponding channel-use field. If appropriate, select a different Backup Channel and mark it as Allowed. Complete the required student, program, language, date, source, and owner fields, adding an Operational Note only when needed. Review the calculated Next Review Date, Review Status, Record Check, and Attention Flag; resolve every Record Check error before relying on the row and review every record flagged Yes. Use the Dashboard for summary monitoring. Update Review Interval Days or Due Soon Window Days on Lists & Settings only when the operating schedule needs to change.
Preview 2 — “Preference Register” sheet Click to enlarge
Inside the file
Included features and controls
＋Four worksheets named Dashboard, Preference Register, Lists & Settings, and Instructions.
＋An Excel table named tblPreferences spanning A4:Y154, with 150 prepared rows from row 5 through row 154.
＋A small set of populated sample records demonstrating the register structure; the remaining prepared rows support operational entry.
＋Twenty-one user-entry fields covering student identification, program and enrollment details, contact status, channels, timing, language, preference source, staff ownership, notes, and dates.
Maintain a Structured Student Communication Preference Register
The Preference Register stores one current record per student reference ID in a prepared Excel table. Staff can capture Student Display Name, Program, Cohort, Enrollment Status, Overall Contact Status, Preferred Channel, Backup Channel, Best Contact Window, Time Zone, Preferred Language, Preference Source, Staff Owner, and key dates. An optional Operational Note accepts up to 200 characters. Populated examples illustrate the layout, while the prepared rows provide space for operational records.
Preview 3 — “Lists & Settings” sheet Click to enlarge
Document Permissions for Each Communication Channel
Overall Contact Status distinguishes Contact Allowed, Temporary Hold, and Do Not Contact. Separate fields for Email Use, Text Message Use, Phone Call Use, and Portal Mail Use can be set to Preferred, Allowed, Do Not Use, or Not Available. The Instructions sheet directs staff to choose one preferred channel when contact is allowed, mark that same channel as Preferred, and optionally choose a different backup channel marked Allowed. The register should be consulted before selecting a channel, but Contact Allowed does not replace staff judgment or organizational policy.
Monitor Review Dates, Errors, and Attention Flags
Next Review Date is calculated from Last Confirmed Date plus Review Interval Days. Review Status then classifies each populated record as Current, Due Soon, Overdue, or Not Scheduled by comparing that date with today and the configured due-soon window. Record Check identifies data-quality problems, including missing required fields, duplicate student reference IDs, and future dates. Attention Flag returns Yes when a record has an error, is Due Soon or Overdue, or has a Temporary Hold or Do Not Contact status.
Preview 4 — “Instructions” sheet Click to enlarge
Use the Dashboard for Course Operations Oversight
The Dashboard displays the current date, configured review interval, and due-soon window. Summary metrics cover registered students, active enrollment, Contact Allowed, Do Not Contact, overdue reviews, reviews due soon, record errors, and records needing attention. Additional summaries count Contact Allowed records by preferred channel and group records by review status. Two charts visualize the preferred-channel and review-status results entered in the register.
Common questions
About this template
The Preference Register contains 150 prepared operational rows, covering rows 5 through 154 beneath the headers in row 4. A small number of rows contain populated sample records that demonstrate how the fields work; those samples should not be treated as live student data.
The configured channels are Email, Text Message, Phone Call, and Portal Mail. The register includes Preferred Channel and Backup Channel fields, plus a separate use field for each channel. Channel use can be recorded as Preferred, Allowed, Do Not Use, or Not Available.
Next Review Date is calculated by adding Review Interval Days to Last Confirmed Date. The default interval is 180 days and can be set to a whole number from 30 to 730 on Lists & Settings. Review Status uses the calculated date, today's date, and the due-soon window to return Current, Due Soon, Overdue, or Not Scheduled.
Attention Flag returns Yes when Record Check is not OK, Review Status is Due Soon or Overdue, or Overall Contact Status is Temporary Hold or Do Not Contact. Otherwise, it returns No. Staff should review every record marked Yes before relying on it for outreach decisions.
The workbook includes dropdown lists for standardized categories, text-length limits, Student Reference ID format validation, and date rules. Preference Effective Date, Last Confirmed Date, and Last Updated Date accept valid dates from January 1, 2020 through today. Record Check also evaluates required fields and conditions including duplicate IDs and future dates.
No. The workbook records, calculates, and summarizes student communication preferences, but it does not send email, text messages, phone calls, or portal mail and does not enforce restrictions in external systems. Staff must consult the register and apply organizational policy and professional judgment before communicating with a student.
Editorial process
Prepared and reviewed against the workbook
Course Ops Workbook Team
Workbook preparation
This functional byline identifies the team role that structures the workbook, sample data, calculations, and operating checks.
Course Ops Editorial Team
Editorial review
This functional byline identifies the team role that checks the page against the generated workbook and states its limits.
