Free Social Media Content Idea Bank Template

Get the template

Download the CSV, copy it straight into Google Sheets or Excel, or print it. Everything below is rendered on this page — nothing is hidden behind a form.

Template preview

The full template, shown in full — these are the exact columns and a few illustrative example rows.

Add one row per raw idea the moment it strikes. Triage later — sort by Priority, then move "Scheduled" ideas into your content calendar.

What's inside

Idea / topic

The raw idea in a few words — a question a customer asked, a topic, a headline. Capture it fast and messy; you can sharpen it later when you draft.

Hook / angle

The reason someone stops scrolling — the contrarian take, the promise, the curiosity gap. The same topic can yield several ideas with different hooks, so give each its own row.

Pillar

Which content theme the idea serves (e.g. Education, Brand story, Social proof, Community). Tagging the pillar keeps your backlog balanced so you do not end up all-promotion.

Best format

The format the idea suits best — Reel, carousel, short video, single image, text post, Pin. A guide, not a rule; one idea can be repurposed across several formats.

Priority

How strongly you want to make this one — High, Medium or Low. Sort by Priority to decide what to draft next instead of working in capture order.

Status

Where the idea is in your pipeline: Idea → Drafting → Scheduled → Used. Filter by status to see the backlog versus what has already shipped.

How to use this template

1. 1

   Get the idea backlog

   Download the backlog as a CSV for Excel, Google Sheets or Numbers, or copy the grid straight into a sheet — no import dialog and no account. Keep it somewhere you can add to it the moment an idea strikes.

2. 2

   Clear the sample rows

   The example rows show how each column is used and that ideas are placeholders, not real metrics. Delete them once the format is clear and start with a blank backlog.

3. 3

   Capture ideas as they come

   Add one row per idea the instant it strikes — a customer question, a competitor post, a shower thought. Fill in the hook and pillar; leave format, platform and source blank if you are not sure yet.

4. 4

   Triage by pillar and priority

   Once a week, tag any untagged ideas with a pillar and a priority, then sort by Priority so the strongest ideas float to the top of your drafting queue.

5. 5

   Promote ideas into your calendar

   When an idea is ready, set its status to Scheduled and move it into the Content Calendar template with a real date and platform — the idea bank feeds the calendar.

6. 6

   Schedule the finished posts in SocialKit

   Once you have drafted the post, schedule and cross-post it to your networks from SocialKit — check the platform to see whether it auto-publishes or sends you a publish notification before relying on full automation.

Best practices

• Capture first, judge later — get the idea into a row before you decide if it is any good. A full backlog beats a blank calendar every time.
• Give each hook its own row. One topic with three different angles is three ideas, not one — and the angle is usually what makes a post work.
• Keep the pillar mix balanced as the backlog grows so you always have education, brand-story and social-proof ideas ready, not just promotions.
• Mine real sources for ideas — customer questions, support tickets, comments and competitor posts — and paste the link in the Source column so you can find it again.
• Pick format as a starting point, not a cage. As of June 2026 most networks support several formats, and one strong idea can become a Reel, a carousel and a text post.
• Run a weekly triage: sort by Priority, promote the top few into your calendar, and let the rest wait — the backlog is allowed to be bigger than your schedule.

Do it in SocialKit