Post may contain affiliate links. Click to read Disclosure . Click to read Privacy Policy.
Whether you’re just starting out or you’ve been blogging for years, creating a blog post spreadsheet can save your sanity. It’s one of the best things you can do to keep your content organized and your promotional workflow smooth.
How To Make A Blog Post Spreadsheet
Why You’ll Want This Spreadsheet
If you blog regularly, a spreadsheet makes it easy to:
✅ Keep track of your published posts
✅ Manage seasonal or evergreen content
✅ Grab links for social sharing in seconds
✅ Organize pins and hero images
✅ Plan re-promotions across your platforms
Honestly, it’s one of the most useful blogging tools you’ll ever create.
💡 Pro Tip: Check out this wireless keyboard and mouse combo for faster spreadsheet work — saves your wrists when you’re bulk entering posts.
🧠 What to Include in Your Blog Spreadsheet
Set up your spreadsheet with columns for:
- Post Title
- Post URL
- Hero Image Link
- Pinterest Pin Link
- Content Type (Evergreen, Seasonal, Holiday, etc.)
- Category or Topic
That’s it! You can build from there later, but those core columns will help you stay organized from day one.
📸 Hero Image vs. Pinterest Pin
The hero image is the main image you feature in the post. This is the one that gets shared to Facebook and Twitter. Right-click it and copy the image address — not the image link — and paste it into your sheet.
Do the same with your Pinterest pin. Grab the direct URL by clicking the pin and copying the full URL from the browser.
📂 Sorting by Category
Want to get fancy? Add a column to label your content buckets — maybe DIY, Gardening, Holidays, Recipes, etc. Later, when you’re prepping holiday content, just filter your sheet to see only Christmas posts and boom — instant strategy.
🎯 This ties in perfectly with How to Plan a Month of Blog Posts in Under an Hour, which walks you through batching content for your niche.
💡 Use It for Evergreen Automation
If you use a scheduler like Tailwind or Buffer, having all your evergreen posts lined up makes it super simple to upload them in bulk. Just download the sheet, and you’re ready to go.
Tip: Highlight evergreen content in green and seasonal content in red to see what’s safe to schedule year-round.
📝 Keep It Updated
The best time to update your spreadsheet is as soon as you publish a new post. I like to keep my spreadsheet open while writing and plug in the info before I forget.
Here’s how it fits into my routine:
✔️ Write post
✔️ Create images
✔️ Publish
✔️ Add to spreadsheet
✔️ Pin it and share
🔗 More Helpful Resources
If you need a little help staying organized, you might also like these:
And if you’re just getting started, don’t miss this:
👉 How to Start Your Own Blog: Everything You Need to Know
🎁 Grab the Free Spreadsheet Template
Want a ready-to-go version of my blogging spreadsheet? Get it here:
📥 [Download Your Blog Post Tracking Template] (insert opt-in or lead magnet link)
If you’re new to the site – Welcome! Be sure to check out these posts, too, to get started on your journey.
So far we have:
- decided to start a blog
- found our niche
- bought a domain
- chose the blogging platform
- set up your blog and made it all pretty 🙂
- signed up for and installed Google Analytics
- added copyright to the website footer
- added a Privacy Policy and Disclosure page
- added an About Page
- set up our email newsletter
- learned how to choose and install a new plugin
- checked out my list of must have plugins
- discussed ways to grow a blog fast
- come up with an SEO checklist
- how to start vlogging
- how to start making money through sponsored posts
- Backing Up Your Blog: A Cautionary Tale
Whether you’re just starting out or you’ve been blogging for years, creating a blog post spreadsheet can save your sanity. It’s one of the best things you can do to keep your content organized and your promotional workflow smooth.
Start A Blog Post Spreadsheet You WILL Need It
I want to talk about keeping a spreadsheet for your blog today. This is something that I started 4 years after I started blogging, so it required much time to accomplish. I want to tell you now to begin doing this because you never know how often you’ll need this spreadsheet.
I have a Google spreadsheet, it’s free and it’s easy to use. This has come in handy so many times. When I need to quickly find a post I can just go to the spreadsheet and search really quickly.
It’s come in handy for me when I’ve started a new social media sharing program and needed to quickly add all of my Evergreen posts to the program so that it can be sharing those posts for me on social media.
🧠 What to Include in Your Blog Spreadsheet
Set up your spreadsheet with columns for:
- Post Title
- Post URL
- Hero Image Link
- Pinterest Pin Link
- Content Type (Evergreen, Seasonal, Holiday, etc.)
- Category or Topic
That’s it! You can build from there later, but those core columns will help you stay organized from day one.
An Evergreen post is a post that is good for years to come, they’re not dated material, it’s not something that will expire like a post on Fourth of July Fireworks displays – that’s something that’s going to change each year.
Evergreen is something that doesn’t have an end date on it, like a craft or recipe or directions for using a specific savings app. It’s something that can be live on the internet forever and still be relevant.
💡 Use It for Evergreen Automation
Getting back to our spreadsheet, if you wanted to take your Evergreen posts and put those in a social media program that would post those continually for you so that you don’t have to remember to go in and post them, they’re all on your spreadsheet and you can make a file with a push of a button and upload them into a social media program to do that for you.
If you use a scheduler like Tailwind or Buffer, having all your evergreen posts lined up makes it super simple to upload them in bulk. Just download the sheet, and you’re ready to go.
Tip: Highlight evergreen content in green and seasonal content in red to see what’s safe to schedule year-round.
📂 Sorting by Category
Or you can use your spreadsheet to hand post certain things if you want to say keep your Thanksgiving stuff in one area and then when it’s Thanksgiving you can know every day to go to your spreadsheet, grab a few Thanksgiving posts and load them into your social media platforms to hand post them each day.
Want to get fancy? Add a column to label your content buckets — maybe DIY, Gardening, Holidays, Recipes, etc. Later, when you’re prepping holiday content, just filter your sheet to see only Christmas posts and boom — instant strategy.
🎯 This ties in perfectly with How to Plan a Month of Blog Posts in Under an Hour, which walks you through batching content for your niche.
A spreadsheet of your posts, your main picture in the post, your title, and your pin, is super handy to have and it’s super easy to start your spreadsheet when you start your new blog.
Like I said I started mine four years into my first blog and it took me forever to get everything in there since I posted more than once every day on that blog, it was difficult.
Getting Started
Basically, all you want to do is put the title to each post on the spreadsheet, the link to each post on the spreadsheet in a different field, in the next field put a link to the hero image for that post, and finally the link to the pin for that post.
📸 Hero Image vs. Pinterest Pin
What is a “hero image” you ask? It’s the main image in your post – the one that goes out on most social media like Twitter and Facebook. To get the hero image link just right click on the image you want the link for and click on “Copy Image Address”.
Do the same with your Pinterest pin. Grab the direct URL by clicking the pin and copying the full URL from the browser.
Most people add a link to their image that will take you somewhere else when you click it instead of to the image itself. So, you want to click on “Copy Image Address” NOT Image Link.
The pin link of course is for the Pinterest pin image you add to your post.
You can get the pin link by clicking on the pin on Pinterest and then copying the URL at the top of the page that opens up:
Once you have your spreadsheet and you start keeping up with it, you might choose to separate it into a few categories.
Say you have recipes on your blog and you also have crafts, or you want to separate your Christmas posts from your Thanksgiving posts, you can do this in any way that you want on the spreadsheet. Then if you want to grab all of your Christmas posts or recipes or even seasonal recipes and add them to your social media postings you have them all sorted already.
Or if another blogger or reader asks if you have posts on specific things, you can easily grab the links and share them! What you want to do is think into the future and how you might want to use this spreadsheet and make sure you don’t have to rearrange the entire thing later on.
To separate your spreadsheet into a few categories I just add a field at the beginning of the spreadsheet and categorize the post as I add it to the spreadsheet. You can then insert rows under like posts to add more later in the same category.
You can even color code the categories to make it even easier to see. There’s no limit of the ways you can do it and no way is right except for what is right for you.
Once you publish a post to your blog – your work isn’t finished. For me, it’s easiest for me to grab these links and pop them in my spreadsheet at the same time I publish the post – that way I don’t forget.
I have a checklist of things I do once I publish so that I don’t forget to do anything. I’ll share that with you next week.
I hope you do start a spreadsheet now rather than later you’ll be glad you did. You can use Google or Excel if you have it. However you want to do it, just do it! lol
📝 Keep It Updated
The best time to update your spreadsheet is as soon as you publish a new post. I like to keep my spreadsheet open while writing and plug in the info before I forget.
Here’s how it fits into my routine:
✔️ Write post
✔️ Create images
✔️ Publish
✔️ Add to spreadsheet
✔️ Pin it and share
This is one in this series of posts. We are covering topics on how to start a blog, how to make money blogging, and how to enjoy blogging.
Be sure to read all of these posts so you don’t miss any of the steps you’ll need to start your own business and be able to work from home! As I write new posts you’ll see them added to this page.
📚 More Helpful Tools for Staying Organized
If you’re ready to keep your blog content flowing smoothly, here are a few more helpful tools worth checking out:
📘 The Ultimate Blog Starter Kit
An all-in-one toolkit for bloggers who want to plan, grow, and stay organized without reinventing the wheel.
📌 How To Start Your Own Blog: Everything You Need To Know In One Place
A one-stop guide if you’re building your blog from the ground up or want to make sure your foundation is solid.
💡 The Best Free Blogging Tools That Can Save You Hours Every Week
A roundup of time-saving tools that can make your blogging life easier without spending a dime.
✨ 10-Minute Blog Growth Checklist
This quick-start checklist helps you stay consistent and strategic with your blog growth — great to keep alongside your spreadsheet.
Very helpful! Thank you!
Vina,
You’re very welcome!
Dian