FR, version française
Home / Blog / SEO / Editorial calendar: method and free template

Editorial calendar: method and free template

An editorial calendar sets, for each piece of content, the topic, the channel, the date, the owner and the progress status. This guide details the 15 columns of a free Excel template, the seven-step method, the official sources for key dates (public holidays and sales in France, UN international days) and how to schedule updates. It compares tools (spreadsheet, Notion, Trello, Asana) with their limitations and shows a completed example.

Key takeaways

An editorial calendar is the table that sets, for each piece of content, the topic, the channel, the publication date, the owner and the progress status. It turns a content strategy into dated decisions, sized to your real resources. According to the Content Marketing Institute, 39% of the B2B marketers surveyed cite a lack of resources among their top three challenges.

  • Useful columns: only those that serve a decision (date, channel, topic, goal, owner, status, result).
  • Verified key dates: public holidays, sales periods and international days are taken from official sources.
  • A simple tool: a spreadsheet is enough to start; project management tools add views, sometimes paid ones.

Free template: editorial calendar (Excel, in French)

Our downloadable editorial calendar template (spreadsheet in French) is an Excel file (.xlsx) with no macros. It contains the 15 columns described below, drop-down lists for the channel, goal and status, a frozen header row and three fictitious example rows to delete.

What is an editorial calendar?

An editorial calendar, or editorial schedule, lists the content an organization plans to publish, with its date and channel. Each row describes one piece of content: what it says, where it appears, when, for whom, who produces it and how far along it is.

Definition

The editorial calendar answers six questions for each piece of content: what, where, when, for whom, by whom and at what stage. It covers every channel where the organization publishes: blog, newsletter, social networks, video.

It sits at the end of a chain of decisions. The strategy sets the goals, targets and channels. The editorial line sets the themes, tone and formats. The calendar turns them into dated publications: the calendar is how you steer your content strategy week after week.

Having a strategy is not enough to stick to it. In the Content Marketing Institute survey published on October 8, 2025, 97% of B2B marketers say they have a content strategy. Yet a third (33%) rank measuring content effectiveness among their top three challenges. The calendar makes visible what the team can really produce and what each piece of content delivered.

39%

of the B2B marketers surveyed cite resource constraints (time, people, budget) among their top three content marketing challenges.

Content Marketing Institute and MarketingProfs, survey conducted from June to August 2025 among 1,015 B2B marketers, mostly North American, published on October 8, 2025.

What should an editorial calendar include?

Put in the calendar the information used to decide or act, and nothing else. A column nobody fills in ends up making the whole table unreliable. The template offered at the top of the page has 15 columns.

Basic rule: one row = one piece of content on one channel. An article repurposed in the newsletter and then on LinkedIn takes up three rows, with three dates and sometimes three owners.

Template columnWhat it is forWhat goes in it
Publication dateOrder and sortThe planned go-live day
ChannelSpread the workload across mediaList: Blog, Newsletter, LinkedIn, Instagram, Facebook, YouTube, Other
FormatEstimate the production effortArticle, carousel, video, email
Topic (working title)Say what the reader learnsA sentence, not a keyword
ThemeCheck the balance of the editorial lineOne of the selected themes
GoalLink the content to a resultList: Awareness, Traffic, Conversion, Retention
TargetWrite for a specific readerPersona or segment
Target keyword or URLAvoid two pieces of content on the same queryThe target query, or the existing URL to enrich
OwnerKnow who to follow up withA single person
Draft due onLeave time for reviewA date before publication
StatusSee progress at a glanceList: Idea, To write, Writing, In review, Approved, Scheduled, Published, Postponed
Key dateJustify a fixed dateThe key date and its source
Published linkFind the content againThe final URL
Indicator and resultLearn from each publicationAn indicator tied to the goal, recorded on a set date
Next updateKeep evergreen content aliveA review date

Tip

The “Target keyword or URL” column applies a simple rule: one search intent, one page. Before planning an article, check that no page on the site already targets the same query. If one does, plan an update of that page instead.

