by DiAnn Mills @DiAnnMills

Are you scrambling through your files for the last time you posted a blog title?

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

At the last minute of posting, have you neglected an image?

Have you groaned at forgetting a hashtag on a tweetable?

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.

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

• Blog Name: What is the title of your blog?
• Website: What is the site where you are posting? If this is your personal one, delete this column.
• Owner: Who is the contact person? If this is your personal site, delete this column.
• Contact Person: If this is your personal site, delete this column.
• Contact Person E-mail:
• Length: Most blogs range from 300 to 500 words. Keep track of your blog length.
• Date Due: When is the blog due? I suggest posting this on your calendar one week before the due date. This gives the writer plenty of time to write.
• Posted Date: What is the date you posted the blog or emailed it to the site’s contact?
• Date Live: When does the blog appear? Post this on your calendar too so you can share it through social media.
• Hashtag: Have these ready to cut and paste.
• Image File/Name: We want our images and memes to be unique.
• 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.
• Comments: Additional information

If you’d like a copy of the Blog Organization spreadsheet click here.

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. Library Journal presented her with a Best Books 2014: Genre Fiction award in the Christian Fiction category for Firewall.

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 and The Author Roadmap 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 www.diannmills.com.