How to Create a Content Calendar From a Blank Spreadsheet: 12 Columns That Actually Matter

To create a content calendar, open a blank Google Sheet, pick how often you’ll publish, then give every date one keyword and one search intent before you write anything. Add only the columns that change a decision. That’s the whole method.

Most content calendars die the same way. They get built to look organized, and nobody ever ships from them. This is the version I’d build if I were starting a small business blog from zero today.

Key takeaways

• Lock your publishing cadence before you plan a single topic. Cadence sets your quota.
• Keep 12 columns. Every one of them should change what you write, when you publish or how you judge the result.
• One keyword and one intent per row. Google the keyword before it gets a date.
• Plan 4 to 6 weeks in detail. Sketch the rest of the quarter in pencil.
• A 15-minute weekly review is what keeps the calendar honest.

How do you create a content calendar from a blank spreadsheet?

You go from an empty sheet to your first scheduled post in three moves: pick a tool, lock a cadence, then fill one month of dates before you write a word. The order matters. Your cadence decides how many topics you need, so planning topics first is how people end up with 40 ideas and zero posts.

Step 1: Use Google Sheets

A spreadsheet is free, easy to share and easy to change when your process changes. It will change. Dedicated planning tools come with features you don’t need yet, and every one of them is another thing to maintain.

Open a blank sheet and name the first tab “Calendar.” That’s your setup.

There’s a reason I’m biased here. The first content system I ever built, back when I was trying to rescue a company’s search traffic, was a Google Apps Script with RSS feeds hard-coded into it. It was ugly and it worked. (That story is how I accidentally built an AI blog writer.) Google’s tools are a perfectly good place to start.

Step 2: Pick your cadence before your topics

One post a week is realistic for a solo owner. That’s four or five dates a month, about 13 a quarter. Now you know exactly how many topics you need, and you can stop brainstorming once you have them.

If one a week sounds like too much, pick every other week. A slower cadence you actually keep beats a fast one you abandon in March.

Step 3: Fill the first month before you write anything

Put one topic on each date for the next four weeks. Pick topics your customers actually search for and that you can answer better than the current results. Google’s own guide to creating helpful, reliable content is a good gut check here: would someone who found your post feel like they got what they came for?

Stuck on ideas? Start with the questions customers ask you on the phone. They’re almost always better topics than anything a brainstorm produces, and question-style posts are the kind AI answer engines like to cite.

What columns should a content calendar spreadsheet include?

A content calendar spreadsheet needs 12 columns: publish date, status, target keyword, working title, search intent, funnel stage, internal links, URL slug, word count target, owner, call to action and result notes. Every column should change a decision about what you write, when you publish or how you judge the result. If a field never does that, cut it.

The 12 columns that earn their place

ColumnWhy it’s therePublish dateYour cadence lives or dies hereStatusPlanned, Drafting, Editing, Scheduled, Published or DroppedTarget keywordTies the date to something people actually searchWorking titleFree to change while you writeSearch intentHow-to, comparison, pricing or problemFunnel stageKeeps you from writing only beginner postsInternal linksForces you to plan links before you publishURL slugLocks your structure earlyWord count targetSets the scope so a post doesn’t eat your weekOwnerEven on a team of one. Future you counts.CTAEvery post gets one jobResult notesRankings, clicks, what to repeat

Columns to skip until you need them

Skip the backlink tracker, social captions, designer assignments and revision history. They look productive and go stale by week three.

My rule: add a column the day a missed step causes a real problem. I learned the same lesson the hard way with Draftly itself, when too many settings made it harder to use and I cut it down to one business per account.

How do you map keywords to calendar slots?

Give each row one primary keyword and one intent label. A post chasing “content calendar template” and “B2B content strategy” at the same time serves two different search results badly. If two rows land on the same keyword and intent, merge them or cut one before you spend an hour outlining.

Check the keyword before it gets a date

Every keyword has to pass three checks before it earns a row:

1. Google it and read the first page. (Want rough search volume too? Google Keyword Planner is free with a Google Ads account, and Google Trends shows whether interest is growing or fading.) If the results are all giant brands, directories or marketplaces, one blog post from a small business probably won’t break in. Pick a narrower phrase.
2. Make sure the intent matches what you sell. Traffic from people who will never buy from you is a vanity metric.
3. Check what you already have. If you’ve written about the topic before, open the Performance report in Google Search Console and look at that page’s impressions and clicks. Then decide whether to rewrite it, merge it or leave it alone.

The third check is the one people skip, and it’s usually the fastest win. A keyword where your site already gets impressions is one Google already connects to you. A big keyword you’ve never shown up for is starting from zero, and volume tools make it look much easier than it is for a small site.

If you want help finding topics, Draftly pulls trending articles from your industry into a Blog Inspiration panel, and each one turns into a post with a click. You still decide which ones get a date. If you work in Claude or ChatGPT, the Draftly SEO MCP server can pull keyword data and your topic pipeline right into the chat.

How far ahead should you plan blog content?

Plan 4 to 6 weeks in full detail: keyword assigned, outline started, publish date locked. Sketch the rest of the quarter loosely, with a handful of topics and keywords per month and nothing more. Your search data and your priorities will shift enough in 90 days that detailed plans that far out turn into fiction.

Why a 12-month calendar fails

A 52-title calendar feels amazing for about a week. Then week three slips, every date behind it slips too, and the sheet becomes a guilt list. You stop opening it.