If you work alone, four columns are enough to start: date, channel, topic, status. Add the others when a question keeps coming back unanswered, for example “who is handling this?” or “what did this content deliver?”.

How do you create an editorial calendar?

An editorial calendar is built in seven steps, from the editorial line to the monthly review. We recommend planning a quarter ahead for heavy content and a month ahead for the rest.

  1. Editorial line: themes, tone, formats and excluded topics. Without it, the calendar fills up with random ideas: start by defining your editorial line.
  2. Capacity: how many pieces of content the team can produce, review and distribute each month. This number sets the pace, whatever volume others publish.
  3. Key dates: holidays, sales periods, industry events, launches. These are the only fixed dates; everything else is organized around them.
  4. Channels and pace: one pace per channel, which the team can keep up steadily. For social networks, the same file serves as a social media publishing calendar. The newsletter and email campaigns also have their rows, so that an email and a post do not announce the same thing on the same day.
  5. Quarter to fill in: topics, formats, owners, draft deadlines. Leave one free slot per month for unexpected news.
  6. Up-to-date statuses: every status change is recorded the same day. A “Postponed” status is better than an overdue date with no explanation.
  7. Monthly review: record the results, reschedule what slipped, fill in the following month and schedule the review of content that is aging.

Where can you find reliable key dates?

Take dates from their official source, not from a list of recurring seasonal topics copied from one year to the next.

  • Public holidays in France: Service Public, the French government information site, publishes the table for the year. In 2026, the general case has 11 public holidays; Alsace-Moselle adds two, Good Friday and December 26 (Service Public, page checked on January 1, 2026).
  • Sales in France: two legal periods of four weeks, on dates set by ministerial order. Winter sales start on the second Wednesday of January at 8 a.m., or on the first Wednesday if the second falls after the 12th. Summer sales start on the last Wednesday of June (Service Public, page checked on January 21, 2026).
  • International days: the UN publishes the list of international days and weeks, month by month; most refer to the resolution that created them. Before devoting content to a “world day” that is not on this list, check who launched it.

Warning

In France, “soldes” (sales) is a regulated name. A Black Friday operation is a promotion. Service Public cites “black friday” among the names allowed for a promotion, which cannot be called “soldes”. Name it correctly in your content.

Schedule updates

An editorial calendar also schedules reviews. A guide that ages loses value: the “Next update” column puts its review in the calendar, like a publication.

Google warns against the opposite excess. In its self-assessment questions, it mentions changing the date of a page when its content has not changed significantly. It also states that adding or removing a lot of content to seem “fresher” does not work (Google Search Central, page updated on December 10, 2025).

Key point

A scheduled update changes the substance: figures, examples, sources, sections. Then display the date with a “Last updated” label. Keep it consistent with the dateModified field in the structured data, as recommended by Google’s documentation on publication dates.

Which tool should you choose for your editorial calendar?

Choose the tool the whole team will open without effort. Alone or as a pair, a spreadsheet is enough. Beyond that, a project management tool adds calendar views and comments, with limitations to check before choosing.

ToolWhat it offersLimitation noted on September 26, 2026
Spreadsheet (Excel, Google Sheets)Drop-down lists, sorting, filters, sharingNo reminders in our template: updating relies on the team
NotionCalendar view on a databaseThe database must contain a Date property (Notion help)
TrelloBoards of cards with start and due datesCalendar view reserved for the Premium and Enterprise plans, not available to date for free workspaces (Trello help)
AsanaEditorial calendar template, deadlines shown in the Calendar view, custom fields for status and content typeSign-up required to use the template (Asana template page)
CanvaCreating visuals for postsOfficial page could not be accessed on September 26, 2026: scheduling features not checked here

To decide, ask three questions. Who needs to see the calendar? Do you need automatic reminders? Is the view you need included in the free plan? If the answer to the third is no, a shared spreadsheet often remains the simplest solution.

Editorial calendar example

This example is fictitious. Maison Grain, an imaginary roaster that sells its coffee online, publishes on its blog, its newsletter and LinkedIn. Here is an extract of its calendar from October to December 2026, reduced to six columns.

