# Ads creative calendar Excel (free) + online

> Free Excel calendar for ad creative: track platform, format, owner, due and launch dates and status, with overdue and ready flags and a board by platform and…

Source: https://softwiro.com/blog/ads-creative-production-calendar-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Ads creative production calendar in Excel (free): deadlines, approvals and launches

Log each ad design or video once and see what is overdue, what is ready and what launches this week.

13 November 2026 6 min read

## In short

- Log each item once: platform, format, owner, due date, launch date and status.
- Days to due, overdue and ready flags are worked out for every item.
- Alerts for a format on the wrong platform, an unlisted owner or a launch before delivery.
- A board by status, platform and person. A log, not a link to your ad accounts.

Anyone who runs paid ads knows a late creative costs more than the creative itself: a video not approved before the offer starts, a banner exported at the wrong size, one designer with ten items while a colleague has two. The free [ads creative production calendar sheet](https://softwiro.com/templates/ads-creative-production-calendar) records every item with its platform, format, owner, due date and launch date and works out what is overdue and what is ready, so you see the whole pipeline on one page.

## The problem it solves

When items are tracked in WhatsApp messages and scattered files, nobody can quickly say what is late, what is approved and waiting to upload, who is overloaded, and what launches this week. Here you enter each item once in a row, and the sheet summarises the rest by status, by platform and per team member.

## Steps from opening the file to the board

1. Settings: enter today's date (or =TODAY() so it updates itself), the launch window in days, and the team names (up to 8) and platforms (up to 8). You will find a table of common formats for reference.
2. Production: log each item in a row: the name, the platform, the format from the list, the owner, the due date, the launch date and the status.
3. Update the status as the item moves: Idea, Designing, Review, Approved, Live or On hold, and paste the final file's link in the Link column.
4. Let the grey columns work: Days to due, "Overdue?", "Ready?", the alert and the Launch soon column.
5. Open the Board for counts by status and platform, each person's load and what launches soon. When a campaign ends, write what you learned in "Result note".

## Worked example (sample data)

The figures below are sample data for an imaginary home-appliances shop, with today's date as 13 November 2026. **39 items** were logged:

- By status: Idea 7, Designing 10, Review 7, Approved 5, Live 8, On hold 2.
- By platform: Meta 15 items, Google Ads 6, YouTube, TikTok and LinkedIn 5 each, and Snapchat 3.
- Overdue: 6 items. For example the feed ad "Winter collection" was due a day ago and is in Review, so it shows "overdue", and the YouTube video "Maintenance tips" is 6 days overdue.
- Ready to launch: 4 items, because they are approved with a link and a launch date. The Google banner "Free shipping discount" is approved but has no link, so it does not show "ready".
- Launching within 7 days: 11 items, 5 of them on Meta and 3 on LinkedIn.
- Team load: Karim Adel has 10 items (7 open), Mona Saeed has 9 (7 open, 2 of them overdue), and Heba Fathy has 8 (2 of them ready).
- Alerts: 3 items: a LinkedIn banner in a TikTok format shows "format does not belong to the platform", an ad whose owner "external freelancer" is not on the team list, and a Reel whose launch date is before its due date.

## How the numbers are worked out

- Days to due = due date − today. Due in 3 days = 3, a day ago = −1.
- Overdue: the due date has passed and the status is not Approved, Live or On hold.
- Ready: the status is Approved, with a link and a launch date.
- Launch soon: the launch date is between today and today + the window (7 days here), and the item is not Live or On hold.
- Open items per person = all their items except Live and On hold.

## Practical tips for ad production

- Formats: common ones are vertical 9:16 for Reels, Stories, TikTok and Snapchat, square 1:1 or 4:5 for feeds, landscape 16:9 for YouTube, and 1.91:1 for Google and LinkedIn banners. They change, so check each platform's advertiser page.
- The first 3 seconds: open with the problem or the result, make the first shot clear without sound, and test more than one hook for the same video.
- The safe zone: keep the top and bottom of vertical video clear because platform buttons cover them, and put key text in the middle.
- The creative brief: a short page with the goal, audience, message, format, dates and who approves cuts revision rounds.
- User-generated content (UGC): get written permission before using a customer's or creator's clip in an ad.
- Creative fatigue: when frequency rises and clicks fall over time, prepare a replacement. There is no magic refresh number; it depends on audience and budget.
- Naming and approval: a fixed file-name pattern (campaign_platform_format_idea_v2), and decide who has the final say.

## Limits and notes

- The formats in Settings are common sizes, not official specifications, and platform policies and interfaces change. Performance benchmarks differ by industry, and the sheet promises no result.
- The sheet does not check that the link works or that the file matches the format; it only checks the format name.
- It does not connect to your ad accounts, publish for you or send alerts; it is a log you keep by hand.
- Do not rename the six statuses because the calculations depend on them, and do not delete a row from the middle of the list.
- Pick the format from the list; an alert shows if the format belongs to another platform.

## Try it

[Open the sheet and try it online, or download it for Excel](https://softwiro.com/templates/ads-creative-production-calendar). It holds 600 items, 8 team members and 8 platforms. If you want an app where the team and the client follow approvals and deadlines, [ask for it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: ad creative production (1/4)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-1.jpg)[![Cheat sheet: ad creative production (2/4)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-2.jpg)[![Cheat sheet: ad creative production (3/4)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-3.jpg)[![Cheat sheet: ad creative production (4/4)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-4.jpg)](https://softwiro.com/uploads/cheatsheets/ads-creative-production-calendar/en-4.jpg)

0 downloads · 4 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I organise ad and design production in Excel?

Log each item in a row on the Production sheet with its platform, format, owner, due date, launch date and status. The sheet works out days to due, what is overdue and what is ready, and the Board shows counts by status, by platform and the load per team member.

### When does an item show as overdue and when as ready?

It is "overdue" if its due date has passed and its status is not Approved, Live or On hold. It is "ready" if its status is Approved and it has a link and a launch date. The sheet does not check that the link works or that the file matches the format.

### Are the formats in the sheet official?

No. They are common sizes (such as 1:1, 4:5, 9:16, 16:9 and 1.91:1), not binding specifications, and they change from time to time. Check each platform's advertiser page before exporting the final file.

### Does the sheet connect to my ad accounts or publish ads?

No. It is a log you keep by hand: it does not connect to your ad accounts, publish for you or send alerts. A custom app is what adds platform connections and client approvals.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
