Social media content calendar: free Excel template and example

A social media content calendar is a table with one row per piece of content: date, channel, topic, goal and language. The template below has these columns, drop-down menus and a sample month. Fill it in with Excel or Google Sheets, no account needed.

AICREA editorial team

Download the Excel template

Which columns does the template have?

Seven, two of them required. Channel, goal and language are picked from a menu, so the plan stays tidy even when many people fill it in.

Which columns does the template have?
ColumnRequiredWhat to write
DatenoThe publishing day, in the format 2026-12-01.
ChannelyesOne of the 12 channels in the menu: Instagram, Facebook, LinkedIn, X (Twitter), Newsletter, Push Notification, Pinterest, Snapchat, TikTok, WhatsApp, Blog Post, YouTube.
TopicyesWhat the piece is about, in one sentence.
GoalnoOne of the 8 in the menu: Product Launch, Brand Awareness, Engagement, Educational, Storytelling, Conversion, Community, Lead Generation.
LanguagenoThe language of the piece, among the 13 in the menu.
ImagenoThe link to the image, if you already have one. It can be added later.
NotesnoDirections for the writer: an offer, a tone, what to avoid.

The template has no column for the text of the post, because it is made for AICREA, which writes it. If you use it by hand, add the columns Text and Status.

A sample month

The file comes with this month already filled in, for a coffee roaster that sells online. Two posts a week, different channels and goals, no empty week.

A sample month
WhenChannelTopicGoal
Week 1, MondayInstagramHow to choose the grind for a moka potEducational
Week 1, ThursdayNewsletterThe month's three blendsProduct Launch
Week 2, TuesdayLinkedInWhy we buy green coffee directly from growersStorytelling
Week 2, FridayInstagramBehind the scenes of roastingEngagement
Week 3, MondayFacebookCoffee tasting class at the roastery, SaturdayConversion
Week 3, ThursdayTikTokThree mistakes that ruin a homemade espressoEducational
Week 4, TuesdayInstagramCustomers' photos with our cupsCommunity
Week 4, FridayBlog PostEthiopia, Brazil, Colombia: where our coffee comes fromBrand Awareness

How do you fill it in?

  1. Choose the channels and how many posts a week to make on each. For Instagram, the data is in the guide How often to post on Instagram.
  2. Mark the fixed dates first: launches, sales, events, the key dates of your industry.
  3. Fill the other dates with one topic and one goal per row, alternating the goals.
  4. Write in the notes what the writer needs to know: the product, the offer, what not to say.
  5. Check that no week is left empty: regularity matters more than the number of posts.

From plan to content

Upload the completed file to AICREA: for each row it writes the piece in the channel's format and the brand's voice, up to 2,000 rows per plan. Then you approve the texts and schedule them. If you'd rather start from scratch, AICREA proposes the plan from the brand identity.

Frequently asked questions

Do I need an account to download it?

No, it's free and needs no sign-up.

Does it open in Google Sheets?

Yes: upload it to Google Drive and open it with Sheets.

How many rows can AICREA import?

Up to 2,000 per plan. For longer plans, split them into several files.

Can Claude or ChatGPT fill in the template?

Yes, it is a good way to get a first list of topics. Then upload the file to AICREA, which writes each row in its channel's format and in the brand's voice.

Read the guide: AICREA or an AI assistant

Where does your brand start from?

Take the free analysis: one minute, no sign-up. Or start creating content right away.

AICREA editorial team