As some of you may already know, I can be quite the organization fiend when I want to be one. And when it comes to my blog, I do want to be one. It makes everything so much simpler and less stressful when I don’t have to remember or keep track of things in my head, don’t have to search through the list of drafts I have in WordPress just to figure out what posts I have, etc.
And that is why spreadsheets have become my new best friend! I use them for lots of things, and I have a really simple but really helpful one that I use just for my blog that I’m going to share with all today. And if you think you might find it helpful too, you can even download my template to use!
Honestly this is really, really simple and self-explanatory, but I’ll explain it all just in case using this handy-dandy graphic. (If it’s too hard to see, you can click on it to see a larger image.)
1 – Date
This is… the date. If you download my template, this will already be filled in.
2 – Post Title
This is the title of the post (I told you, self-explanatory).
3 – Is the Post Ready to Go Up?
If it’s completely 100% ready, I make the box green. If it’s only partly ready, I make the box yellow. If it’s not even started, I just leave it blank. Obviously you can use another color to mark posts that haven’t been started, or you can use more color coding to stand for different things, but I like to keep it simple with just those two colors.
4 – Crossing Out Posts that have Already Gone Up
I like to cross out the posts that have already gone up so that I can easily keep track of where I am. All you have to do in Excel is highlight the cells you want to be crossed out, click the little arrow, then, when a pop-up opens, select the checkbox for “strikethrough” under the “font” tab.
5 – Adding the Color Coding
All you have to do to change the color of the cells is highlight the cells you want colored, then click the arrow next to the paint bucket, and that will bring up all the different color choices.
I didn’t include it in the image, but in the column to the right of the color coding, I sometimes put notes if I have any, like if a post still needs editing or a graphic.
Extra Tips & Customization
Keeping a List of Unscheduled Posts
In addition to the spreadsheet, I also keep a list of posts that are finished or partly finished but not yet given a date to be posted. That way, when I have an opening coming up, I have a handy list to choose from. I find that easier than trying to plan too far ahead as I always end up rearranging things a million times when I do that.
Download My Post Schedule Template
I think that about covers it! If you want to use my template, you’re more than welcome to. If you just want to use it as a normal schedule or something non-blogging related, that’s cool too. Schedules are just super helpful in general. If you do use my template, let me know how it works for you in the comments! (The 2018 and 2019 ones were created with Open Office, and I haven’t tested how that file type works with other spreadsheet programs, but hopefully it will work right.)