A short detailed window forces you to re-plan often. That’s a feature. Each new plan gets to use what you learned from the last few posts.

What does a weekly publishing workflow look like for one person?

One post a week fits into five short work sessions: outline Monday, draft Tuesday, edit Wednesday, on-page SEO Thursday and publish Friday. Splitting it up keeps any single day from turning into a four-hour writing marathon, and it gives you a natural checkpoint if something slips.

• Monday: pick the next keyword from the calendar. Read the top three results and outline your post.
• Tuesday: write the first draft.
• Wednesday: edit. Add your own examples, numbers and opinions. Fact-check every claim.
• Thursday: on-page work. Google publishes plain-English guidance on each piece: titles, meta descriptions, URL slugs, internal links and images.
• Friday: publish or schedule it. Then spend an hour updating one older post.

How long does the writing part take? Orbit Media’s 2026 blogging survey of 1,042 content marketers puts the average time to write a blog post at 3 hours and 20 minutes. That’s Tuesday, and it’s the day most people quit on.

Where AI drafting fits, and where you still edit

AI belongs on Tuesday. Not every model writes equally well, so I keep a running comparison of the best AI for writing. Draftly turns a topic into a first draft in your brand voice in a couple of minutes, with the slug, meta title and meta description already written, and it can publish straight to WordPress, Shopify, Webflow, Ghost, Squarespace or HubSpot. On WordPress there’s also a Draftly plugin that suggests edits right inside your posts.

Wednesday is still yours. AI drafts on technical, medical, legal or money topics need a real fact-check, and generic AI copy has tells readers notice (I wrote up the copywriting rules Draftly checks every draft against). Budget the same editing time you would for a human writer’s draft.

How do you choose content formats for each slot?

Look at the search results for each keyword and copy the format that’s already winning. If the top results are step-by-step guides, write a how-to. If they’re “X vs Y” pages, write a comparison. If they’re lists, write a list. Picking the format first and then hunting for a keyword to fit it is how posts end up never ranking.

A simple 70/20/10 split

• 70% how-to posts on specific, longer keywords you can realistically win.
• 20% comparison and “alternative to” posts. These catch people who are close to buying.
• 10% opinion pieces and lists that show your personality and give you something to share.

Treat the split as a starting point. If comparison posts start pulling traffic, shift the ratio next month.

When should you cut or merge a planned post?

Check the calendar once a month for posts that no longer earn their slot. Cut or rewrite a planned post when the search results shifted to a different intent, when a competitor already published a much stronger version, or when it no longer connects to something you sell. Killing a post before the draft is the cheapest edit you’ll ever make.

Write the kill rule into the sheet

Add “Dropped” as a status. In Google Sheets, an in-cell dropdown keeps everyone using the same six statuses, and conditional formatting colors each one so you can see the state of your month at a glance. If a row sits untouched for two monthly reviews, or the keyword turns out to have almost no searches, mark it Dropped and give the date to something better. Don’t delete the row. Your Dropped list tells you which ideas looked good and weren’t.

When to merge two posts into one

If two planned posts return mostly the same Google results, they’re the same post. Keep the stronger title, use the longer outline, fold the other post’s points in as subheadings and free up a date. One complete post beats two thin ones competing with each other.

How do you keep a content calendar alive after the first month?

Run a 15-minute review once a week and update the status column as you work. Most calendars die around week five because the plan lives in one place and the work happens somewhere else. When the sheet always matches reality, you keep opening it.

The 15-minute weekly review

Pick a day, set a timer and answer three questions:

1. What shipped last week?
2. What’s slipping this week, and what’s its new date?
3. Do the next two topics still match what’s ranking?

Move anything late the same day. The calendar should never lie to you.

Automate the boring parts

Finding topics, writing first drafts and formatting are the hours that kill consistency. That’s the part of the job I built Draftly to take off your plate. The Solopreneur plan is $29 a month and covers about 66 posts, and your first post is free. Keep the spreadsheet as your source of truth either way. Let the tool fill the dates while you decide what deserves them.

Want the template? Import the starter CSV into Google Sheets (File, then Import) and you’ll have all 12 columns ready to go.

How do you plan your posts right now? I’m genuinely curious what’s working for people.

FAQ

How do I make a content calendar in Google Sheets?

Open a blank Google Sheet, name a tab Calendar and add columns for publish date, status, target keyword, working title, search intent and owner. Decide your cadence first, then put one keyword on each publishing date for the next four to six weeks. Add more columns only when a missed step causes a real problem.

How far in advance should I plan blog content?

Plan 4 to 6 weeks in full detail, with the keyword, outline and publish date locked. Sketch the rest of the quarter loosely as topics and keywords per month. Detailed plans beyond about 90 days tend to fall apart, because your search data and business priorities change.

How often should a small business publish blog posts?

One post a week is realistic for a solo owner who splits the work across the week: outline, draft, edit, on-page SEO and publish. If that’s too much, publish every other week. Pick a cadence you can keep for a full quarter, because a steady pace you hold is worth more than a fast start you abandon.

What should a content calendar include?

A content calendar should include 12 columns: publish date, status, target keyword, working title, search intent, funnel stage, internal links, URL slug, word count target, owner, call to action and result notes. Each column should change a decision about what you write, when you publish or how you judge results.

How do I stick to a content calendar?

Run a 15-minute weekly review: check what shipped, reschedule what slipped and confirm the next two topics still match what’s ranking. Update the status column as you work. Plan only 4 to 6 weeks in detail so one late post doesn’t push your whole year off track.