Photo calendar 2018: 5 free editable Excel templates

Insert your own photos in Excel or Google Sheets,
then print a personalized 2018 calendar.

Advertisement
Download 5 free photo calendar templates for 2018 in Microsoft Excel format (.xlsx), with the dates and the US federal holidays of 2018 printed and an empty space on each page for a photo of your own. A photo calendar for 2018 makes a keepsake of that year: a baby born in 2018, a wedding year or a family year in review. No registration or email sign-up needed.

Find the right photo calendar for 2018

Twelve pages, one for each month
Templates 1, 2 and 3 give each month its own portrait page, with the photo space above the calendar. Template 1 has a standard month grid and takes a photo up to 4x6 inches in portrait or 5x7 inches in landscape orientation. Template 2 has large, easy-to-read numerals, and template 3 sets out the days in three columns with a line next to each day for birthdays and notes; both take photos up to 5x7 inches in either orientation.
The whole year on one page
Template 4 puts one photo (up to 4x6 inches in portrait or 5x7 inches in landscape orientation) above the whole year on a single sheet, a quick gift that works as a wall or desk calendar.
Landscape pages
Template 5 has twelve landscape pages, each with the days of the month in a single row beneath a photo up to 5x7 inches.
What is printed
The 2018 photo calendars show the dates and days of the week of 2018 and mark the US federal holidays, including the observed day off when a holiday falls on a weekend. The photo space on each page is left empty, so nothing gets in the way of your picture. Templates 1 to 4 are in portrait and template 5 in landscape, all on US Letter paper (8.5 x 11 inches).
Edit in Excel, then print
Click the empty photo space, choose Insert > Pictures and drag the corners of your photo until it fills the space; in Google Sheets, use Insert > Image > Image over cells. Type in birthdays and other dates, or add your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). Print a test page first to check how the photos sit on the paper. Prefer to glue photos on by hand? The same photo calendars are available as PDF files.
Photo calendar ideas, and how the 2018 photo calendars differ from the perpetual ones, are below the templates.

Photo calendars 2018 for Microsoft Excel,
portrait orientation (4 templates)

Change to:  PDF (.pdf)   ·   Word (.docx)   
Download Template 1: Photo calendar 2018 for Excel, 12 pages, portrait format, standard layout
12 pages, portrait format,
standard layout

Template 1:
Photo calendar 2018
portrait, standard layout

  • 12 pages (1 page per month), portrait orientation (vertical)
  • for photos up to 4x6in in portrait orientation (vertical)
  • for photos up to 5x7in in landscape orientation (horizontal)
  • US edition with federal holidays 2018
  • free to download, editable, customizable, easily printable

Download template 112 pages · 26 KB · xlsx file
Download Template 2: Photo calendar 2018 for Excel, 12 pages, portrait format, large numerals for easy reading
12 pages, portrait format,
large numerals for easy reading

Template 2:
Photo calendar 2018
portrait, large numerals

  • 12 pages (1 page per month), portrait orientation (vertical)
  • with large clear numerals for easy reading
  • for photos up to 5x7in in both portrait (vertical) and landscape (horizontal) orientations
  • US edition with federal holidays 2018
  • free to download, editable, customizable, easily printable

Download template 212 pages · 27 KB · xlsx file
Download Template 3: Photo calendar 2018 for Excel, 12 pages, portrait format, days in three columns
12 pages, portrait format,
days in three columns

Template 3:
Photo calendar 2018
portrait, days in three columns

  • 12 pages (1 page per month), portrait orientation (vertical)
  • for photos up to 5x7in in both portrait (vertical) and landscape (horizontal) orientations
  • with space for notes (e.g. birthdays) next to each day
  • US edition with federal holidays 2018
  • free to download, editable, customizable, easily printable

Download template 312 pages · 31 KB · xlsx file
Download Template 4: Photo calendar 2018 for Excel, portrait format, whole year on one page
portrait format,
whole year on one page

Template 4:
Photo calendar 2018
portrait, whole year on one page

  • the whole year on one page, portrait orientation (vertical)
  • for one photo up to 4x6in in portrait orientation (vertical)
  • for one photo up to 5x7in in landscape orientation (horizontal)
  • US edition with federal holidays 2018
  • free to download, editable, customizable, easily printable

Download template 41 page · 23 KB · xlsx file

