2027 Planner

About this download

A 2027 planner spreadsheet for Google Sheets where you type each event once and it appears on the month calendar, year view and weekly view. Keep a dated task list with done boxes and print any week on one page.

Developed for Google Sheets. An Excel file is included for the latest Microsoft 365 (Office 365 Desktop App). Older Excel versions may not support all features. No macros, no scripts, no add-ons.

WHAT'S INSIDE (20 tabs in each workbook)

• How To: steps, color key, week-number rule, Google Sheets notes and Excel file notes
• Settings: first month and year (January 2027, or any month such as August 2026 for a school year), Sunday or Monday week start, 5 category names, planner name
• Events: type each event once (date, start time, event, category, notes); 500 rows ready
• Tasks: due date, task, category and Done (TRUE/FALSE); done tasks are crossed off, overdue dates turn red; 500 rows ready
• Key Dates: birthdays and yearly dates listed once (month, day, label); they show every year on the calendars
• Month 1 to Month 12: auto-filled month calendars with up to 3 events per day, start times, category colors, the first key date, a task count and "+N more"
• Week View: pick a week number (1 to 53 for 2027) to see 7 days with up to 5 events and 6 tasks each, with done marks; prints on one landscape page
• Year View: 12 mini calendars; days with events are filled in, key dates are marked
• Dashboard: tasks done this week and this month, overdue tasks, events in the next 7 days, a 7-day agenda and an events and tasks by month chart

The calendar tabs are formulas only, so changing the week or the first month never loses anything you typed. Every calendar tab has a one-page landscape print area.

𝗙𝗜𝗟𝗘𝗦 (𝟑)

• 2027-Planner.xlsx: blank planner, 20 tabs
• 2027-Planner_Sample.xlsx: the same planner filled with a made-up family schedule, 20 tabs
• 2027-Planner-Start-Here.pdf: 2-page guide with the Google Sheets copy links (make a copy in your own Google account)

𝗦𝗜𝗭𝗘𝗦 𝗔𝗡𝗗 𝗣𝗥𝗜𝗡𝗧𝗜𝗡𝗚

Print any calendar tab on US Letter or A4, landscape, fit to one page.

ℹ 𝗚𝗢𝗢𝗗 𝗧𝗢 𝗞𝗡𝗢𝗪

• Week 1 is the week that holds the 1st day of your first month (for a January 2027 start, Week 53 holds Dec 31, 2027).
• Month tabs show up to 3 events per day; long event names are cut off on the calendar cells but stay in full on the Events tab.
• This planner does not sync with Google Calendar and has no hourly time blocks.
• The Start Here PDF opens best in the free Adobe Acrobat Reader, Chrome, or Edge.

Digital download, nothing shipped. For personal use only.

Designed by me, created using AI tools.

The Etsy listing is the final source for what is included. See it on Etsy.