By DiAnn Mills @diannmills

Are you scrambling through your files for the last time you created a blog post?

Are you pulling your hair out trying to keep track of when a blog is due or when it appears? Or even what you wrote?

Have you neglected an image or related meme?

Did you forget a hashtag or a click-to-tweet? 

Are you having second thoughts about blogging because the organization is driving you nuts?

Then relax. I have a solution for you, and it’s super easy. All you need is a spreadsheet titled Blog Organization. A single page works if the writer is blogging on only one site. Or you can create additional tabs for each additional blog site.

The following columns will ease your addiction to Tylenol and strong drink during your blog writing and posting.

Blog Name: What is the title of the blog?

Website: What is the website hosting the blog? If this is your personal one, delete this column.

Contact Person:

Contact Person E-mail:

Title of Post:

Length: Most blogs range from 300 to 500 words. Keep track of your blog length.

Specifics – Giveaway etc: This is a column for extra information pertinent to the blog. Perhaps a giveaway or a deadline for the reader to take action.

Date Due: When is the blog post due? I suggest scheduling this on your calendar at least two weeks before the due date. This gives the writer plenty of time to create and edit.

Date Sent: When the blog post is e-mailed or posted.

Date Live: This is when the blog post goes live. Schedule this on your calendar so the blog can be shared through social media, and you’ll be reminded to check for comments and respond when applicable.

Hashtags: Have these ready to cut and paste.

Image File/Name: Record the name of the images and memes that are unique.

Comments: Additional information

If you’d like a copy of my spreadsheet template, click here. https://diannmills.com/temp/BlogOrganizationTemplate-DiAnnMills.xlsx

How do you keep your blogs organized?

DiAnn Mills is a bestselling author who believes her readers should expect an adventure. Her titles have appeared on the CBA and ECPA bestseller lists; won two Christy Awards; and been finalists for the RITA, Daphne Du Maurier, Inspirational Readers’ Choice, and Carol award contests. Firewall, the first book in her Houston: FBI series, was listed by Library Journal as one of the best Christian Fiction books of 2014.

DiAnn is a founding board member of the American Christian Fiction Writers, a member of Advanced Writers and Speakers Association, Suspense Sister, and International Thriller Writers. She is co-director of The Blue Ridge Mountain Christian Writers Conference with social media specialist Edie Melson. She teaches writing workshops around the country. DiAnn is active online and would love to connect with readers on any of the social media platforms listed at http://www.diannmills.com