Photo calendars 2018 for Microsoft Excel,
landscape orientation (1 template)

Change to:  PDF (.pdf)   ·   Word (.docx)   
Download Template 5: Photo calendar 2018 for Excel, 12 pages, landscape format
12 pages, landscape format

Template 5:
Photo calendar 2018
landscape

  • 12 pages (1 page per month), landscape orientation (horizontal)
  • for photos up to 5x7in
  • US edition with federal holidays 2018
  • free to download, editable, customizable, easily printable

Download template 512 pages · 31 KB · xlsx file

Making your photo calendar

Photo calendar ideas

Gifts for the family
A photo calendar works for almost any occasion: a grandparents' calendar with a new photo of the grandchildren for every month, a baby's first year with one month per page, a year in review with the best photo from each month of the past year, or a family recipe calendar with a photo of the dish on each page.
Hobbies, pets and travel
Show the seasons in your garden, your neighborhood or your favorite park, make a pet calendar starring the dog or the cat, or fill a travel calendar with photos from last year's trips.
Business, school and clubs
Give clients a calendar with photos of your products, your store or your team, or make a class, club or team calendar with a group photo for every month.
Photo calendar 2018 or perpetual photo calendar?
The 2018 photo calendars have the dates, the days of the week and the holidays of 2018 printed. The perpetual photo calendars have the same layouts without a year, so you can start them in any month or make the same calendar again next year.

Ideas for your 2018 photo calendar in Excel

Cropping photos to fit the space
Select a photo and use Crop → Aspect Ratio on the Picture Format tab - 2:3 suits a space made for a 4x6 print - then drag it into place. Corrections and Color on the same tab brighten a dark photo or turn it into black and white before you print.
Checking every page before printing
Type a caption or a birthday into the cells below the photo, then step through every page on the Print screen before you print, so no photo spills onto the next page. Large photos make the file heavy, and Compress Pictures on the Picture Format tab keeps it small enough to email.

Using the templates

Terms of Use

All templates on this site may be used free of charge, at home, at work and at school, provided that the Calendarpedia logo, the copyright notice with the website address ("© Calendarpedia® www.calendarpedia.com") and the disclaimer ("Data provided 'as is' without warranty") stay on the template. The templates may not be sold or built into products that are sold, and the blank templates (or copies with only minor changes) may not be offered for download on other websites. All content on this site is protected by copyright © 2011-2026 Calendarpedia®. All rights reserved. Data is provided 'as is' without warranty of any kind, may contain errors and is subject to change without notice. If you find a mistake, please let us know. Full details are in our Terms of Use.

System requirements and compatibility

Every template is saved in Microsoft Excel (.xlsx) format, the Office Open XML spreadsheet format standardized as ISO/IEC 29500.
  • Microsoft Excel
    The templates open in Excel 2007 and later for Windows, Excel 2008 and later for Mac, Microsoft 365 and Excel for the web.
  • Google Sheets
    The .xlsx files open in Google Sheets with the layout intact, so you can fill the template in from a browser on any computer, tablet or phone without installing anything.
  • Free alternatives
    If you do not have Excel installed, Microsoft 365 for the web is free to use in a browser, and free desktop alternatives such as FreeOffice PlanMaker and LibreOffice Calc open our templates without formatting errors. Apple's Numbers opens the files too, but the layout may shift, and OpenOffice Calc unfortunately has formatting problems with some of our calendars.
  • Editing on a phone or tablet
    The Excel app for Android and iOS and the Google Sheets app both open these files, so you can add or check an entry away from your desk and print the sheet later from any computer.
  • Your own dates, colors and logo
    Type your entries straight into the day cells, shade the days that matter to you and add your own logo alongside the Calendarpedia logo - our FAQ shows how to add your own dates, colors or logo.
  • Printing in black and white
    To save color ink, you can print any template in black and white.
  • Older versions of Excel
    Excel 2003 and older versions can't open .xlsx files directly. Open the template in Excel for the web or one of the free programs above instead, or use the PDF version of the calendar.

How to open and print these templates in Google Sheets

Download the .xlsx file first. Then either drag it into Google Drive, right-click it and choose Open with → Google Sheets, or open Sheets and go to File → Open → Upload. The template keeps its layout and colors, and you can type into the cells and change the fill colors exactly as you would in Excel.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.

Problems downloading, opening or printing a template?