Content Calendar Template
Posting regularly on a blog or social media requires planning ahead. There are some useful online tools for scheduling your posts to be published in the future (such as later.com), if you have the images and descriptions completed. However, you may also want a method for planning future posts that aren't finished yet, perhaps even months down the road. For a free tool with a built-in publishing timeline and monthly calendar, download our new social media Content Calendar Template for Excel or Google Sheets.
Content Calendarfor Excel or Google Sheets
Note: This spreadsheet does not actually schedule your posts to be published. For that, you can use an app such as Later.com.
Using the Content Calendar
The help worksheet provides some guidance on how to use the spreadsheet. One of the main things to realize is that you edit the titles, descriptions and dates in the Content worksheet and only use the Calendar worksheet to view the publish dates within a monthly calendar (up to 3 per day).
HOLIDAYS: A lot of social media posts are themed based on upcoming holidays, so that is why our calendar includes some of the common U.S. holidays and observances in the Settings worksheet. However, the calendar view only shows up to one of these events per day. You are unlikely to forget the common holidays, so note that it is the FIRST holiday in the list that shows up on the calendar, and reorder the list as needed.
COLLABORATION: To use the content calendar in collaboration with other people on your team, you'll either need to ALL be using Office 365 (to use Excel with real-time collaboration), or you can use the Google Sheets version.
IMAGES/VIDEOS: You can create a shared folder in Google Sheets to store your draft and final images used for your social media content.
DESCRIPTION LENGTH: Social media posts often prefer a short description, so the Length column uses the LEN() function to count the characters in the Description column.
HASHTAG ORGANIZER: One of the worksheets not shown in the screenshot above is a table for organizing your hashtags. I've found this to be extremely useful for keeping track of the hashtags I want to use for Instagram posts. By using the Sort feature in Excel and Google Sheets, you can categorize your tags, and mark which ones you want to include. Then, Sort the "INCLUDED" column so that the tags you want to include are listed at the top. Then, you can easily copy and paste directly into your post.