Marketing template
Editorial calendar
Plan magazine or newsletter issues with copy and design deadlines worked back from each publish date. Stories roll up into readiness per issue.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
2 sheets
- Issues
- Stories
90 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 206 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Live dates
- Frozen headers
- 1 chart
A look at the Issues sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Editorial calendar | |||||||
| 2 | Deadlines are counted back in working days: copy 15 days and design 7 days before publishing. | |||||||
| 3 | Copy lead (days) | 15 | Design lead (days) | 7 | ||||
| 4 | ||||||||
| 5 | Issue | Theme | Publish | Copy deadline | Design deadline | Phase | Days to go | Stories |
| 6 | No. 40 | Second chances | Oct 1, 2026 | Sep 10, 2026 | Sep 22, 2026 | Published | 0 | 0 |
| 7 | No. 41 | The night shift | Nov 2, 2026 | Oct 12, 2026 | Oct 22, 2026 | Published | 0 | 3 |
| 8 | No. 42 | Small rooms, big ideas | Dec 1, 2026 | Nov 10, 2026 | Nov 20, 2026 | Editing | 17 | 4 |
| 9 | No. 43 | Cold weather cooking | Jan 4, 2027 | Dec 14, 2026 | Dec 24, 2026 | Writing | 51 | 2 |
| 10 | No. 44 | Local makers | Feb 1, 2027 | Jan 11, 2027 | Jan 21, 2027 | Writing | 79 | 1 |
| 11 | No. 45 | Repair culture | Mar 1, 2027 | Feb 8, 2027 | Feb 18, 2027 | Writing | 107 | 0 |
| 12 | ||||||||
- editorial
- publishing
- magazine
- deadlines
More marketing templates
MarketingMarketing campaign trackerCompare campaigns by spend, clicks, leads and revenue with click rate, cost per lead and return calculated for you. Channel totals feed a chart.
MarketingSocial media calendarSchedule posts by date, time and channel, then log likes, comments and shares once they go live. Today is highlighted and a summary ranks channels by engagement.
MarketingContent calendarRun your content pipeline from idea to published with owners, stages and deadlines. An Up next sheet lists what ships soonest.
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
Start your editorial calendar now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.