Social media content calendar template generator

How the posts are spread across the week

Each channel gets its own weekly count, and the generator spreads those posts as evenly as it can across the days you ticked. With Monday to Friday ticked, 3 posts a week land on Monday, Wednesday and Friday, 2 land on Tuesday and Thursday, and 1 lands on Wednesday. Weeks run Monday to Sunday. A part week at the start or end of your range keeps only the days that fall inside it, so nothing is squeezed in to make up the count.

A worked example with the default settings. Four full weeks, from Monday 2 November to Sunday 29 November 2026, with Instagram at 3 a week, TikTok at 3 and LinkedIn at 2:

• Instagram: 3 × 4 weeks = 12 posts, every Monday, Wednesday and Friday at 12:00.
• TikTok: 3 × 4 = 12 posts, the same days at 18:00.
• LinkedIn: 2 × 4 = 8 posts, Tuesdays and Thursdays at 09:00.

That is 32 posts. Add four content pillars and each pillar comes up 32 ÷ 4 = 8 times, because the pillars are handed out in turn down the list, sorted by date, then time, then channel.

A channel only posts once a day here. If you ask for 5 a week and tick 3 days, you get 3, and the tool tells you so rather than doubling up.

Content pillars, and why rotation beats memory

A pillar is one of the three to five things your brand keeps talking about: the product in use, a customer story, how it is made, a tip. Writing them down and rotating them does one job: it stops the plan from quietly becoming the same post every week. The pillar in each row is a prompt, not a finished idea. The CSV has an empty Post idea column for the idea itself and a Status column that starts at Planned, so the file can be the working plan and not just a list of dates.

The two files

The CSV opens in any spreadsheet. It follows RFC 4180, the common CSV format: records end in CRLF, and a field that contains a comma, a double quote or a line break is wrapped in double quotes, with any double quote inside it written twice. So a pillar like Tips, how-tos and FAQs stays in one column instead of splitting into two.

The .ics file imports into calendar apps that read the iCalendar format, defined in RFC 5545. Each post becomes an event with a unique ID and a timestamp, which the standard requires on every event. Commas, semicolons and backslashes in the text are escaped, lines end in CRLF, and any line longer than 75 octets is folded onto the next line, as the standard asks.

The times are written as what RFC 5545 calls floating times: no time zone attached, so an event set for 12:00 shows at 12:00 wherever the calendar is. That is what you want when you plan in your own local time. If your team is spread across time zones, pick the times for the zone your audience is in.

What this tool does not do

It does not post anything, write the posts, or connect to your accounts. It does not know when your audience is online, so the default times are only a starting point: your own analytics are the better source. It makes one-off events, not repeating ones, so moving one post in your calendar does not move the rest. And it keeps nothing: close the tab and the plan is gone, so download the files first.

If you would rather not fill the calendar by hand

Hermoso is marketing on autopilot: it researches the ads already working in your market, makes on-brand image and video ads, and schedules the posts to your own accounts. Its social media scheduler lets you pick a minute for each post up to 365 days ahead, or drop posts into your brand’s posting queue, whose default slots are 09:00, 13:00 and 17:00. It works in the web app, through the API, or inside Claude, ChatGPT and Cursor through its MCP server.

Free tools: Caption length checker · Engagement rate calculator · UTM link builder

Frequently asked questions

How does the generator decide which days to post on?

Each channel's weekly count is spread evenly across the days you tick. With Monday to Friday ticked, 3 posts a week go on Monday, Wednesday and Friday and 2 go on Tuesday and Thursday. A channel posts at most once a day.

Can I import the calendar into Google Calendar, Apple Calendar or Outlook?

The .ics file follows RFC 5545, the iCalendar standard, so calendar apps that import .ics files can read it. Each post is a separate event at the time you chose.

What time zone are the events in?

None. They are floating times, which RFC 5545 defines as the same clock time in whatever time zone the calendar is in. A post planned for 12:00 shows at 12:00.

What are content pillars?

The few recurring themes your brand posts about, such as the product in use, customer stories, behind the scenes and tips. Type one per line and the generator hands them out in turn, so with 32 posts and 4 pillars each pillar comes up 8 times.

Does the tool post for me?

No. It builds a plan and two files. Nothing is posted, nothing is connected to your accounts, and nothing is saved, so download the files before you close the page.