When a client says they barely sleep, it can mean four hours or six, lying awake at 2 am or waking for good at 4. With two weeks in a sleep diary, you have the numbers instead. This sleep diary template records the night in the order of the Consensus Sleep Diary, the standard form in sleep research. From it you can work out how long a client spends in bed, how long they sleep, and their sleep efficiency.
Each morning the client fills in a few rows about the night before, and at bedtime a few about the day, such as naps, caffeine, alcohol, exercise and sleep medicine. At the next session, you and the client can turn each night into hours and a percentage on the summary page, or type the two weeks into the Excel version and let its formulas do the sums.
Sleep Diary Template: Two Weeks, Sleep Efficiency
At a glance
- When to use: two weeks before CBT for insomnia (CBT-I) starts, then every week of treatment; or whenever sleep comes up in therapy for depression, anxiety or trauma
- Who fills it in: the client, within an hour of getting up and again before bed; you and the client work out the summary together
- Morning rows: into bed, tried to sleep, minutes to fall asleep, times woken, minutes awake, final waking, out of bed, sleep quality and how rested, in the Consensus Sleep Diary’s order
- Bedtime rows: work day or day off, naps, caffeine, alcohol, exercise, sleep medicine, daytime sleepiness and anything else
- Worked out: time in bed, time asleep and sleep efficiency for each night, with weekly averages
- Capacity: two weeks on paper, with the week number open to change for weeks 3 and 4; twelve weeks in Excel
- Format: fillable PDF with drop-downs, Word (.docx) and Excel (.xlsx), US Letter landscape
What’s in the Sleep Diary Template
Sleep efficiency, the share of time in bed spent asleep, is the number CBT-I uses to set time in bed. To work it out, you need when the client got into and out of bed and how long they slept in between. The template includes a page for each week, where each column is dated by the morning and holds the night before and then the day, and a summary page where each night becomes three numbers. Here’s what each part records and what you take from it.
| Part | What you take from it |
|---|---|
| Week 1 and Week 2, morning rows | When the client went to bed, fell asleep, woke and got up, and how the night felt |
| Week 1 and Week 2, bedtime rows | The day around each night: work or day off, naps, caffeine, alcohol, exercise, sleep medicine, sleepiness |
| Anything different about these two weeks | Travel, illness or a stressful week that explains a run of bad nights |
| Two-Week Summary | Time in bed, time asleep and sleep efficiency for every night, the week’s averages, patterns, a schedule and questions |
| Excel log | The same diary a row a day for twelve weeks, with every sum and a weekly chart |
How the Sleep Diary Template Works
The client fills in one column a day for two weeks. The morning rows describe the night just gone and the bedtime rows describe the day. A late coffee or a nap shows up in one column, and the night after it in the next. Pearlie Hatchett, a fictional hospital unit clerk who wakes around 5 most mornings and can’t get back to sleep, kept hers between two sessions. Here is each part with her two weeks filled in.
The Week Pages
Each week is one landscape page, seven days across. The header has room for the practice, the therapist, the client and the date of the next session, which tells the client when to bring it back.

- Week and dates. The week number is a field filled with 1, and the client can change it when they print the diary again for weeks 3 and 4. The client writes the date of the morning at the top of each column, from Tue 04/13 to Mon 04/19 in Pearlie’s first week.
- In the morning, about last night. Seven times and counts, then two ratings from drop-downs. On the morning of Thu 04/15, Pearlie wrote that on Wednesday night she went to bed at 9:30 pm, tried to sleep at 10:30, took about 80 minutes to fall asleep, woke 3 times for about an hour in all, woke for good at 4:45 and got up at 5:45. She rated the night very poor.
- At bedtime, about today. Work day or day off, naps, caffeine and alcohol with the time of the last, exercise, sleep medicine with its dose and time, how sleepy the client felt during the day, and anything else, such as mood or the hour before bed. On Wednesday, Pearlie had her third coffee at 3 pm and dozed on the couch for 40 minutes, hours before that very poor night.
Week 2 is the same page with a box for anything different about the two weeks. Pearlie noted the audit on her unit at work, which ran from Tuesday to Thursday of week 1.
The Two-Week Summary
At the next session, you and the client turn each night into three numbers and average them by week. Time in bed runs from getting into bed to getting out of bed. Time asleep runs from trying to sleep to the final waking, less the minutes it took to fall asleep and the minutes awake.

