Content calendar generator
Paste your topics, set a cadence, and take away a real spreadsheet with dates already filled in rather than an empty grid you still have to plan.
templateYou leave with: An .xlsx or CSV calendar with dates, owners, formats and a status column
| Date | Week | Title | Format | Owner | Keyword |
|---|
Add a topic on the left and the calendar builds itself.
Why the dates are the point
An empty calendar template is a grid with column headings, and the reason it usually ends up abandoned in a shared drive is that it leaves the genuinely hard decision — what runs in which week — exactly where it was. Filling that in by hand is the part everyone postpones, so the template stays empty and the team goes back to deciding each piece the week it is due.
This starts from the topics you already have and lays them onto real dates at the cadence you can actually sustain. What you download is committed to specific days, which changes the conversation from whether to publish weekly to whether the eleventh of next month is right for the pricing guide. That is a much easier question to answer, and a much harder one to avoid.
Picking a cadence you will keep
Most teams choose their cadence by ambition and then miss it by March. The useful test is to count the pieces published in the last ninety days, divide by thirteen, and start there. A weekly cadence that holds for a year beats a three-a-week cadence that stops in week six, because search results reward the accumulated library rather than the burst that built part of it.
If the honest number is below one a week, take the biweekly option and use the recovered time on length and depth. Two thorough pieces a month outperform eight thin ones on almost any measure that matters, and thin content is the specific thing search quality systems exist to demote.
What belongs in each column
- Title — a working title, not the final one. It will change once the piece is written and that is fine; its job here is to be recognisable in a list.
- Keyword — the single phrase the piece is meant to answer. One per row. If two rows have the same keyword you have found a duplication problem before it shipped rather than after.
- Format — what the thing physically is, because a guide and a newsletter take different amounts of the same week.
- Owner — a person, never a team. Work assigned to a team is work assigned to nobody.
- Brief — one sentence naming the question answered and the reader it is answered for. This is the column that stops three people writing the same article three ways.
- Status — deliberately left free rather than a dropdown, because every team already has words for its own stages and importing someone else's is how a calendar starts feeling like homework.
After it is published
A calendar tracks whether things went out; it says nothing about whether the pages that went out can actually be read by the systems you published them for. That needs something to fetch the live URL, which a browser tab is not permitted to do. Thefree checkers on visibility100x.com run that fetch server-side and report what search engines and AI assistants can extract from a page once it is live.
Questions
How is this different from downloading a blank calendar template?
A blank template gives you column headings and leaves the hard part — deciding what runs when — entirely to you. This takes the topics you already have and distributes them across real publication dates at the cadence you choose, skipping weekends if you ask it to, so what you download is a plan rather than a grid.
Will the .xlsx open in Google Sheets?
Yes. The file is a standard Office Open XML workbook, which Sheets imports directly through File then Import. If you would rather skip the conversion step, take the CSV instead: Sheets opens it natively and the column structure is identical.
What should go in the brief column?
One sentence naming the question the piece answers and the reader it answers it for. Its job is to stop the same topic being written three different ways by three different people, so the useful version is specific enough to argue with. "Guide to schema" is not a brief; "how a developer adds Product schema to a Shopify theme without an app" is.
Does the calendar handle more than one channel?
The format column carries it. Set a topic to video, newsletter or landing page and it keeps its slot in the same date sequence, which is usually what you want, because the constraint being planned around is the team's week rather than the channel.
The other four