ABCDEFGHIJKLMNOPQRSTUV
1
If you like this FREE template, please read and tweet/share my postHow To: Plan Your Content Calendar Like a ProClick To Tweet
2
DayDateFB PostFB ImageImage urlNotes or ApprovalTweetTweet LengthNotes
3
Monday7/1/2013Feel free to duplicate this doc to your personal Google Drive and start planning your calendar! If you have any questions, please tweet me: @binghottInsert an image by going to 'Insert' -> 'Image'
OR
Use the formula =image("URL", 1)
You can also replace "URL" with the cell of an image URL, like E5		Use this column to leave notes, and or approval, or use to mark what type or category this post falls underType your tweet here and the formula =LEN(E2) will automagically give the character count89You can add any additional columns or cells as you need!
4
Tuesday7/2/2013Here is what it looks like when you insert and image. Inserting an image this way does not keep the image in the cellYou can also leave notes or comments by right clicking on a cell (try mousing over cell C3)You can set up conditional formatting to mark a cell red when you go over Twitter's 140 character limit. Don't be so verbose, it's only Twitter!144
5
Wednesday7/3/2013Here is what it looks like when you use the formula =image("http://i.imgur.com/O6mJ1PC.jpg", 1) for images. This will keep the image fitted to the cell. You can also put the URL in an adjacent cell, as seen here
http://i.imgur.com/O6mJ1PC.jpgOr you can color code to indicate whether or not something is approved or needs revision.Keep it short and sweet23
6
Thursday7/4/2013You can autofill dates by selecting two or more date cells and dragging them down.Strike-through posts once you've posted them!45
7
Friday7/5/2013You can autofill days of the week by manually writing out the first seven days, highlighting them, and then dragging to fill the rest of the month0
8
Saturday7/6/20130
9
Sunday7/7/20130
10
Monday7/8/20130
11
Tuesday7/9/20130
12
Wednesday7/10/20130
13
Thursday7/11/20130
14
Friday7/12/20130
15
Saturday7/13/20130
16
Sunday7/14/20130
17
Monday7/15/20130
18
Tuesday7/16/20130
19
Wednesday7/17/20130
20
Thursday7/18/20130
21
Friday7/19/20130
22
Saturday7/20/20130
23
Sunday7/21/20130
24
Monday7/22/20130
25
Tuesday7/23/20130
26
Wednesday7/24/20130
27
Thursday7/25/20130
28
Friday7/26/20130
29
Saturday7/27/20130
30
Sunday7/28/20130
31
Monday7/29/20130
32
Tuesday7/30/20130
33
Wednesday7/31/20130
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100