Using Excel to Create an Editorial Calendar

So you’ve noticed I’m really on a kick with this editorial calendar thingy, huh? Two posts about it two days in a row…

I see an EC as an immense tool for bloggers. Although I have just instituted this tool in my writing life yesterday, it has already done innumerable things to assist me:

  • Organized my weeks into cohesive “themes”
  • Ensured that I am not overloading my readers with the same drudgery day after day after day
  • Gives me a clear overview of my weeks and months
  • Has “forced” me to plan ahead — I had to fill out the calendar once created, right?
  • Removed the forced scrambling to 1) come up with something to post, and 2) writing it on the fly once I thought of something so that I can get it posted that same day ;-p
  • The list goes on and on…

I used Microsoft Excel to create my EC. It was the easiest piece of software I could easily use to layout the calendar. Others have used Microsoft Word and the table function in Word. I decided not to deal with adjusting rows and columns in Word when Excel was made to easily do just that. Here’s a screenshot of the beginnings of my calendar, with the layout of it being based on Michele Linn’s screenshot from her article entitled How to Put Together an Editorial Calendar for Content Marketing, which I shared with you in yesterday’s post:

EC Screenshot

My Editorial Calendar Screenshot

My goal is to post an article 5 days a week — Monday through Friday. On the first Saturday of each month, I will share a short story writing sample. This sample writing project will be a “first draft”, so don’t look for perfect grammar and sentence structure and the other trappings of finalized prose. It’s a fun exercise for self to keep me writing and for my readers to keep them motivated and writing as well.

Each day of the week has a specific theme. For example, each Monday I will write about the articles and information which I’ve devoured over the weekend as it relates to writing. I read up on the writing industry constantly and I would like to share some of the information I garner through my reading. Fridays are my “break” day where I get to write about whatever is churning up in that brain of mine. It’s the day I let the Muse free to do as she pleases. I may post a poem, or you may get an article about my Shorkie, Ebonie (a Shorkie is a Shitzu/Yorkie “designer” breed dog — a mutt with a price tag LOL! but I love her so…she’s my writing buddy…). You never know…

I hope that yesterday’s article at least got you thinking about ECs and how they can be useful to you in your writer’s life. If not, then today’s should really get you going — especially if you’ve been struggling to be a faithful blogger who publishes great content and not just throwing something up to say that you post daily. This tool in one day has already had a major, positive impact on my schedule and my time management. You could enjoy the same benefits too by instituting your EC today!

If you are interested in instituting an EC but are not the techie type, shoot me an e-mail and I’ll send you a blank copy of my Excel spreadsheet for your use. You will need Microsoft Excel in order to open/edit it for your use. Google Docs may also be used as well.

Time to share…
Let’s see a screenshot of your EC! What software did you use to create it? Any tips on easy ways to create one? You are creating a daily calendar for a full year afterall… 

Advertisements