The Compact Calendar

"Compact Calendar" The Compact Calendar helps you plan up to an entire year on a single sheet of paper! Useful for project estimating, vacation planning, family activity scheduling, visualizing recurring events, and more.

  • Download the pre-made PDF packages for quick printing!
  • Make a custom calendar for ANY starting date and year (Microsoft Excel or Numbers is required)

Download the package you want in the sidebar on the right of the page.

About the Compact Calendar

Compact Calendar Example The Compact Calendar presents days as a continuous candy bar of time. Because the weeks are presented as a stack of available time, it’s easy to block out days naturally as you think. There’s a lot of free space available on the right-side of the sheet for note taking.

If you download the Excel version, you can easily change the starting date to generate a new calendar for any year you need. You can add your own holidays, too.

The download comes as a ZIP archive containing three Excel 2007 templates and six PDF versions, for all three week styles in both A4 and US Letter sizes. Optionally, you can download just the PDFs in either A4 or US Letter sizes.

The week styles are:

  • Week starting on Monday – your business working calendar, with ISO 8601 week numbers.
  • Week starting on Sunday – your typical home calendar week.
  • Week starting on Saturday – for countries that start the week on Saturday

While the Excel templates include US holidays, it’s pretty easy to customize them for any country.

TIP: If you’d like to know more about the design and use of the calendar, the page Using the Compact Calendar will give you the additional details.

Modifying the Compact Calendar

You’ll need Microsoft Excel 2007 or better to modify the Compact Calendar’s XLTX files. If you are using an older version of Office on Windows, this downloadable service pack from Microsoft may help.

NOTE: The Compact Calendar is saved as an Excel Template (XLTX) file. If you double-click an Excel template file, it opens a copy that you can save without modifying the master template. If you want to edit the template itself, you should use FILE->OPEN menu from within Excel itself instead of double-clicking the file icon.

After you open the .xltx file, there are several worksheets (see the bottom of the screen) for the 12-month, 16-month, Holiday, and Instructions table:

12-month calendar in Excel 2007To add a holiday, just type in the date in the first column and a note in the second. The rest of this is for fancy formatting.The instructions worksheet reminds you how to modify things

Modifying the starting day of the calendar is very easy: just edit the starting date by typing in a new one. The calendar will update automatically.

If you need to make a longer calendar, that’s easy too: just extend the range as you would normally with any list in Excel. Incidentally, the Excel spreadsheet also includes a 16-month calendar as a separate worksheet.

Changing the background colors is a little trickier; you’ll have to edit the conditional formatting in use on the worksheet. This video might help:

Downloading Notes

Please note that Microsoft Excel 2007 or newer is required. Other software like Open Office, Google Docs, and Numbers may import the Excel spreadsheet, but due to differences in the way they handle dates you should double-check that the calendars are correct.

For the official USA version, each zip archive includes with three templates (xltx). Printable PDFs included in each download. If you are using an older version of Excel, see Microsoft’s update directions to add XLSX/XLTX file compatibility.

The international versions are NOT created by me. Please read the instructions on the international contributor’s website for a description of the download content.



Official USA 2015

Please read “Downloading Instructions” in the main text if you have any problems.

2015 Spreadsheet Versions

16-us.gif.jpgExcel Source Package by Dave Seah w/ major US holidays. This includes all the 2015 PDFs in addition to the editable Excel source templates.

16-us.gif.jpgNumbers Source Package is new! It does not have all the features of the Excel version.

2015 PDF Only

16-us.gif.jpgUS PDF Package contains PDFs formatted in the US Letter (8.5 x 11 inch) paper size.

16-us.gif.jpgA4 PDF Package contains PDFs formatted in the A4 international paper size.

International Versions

These are links to translations made by various people around the world. Thank you, everyone!

Note: Not all versions use the latest Compact Calendar code, so features and formatting will vary from the US version. A + indicates calendars that are updated yearly by the translator.


16-ar.gif.jpgCalendario 2015 (Argentina) by Jeroen Sangers +

16-br.gif.jpgCalendário 2015 (Brazilian Portuguese) by André Luiz Bernardes +

16-cl.gif.jpgCalendario 2015 (Chile) by Jeroen Sangers +

16-co.gif.jpgCalendario 2015 (Columbia) by Jeroen Sangers +

16-ec.gif.jpgCalendario 2015 (Ecuador) by Jeroen Sangers +

16-gt.gif.jpgCalendario 2015 (Guatemala) by Jeroen Sangers +

16-mx.gif.jpgCalendario 2015 (Mexico) by Jeroen Sangers +

16-pe.gif.jpgCalendario 2015 (Peru) by Jeroen Sangers +

16-uy.gif.jpgCalendario 2015 (Uruguay) by Jeroen Sangers +

16-ve.gif.jpgCalendario 2015 (Venezula) by Jeroen Sangers +


16-jp.gif.jpg2014年カレンダ (Japan) by Momo

16-my.gif.jpgCalendar 2014 (Malaysia) by oboitoke


16-fr.gif.jpgCalendrier 2015 (France) by Jean-Philippe Papillon +

16-de.gif.jpgKalender 2014 (Germany) by Lennart Hennigs +

16-it.gif.jpgCalendario 2015 (Italy) by Alexander Reif +

16-pl.gif.jpgKalendarz 2014 (Poland) by Jacek Synowiec +

16-pt.gif.jpgCalendário 2014 (Portugal) (DIRECT LINK TO ZIP) by Ricardo Marcelo

16-ru.gif.jpgкалендарь 2014 (Russia) by Evgeny Kuznetsov

16-si.gif.jpgKoledar 2015 (Slovenia) by Jernej Zupanc +

16-es.gif.jpgCalendario 2015 (Spain) by Jeroen Sangers +

16-se.gif.jpgKalendern 2015 (Sweden) by Produktivitetsbloggen

Your Country Is Not Listed?

I post links to new calendars for 2015 as I get them. If you’d like to contribute, modify the USA Excel Source (here’s the ZIP archive) with your country’s holidays, ZIP the templates, and then post on your blog. Tell me where to link to it!

Other Versions of the Compact Calendar

  • Rene Springmeier has a PDF calendar maker / tracker inspired by the Compact Calendar called The PDF Calendar.
  • Yoshiomi KURISU has programmed an online Compact Calendar Creator that will even create PDFs.


  1. Lm

    December 11, 2014

    Dave Seah, where have you been all my life? Thank you, thank you, for this website.

  2. arthur

    January 2, 2015

    Dave, the auto-calculation and idea of this calendar are awesome. I also constructed a similar table in 2002 for my study schedules on very tough exams. If I had your calendar with such great formulas I would have not manually input the entries date by date for consecutive weeks. Thanks for sharing.

    We would appreciate if you could investigate one point in your calendar. If the first day of a month falls into a holiday the numeric “1” does not change to the orange color. Look forward to this little improvement for a perfection :-)

  3. arthur

    January 2, 2015

    One more little observation…The gridline around the “1” of each month is lost for some reason. I am not sure if this is related somehow to my prior question.

  4. Khirry

    January 18, 2015

    it’s help a lot

  5. Dave Seah

    February 5, 2015

    Arthur: It’s probably the order in which conditional formatting is applied. I’ll see if I can fix it for next year!

Would you like to share your thoughts?

Your email address will not be published. Required fields are marked *

20 + seven =

Related Postssimilar work