With a spreadsheet, you can create dozens of posts at once. Each row in the sheet becomes 1 post. You can fill in the sheet yourself, or have an AI assistant like Claude or ChatGPT fill it in for you.
TIP: Set up your Buckets and Posting Plan first, so your queued posts have time slots to publish in.
In this article, you'll learn:
📋 What you can create with a spreadsheet
Each row can be any of these posts:
Text posts — a caption and nothing else.
Link posts — a caption plus a web page link (not on X).
Image, video or GIF posts — 1 media file per row, up to 200 media posts per sheet.
Pinterest Pins and YouTube videos — with their own title.
Facebook and Instagram Reels and Stories.
Facebook text-on-background posts (TOBI) — needs the Growth plan or higher.
And each row can also have:
A posting time — leave it blank to queue the post, or enter a date and time to schedule it.
A first comment — on Facebook, Instagram and LinkedIn, with an optional delay. Needs the Growth plan or higher.
You choose these when you upload the sheet, not in the sheet itself:
Profiles or a Bucket — every row becomes a post on each profile you pick, or goes into the Bucket you pick. To fill several Buckets, make 1 sheet per Bucket.
Top or bottom of your queue — where queued posts land.
🤖 How to fill your spreadsheet with AI
An AI assistant can write your captions and fill in every column for you, in the format Post Planner needs.
1. Download the sample sheet and the Post Planner skill
In the multi-post Composer, click "Download sample sheet" under the spreadsheet box (or download it here).
Then download the skill file from the Post Planner skill page. The skill tells your AI assistant how the sheet works, so it fills it in correctly and leaves the columns alone.
2. Add the skill to your AI assistant
Add the skill file to Claude or ChatGPT. It takes about a minute: see How to add the Post Planner skill to your AI.
3. Tell your AI assistant exactly what to make
Upload the sample sheet to your AI assistant. The more specific your request, the less you have to fix afterwards.
Tell it:
What to post — how many posts, the topic, your tone, and any links or offers to include.
Which networks — so it fills in titles for Pinterest and YouTube.
Queue or schedule — "leave POSTING TIME blank" to queue the posts, or give the exact dates and times, for example "1 post a day at 9:00 from December 1 to December 14".
Which Bucket the sheet is for — so the posts match that Bucket. You still pick the Bucket when you upload.
Your media links — paste your image or video links, 1 per post. Use your Library links (see the TIP below). Google Drive and Dropbox links don't work.
Comments, Reels and Stories — for example "add a first comment with a link to my shop, 10 minutes after the post" or "make every video a Reel".
Here are 3 examples you can copy and change:
"Use the Post Planner skill to fill in this sample sheet with 15 posts for my 'Baking tips' Bucket. They're for Facebook and Instagram. Leave POSTING TIME blank so they go into my queue. Use these 15 image links, 1 per post: [links]. Add a first comment on each post that asks a question, with no delay."
"Use the Post Planner skill to fill in this sample sheet with 14 posts for my bakery's holiday sale. Schedule 1 post a day at 9:00 from 12/01/2026 to 12/14/2026. They're for Facebook and LinkedIn. Put the sale page https://example.com/sale in the LINK column."
"Use the Post Planner skill to fill in this sample sheet with 10 Instagram Reels, 1 for each of these video links: [links]. Type 'reel' in REEL OR STORY. Leave POSTING TIME blank."
Ask for the finished sheet as an .xlsx file, and download it.
TIP: Host your images and videos in your Library. Tick the files, click "Bulk actions", then "Download links of selected", and give that list to your AI assistant.
4. Check the sheet before you upload it
AI assistants can make mistakes, so read through the sheet before you upload it:
Captions — read each one, and fix anything that is wrong or off-brand.
Media links — open a few to make sure each one shows the right image or video.
Posting times — blank to queue, or a future date and time in MM/DD/YYYY HH:MM format to schedule.
The sheet itself — it's the sample sheet, not a new sheet the AI built. The columns are still in the same order with the same names, the "BULK UPLOAD VERSION" cell at the top is unchanged, and the example rows are gone.
When the sheet looks right, upload it.
✍️ How to fill your spreadsheet by hand
1. Download the sample sheet
In the multi-post Composer, click "Download sample sheet" under the spreadsheet box. The top rows explain every column, and the rows under them are examples of each kind of post.
2. Replace the example rows with your posts
Each row is 1 post, and each column is a detail of that post. Every row needs a CAPTION, a LINK or a MEDIA link. Every other column is optional.
Delete any example rows you don't replace. Delete the whole row, not just its text: some example cells hold links that would upload with the row.
Here's what each column does:
Column | What goes in it | Rules |
POSTING TIME | Leave it blank to add the post to your queue or Bucket. To publish at an exact time, enter a date and time. | Format MM/DD/YYYY HH:MM (24-hour clock), for example 07/04/2030 14:30. Leave it blank if you upload to a Bucket. |
CAPTION | The post text. For Pinterest and YouTube, this is the description. |
|
LINK | The web page the post shares on Facebook, Threads, LinkedIn, Pinterest or Bluesky. For Pinterest, this is the Pin link. | Must not end in a file type like .jpg or .mp4. Post Planner doesn't support link posts to X. |
MEDIA | The link to the image, video or GIF. For Pinterest, this is the Pin image. | Must be a direct link that ends in the file type (.jpg, .png, .mp4, and so on). Google Drive and Dropbox links don't work, so use your Library links (see the TIP below). Keep the file online until the post publishes. Up to 200 media posts per sheet. |
TITLE | The Pin title or YouTube title. | Ignored on other networks. |
FIRST COMMENT | A comment that publishes after the post. | Facebook, Instagram and LinkedIn only. Needs the Growth plan or higher. |
FIRST COMMENT DELAY | How many minutes after the post the comment publishes. | Leave it blank to publish the comment right after the post. Must be less than 1,440 (24 hours). |
TOBI BACKGROUND | The name of a Facebook text-on-background-image background, for example "shapes". | Facebook only. Find the name by hovering over a background in the Composer's "Choose Background" picker. Needs the Growth plan or higher. |
REEL OR STORY | Type "reel" or "story". | Facebook and Instagram only. |
TIP: Host your images and videos in your Library. Tick the files, click "Bulk actions", then "Download links of selected", and paste those links into the MEDIA column. Don't delete a file from your Library until its post has published (or, for recycled posts, has stopped recycling).
IMPORTANT: Don't add, delete, rename or move any column, and don't change the "BULK UPLOAD VERSION" cell or the instruction rows at the top. Post Planner reads each column by its position, so any change makes the upload skip details or fail.
TIP: Prefer Google Sheets? Click File > Import to open the sample sheet there, fill it in, then click File > Download > Comma-separated values (.csv) and upload the .csv file.
📤 How to upload your spreadsheet
1. Choose where your posts go
Open the multi-post Composer. In Step 1, choose a Bucket, or choose "None" to send the posts to your queue, then pick your profiles. Every row in your sheet becomes a post on each profile you pick. More on this step: How to choose where your posts go.
WARNING: Posts with a POSTING TIME can't go into a Bucket. To schedule posts at exact times, choose "None" and pick your profiles.
2. Upload the sheet
In Step 2, click "Upload spreadsheet" and choose your .xlsx or .csv file, or drag the file onto the spreadsheet box. Post Planner shows how many posts it found in your sheet.
The posts don't show a preview here. You'll see them in Planned after the upload.
3. Add the posts
In Step 4, choose whether the posts go to the top or the bottom of your queue, then click "Upload" (or "Upload to bucket" if you chose a Bucket).
To see your new posts, open Posts > Planned. If some rows didn't become posts, see How do I fix spreadsheet upload errors?
NOTE: Each row counts once for every profile you picked toward your plan's "Scheduled posts" limit. For example, 50 rows uploaded to 3 profiles create 150 posts. For the limits, see What are the differences between plans?
4. Label your AI posts
If any post uses an AI-generated image or video, open it in Posts > Planned, edit it, turn on the "AI content" switch under Post options, and save. For where the label shows, see Which networks support the AI content label?
❓ FAQ
Should I schedule or queue my spreadsheet posts?
Queue them (leave POSTING TIME blank) if you want your Posting Plan to space them out for you. Schedule them (enter a POSTING TIME) if a post has to go out at an exact time. For more, see Should I queue or schedule my posts?
Can I send rows from 1 sheet to different Buckets?
No. All the rows in a sheet go to the Bucket (or profiles) you pick when you upload it. Make 1 sheet per Bucket, and upload each one to its Bucket.
What if my upload didn't work?
See How do I fix spreadsheet upload errors? It lists every error message and how to fix it.