DateChannelTopicGoalStatusKey date
Thu. October 1, 2026LinkedInA morning at the roasting workshopAwarenessScheduledInternational Coffee Day (UN)
Tue. October 6, 2026BlogWhich coffee grind for which coffee maker?TrafficIn reviewNone
Thu. October 8, 2026NewsletterThe grind guide, in shortRetentionTo writeNone
Tue. November 10, 2026BlogGift ideas for coffee loversTrafficIdeaChristmas (December 25)
Fri. November 20, 2026NewsletterEnd-of-November offer, presented as a promotionConversionIdeaBlack Friday
Thu. December 3, 2026LinkedInOrder before Christmas: shipping deadlinesConversionIdeaChristmas (December 25)
Tue. April 6, 2027BlogUpdate of the grind guideTrafficIdeaSix-month review

What this example shows:

  • The October 6 article is repurposed in the newsletter two days later: two rows, two dates, two statuses.
  • The fixed dates (coffee day, end of November, Christmas) are set first; in-depth topics fill the free weeks.
  • The Christmas article comes out six weeks before the holiday, to give readers time to plan their purchases.
  • The end-of-November offer is called a “promotion”, never “soldes” (sales).
  • The review of the guide is scheduled like a publication.

The first three rows appear in full, with their 15 columns, in the template offered at the top of the page.

Frequently asked questions

What is editorial content?

Editorial content informs, explains or entertains without asking for a purchase first: article, guide, newsletter, video, podcast, post. It differs from promotional content, which highlights an offer. Both can coexist in an editorial calendar; the Goal column separates them: awareness, traffic or retention on one side, conversion on the other.

What are the 5 types of editorial calendars?

There is no official classification. Five can be distinguished by horizon and scope. The annual calendar sets the key dates, the quarterly one the in-depth topics, the monthly one production. The weekly schedule organizes publication, and a calendar specific to one channel, such as social networks, completes the set. In a small team, a single file brings them together: you filter it by date or by channel.

Should an editorial calendar be in Excel or PDF?

Prefer a spreadsheet. A PDF can be read but not edited, whereas a calendar changes every week: statuses, postponed dates, results. A PDF is used to share a frozen view, for example the quarter’s program for management. Our template is in Excel format (.xlsx), with no macros, with drop-down lists and filters.

How far in advance should you plan your content?

It all depends on the production time. A long guide, a video or a white paper takes several weeks between the brief and publication: plan them a quarter ahead. Posts and the newsletter are planned a month ahead. Then review the following month at each monthly review of your editorial calendar.

Sources

  1. Content Marketing Institute (Robert Rose), 9 Takeaways and Insights From the 2026 B2B Content and Marketing Trends Report, October 8, 2025. Accessed on September 26, 2026.
  2. Google Search Central, Creating helpful, reliable, people-first content, updated on December 10, 2025. Accessed on September 26, 2026.
  3. Google Search Central, Influence your byline dates in Google Search, updated on December 10, 2025. Accessed on September 26, 2026.
  4. Service Public, Public holidays and bridge days in the private sector (in French), checked on January 1, 2026. Accessed on September 26, 2026.
  5. Service Public, Sales: rules to follow (in French), checked on January 21, 2026. Accessed on September 26, 2026.
  6. United Nations, List of international days and weeks (in French), date not displayed. Accessed on September 26, 2026.
  7. Notion Help Center, Calendar view databases in Notion (in French), date not displayed. Accessed on September 26, 2026.
  8. Atlassian Support, Calendar view (Trello), date not displayed. Accessed on September 26, 2026.
  9. Asana, Free editorial calendar templates (in French), 2026. Accessed on September 26, 2026.
Baptiste Clair Avatar

Digital marketing, SEO and GEO consultant

More about the author

Article checked and updated by the author. Sources consulted on the date shown.

Cite this article

Clair, B. (2026, September 27). Editorial calendar: method and free template. Elev8 Lab. https://elev8-lab.fr/en/content-marketing/editorial-calendar/