“Unlock the Secret to Viral Blogging: Master the Art of the Editorial Calendar!”

Create a new spreadsheet and add your top row

First, create a new spreadsheet, and add a top row with the following labels:

1. Date
2. Topic
3. Category (these should match your blog categories)
4. Status
5. Author (if your blog will have more than one author)
6. Published Link

It should look something like this:

Add rows for months under column A

Next, add some placeholder dates and columns for future months. This will help keep your calendar organized as the year progresses:

Add a dropdown selector under the Status column

If you’re using Google Sheets, click Insert, then click Dropdown. This is how we’ll add status selector options that will make it easy to see the progress you’re making on each post:

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25