- Each night, worked out. Time in bed, time asleep and sleep efficiency for every night, then the week’s average, with the week’s average minutes to fall asleep and minutes awake below. Pearlie’s first week averaged 8.3 hours in bed and 5.2 hours asleep, a sleep efficiency of 63%. Her second came to 74%.
- What we noticed. Patterns from the bedtime rows, such as caffeine, naps, alcohol, days off and the hardest nights. Pearlie’s worst nights came after coffee past 2 pm and the couch nap.
- Sleep schedule until the next session. A bedtime and a rise time, if you set one, and the client’s questions for the next session. Pearlie’s reads into bed not before 11:45 pm and out of bed by 5:45 am, and she asks whether she can keep her Saturday lie-in.
The summary page also explains each sum in words the client can follow.
The Excel Sleep Log
The workbook keeps the same diary a row a day, for twelve weeks. Times go in as 10:15 pm or 22:15, and nights that run past midnight are handled for you.

- Worked-out columns. Time in bed, time asleep, sleep efficiency and the week number fill in from each row, and a blank night stays blank. Pearlie’s Sat 04/17 shows 10.3 hours in bed and 7.4 asleep, 72%.
The Weekly Summary sheet averages each week, counts the poor nights and the days with a nap or alcohol, and charts time in bed against time asleep week by week. It also has room for what you noticed, the schedule and the client’s questions.

How to Use It With a Client
- Fill in last night together. Doing one column in session shows the client what each row asks.
- Tell the client a best guess is fine. They don’t need to watch the clock at night, and they estimate the times the next morning.
- Agree on when to fill it in. Within an hour of getting up, and the bedtime rows before bed. A missed day stays blank.
- Work out the summary at the next session. Use the summary page or type the two weeks into Excel, and talk through what you both notice.
- Keep it going during treatment. Print the diary again with the next week numbers, or carry on in Excel, and compare each week with the two before treatment.
The Method Behind It
A panel of sleep experts published the Consensus Sleep Diary in 2012 to give research and clinics the same questions in the same order. This template asks those questions in plain words and adds the bedtime rows of its expanded version. It works out the measures the panel named, time in bed, time asleep and sleep efficiency. In CBT-I, the time in bed you agree with a client starts from their average time asleep. It then moves week by week with their sleep efficiency, an idea that goes back to Spielman’s sleep restriction therapy in 1987.
What It Can and Can’t Do
The diary shows how a client sleeps, as they remember it. It doesn’t diagnose insomnia or any other sleep disorder. The template includes the numbers and a place to write a schedule, and the schedule is yours to set. A filled diary records a client’s nights, medicines and drinking. Keep it with their other records, as you would a session note. If a client is in crisis, they can call or text 988, or call 911 in an emergency.
Make It Yours
- For CBT-I, use the summary page each session and write the new bedtime and rise time under Sleep schedule.
- For a client who works nights, read the morning rows as the time they wake for the day, and keep a note of the shift in the bedtime rows.
- For mood work, pair it with the Bipolar Mood Chart or a Morning Routine Worksheet when mornings are the hard part.
- In the PDF, type your practice’s own name for the diary over the title, and your details in the header.
Frequently Asked Questions
Two weeks before treatment is the usual baseline, and in CBT-I clients keep it every day through treatment. The template includes two weeks on paper, with a week number the client can change, and twelve weeks in Excel.
A best guess is fine. The Consensus Sleep Diary asks clients not to watch the clock and to give their best estimate, within an hour of getting out of bed.
Divide the time asleep by the time in bed and multiply by 100. Seven hours asleep in eight hours in bed is 88%. The summary page and the Excel log both do it night by night.
In CBT-I, a week at 85% or more is usually good enough to add time in bed, and some clinicians wait for 90%. In the VA’s CBT-I protocol, a week at 85% or more means 15 more minutes in bed, and a week under 80% means 15 fewer. Those are treatment steps you decide with the client; the diary shows the number.
Yes. The bedtime rows record how many naps and how many minutes in all, including dozing off by accident, because a nap late in the day can show in that night’s sleep.
Sources
- Carney, C. E., et al. (2012). The Consensus Sleep Diary: Standardizing Prospective Sleep Self-Monitoring. SLEEP, 35(2), 287-302
- Sleep Diary. American Academy of Sleep Medicine, Sleep Education
- Reed, D. L., and Sacco, W. P. (2016). Measuring Sleep Efficiency: What Should the Denominator Be? Journal of Clinical Sleep Medicine
- Implementation of Brief Insomnia Treatments (NCT02724800), protocol. U.S. Department of Veterans Affairs
- CBT for Insomnia, part 3. University of Washington PACC
- Spielman, A. J., Saskin, P., and Thorpy, M. J. (1987). Treatment of Chronic Insomnia by Restriction of Time in Bed. Sleep, 10(1), 45-56
- 988 Suicide and Crisis Lifeline


