Keeping track of your published blog posts can save you stress and keep you organized. I remember when I realized that a blog posts list would come in handy. When I ran my DIY blog, and I had over 100 posts. Imagine the time it took to type my blog post list. Don’t let this happen to you. Keeping track of your blog posts can help your business stay organized and help you maintain your sanity!
The Best Way To Keep Track
I keep an excel spreadsheet. But if you are not familiar with Excel, you can use Google Sheets or even Microsoft Word to create a basic list. My list is nothing fancy. It is just a basic Excel sheet with Publish Date and Title as my titles. I group all blog posts from one year, as you can see below, and highlight the year.

I have plenty of room once I print out the document to make notes. Now, if you’re not tech-savvy, then simply writing out your blog post title and date in a notebook would work as well. Whatever system works for you!

Updating Old Blog Posts
Old blog posts need to be updated to optimize SEO, edit images and any broken or outdated links. Having a blog post list will make this task a little less daunting. If you track them by month, date, and year, you can make a note once you have updated an older post. Imagine having to go through hundreds of blog posts on your computer? Stressing out because you have updated so many, you cannot remember which ones you updated and which ones you have not!

Repurposing Popular Content
You can use your updated blog post list to repurpose popular content. On my list, I make notes regarding blog posts that were popular with my audience. That way, if I ever go through writer’s block (which we all have), I can repurpose some of my older content until I get back into my groove.
Please Pin Me! Thank you!

Roundup Blog Posts
Another great way to use your list is when you are ready to create a roundup post of specific projects. Your list will allow you to get a view of all your projects to find similar ones that you can add to your roundup post. Who can remember posts from months ago? I cannot even remember why I walk into a room sometimes! 😊

Help Create Ideas For New Blog Posts
As I mentioned above, making notes regarding which blog posts were popular with your audience would be a great way to help you create new ideas for future blog posts. For example, if your audience loves your dresser makeovers, then create more dresser projects and posts. Another idea would be to combine two popular blog posts into one! You could use a dresser makeover with a bedroom makeover and create a room renovation post or bedroom renovations on a budget in this scenario. When you’re ready to write a new blog post, use my FREE checklist, you can get HERE.
I hope that I have convinced you to start tracking your published blog posts and get busy on that list. Create the list from DAY ONE. It is a simple yet effective way to track blog posts while also making it easier for you to complete other blogging tasks. Having this list will keep you organized and keep your blog running smoothly and effectively.
Be sure to have a look at Treating Your Blog Like A Business From Day One! And feel free to leave comments or questions. I would love to chat with you! And if you have not done so already, join my subscriber’s list!
Christina 🙂
I’m guilty of not making a blog list but I see your point for the importance of having one. I’ve been working hard on updating old posts but haven’t noted which ones I’ve done. Time to get organized and start a list. Thanks for the tip!
Hi Marie,
Your welcome! You are doing awesome 🙂
I actually have a list I made a few years ago ! It’s a great idea! I just need to go back and update
Hi Maria,
Awesome! I try and schedule an hour or so every month to update mine 🙂