I’m a planner. I need every single thing mapped out weeks in advance or I feel stressed. Having an editorial calendar has helped me stay on top of writing content, while still keeping track of upcoming events going on (webinars, photography sessions, etc.)
If you are looking to create your own editorial calendar to print and use, here is a step by step guide to make one in Excel.
First, I started by creating a basic calendar spread. I included the title (“My Editorial Calendar”), a place for the month (to be filled in as I go), and weekdays, Monday-Friday, because those are the only days of the week that I focus solely on producing and editing content.
Example: I typed “My Editorial Calendar” into Cell A1. I then highlighted across all of the cells I wanted the title to be in. I then hit the merge & center button (see photo below). & I made sure everything was centered and aligned where I wanted it to be.
Repeat this process until your calendar spread is complete.
Next, I added an “ideas” section. I like this section because I can jot down any ideas I have for my blog. They always pop in my head at the most random times, so it’s great to have a place to put them! & when I run out of ideas (which hasn’t happened yet), I can always go back and see some of my previous ideas.
Again, just type what you want in the cells. Highlight all the cells you would like included in the section and then hit “merge & center”.
After I created my calendar spread and ideas section. I wanted to add a checklist so that I could refer to it on publishing days. I like this section because I can map out everything I need to do before and after publishing a post.
The next thing I did was add a notes section. I’m a forgetful person if I don’t remind myself 500 times about something. So this section is helpful for me when I need to remember something for next month.
For example, upcoming holidays, scheduled guest posts, an event you may be hosting online, etc.
After I finished making and merging all of my cells and sections, I added some color. My blog theme is a teal color and I like having fresh colors whenever I’m doing my work because it keeps me inspired. I went with pink for this month (next month’s will probably be a different color).
Here are my finished products. Finally, you can set the print area (see photo below) and print out your calendar. I printed 3 out and put them in sheet protectors and then into my binder, so I can write and rewrite on them every few months.
There you go! How to create an editorial calendar for your blog in Excel.
If you found this useful, please comment and share with your friends!
Have a beautiful day!
[If you liked this, you may also like…]