How to Bulk-Schedule a Month of Posts in Publer with a CSV
Prepare a spreadsheet of posts and bulk-import them into Publer to fill an entire month's calendar in one upload.
When you batch a month of content at once, clicking through the composer for every post is painful. Publer's bulk scheduler reads a CSV where each row is a post, so you can plan everything in a spreadsheet and import the whole calendar in a single step. This guide covers building the CSV correctly and importing it.
What you need
- A Publer plan that includes the bulk scheduler
- A spreadsheet tool (Google Sheets or Excel) to build and export the CSV
- Media URLs that are publicly reachable, or files you upload first to the Publer media library
Step 1: Build the CSV columns
Create a sheet with one row per post. At minimum you want a column for the caption text, a column for the scheduled date and time, and a column for the media URL. Keep dates in a clear format and one time zone to avoid surprises.
Text,Date,Time,Link
"New tutorial is live. #ai #buildinpublic",2026-07-01,18:30,https://cdn.example.com/clip01.mp4
"3 editing shortcuts I use daily",2026-07-03,13:30,https://cdn.example.com/clip02.mp4
"Behind the scenes of this week's shoot",2026-07-05,18:30,https://cdn.example.com/clip03.mp4Step 2: Export as CSV
In Google Sheets choose File, Download, Comma-separated values (.csv). Captions that contain commas must be wrapped in double quotes, which the sample above already does, so they import as one field.
Step 3: Open the bulk scheduler and pick accounts
In Publer click Create then Bulk. Select which accounts these posts should publish to (for example all three of YouTube, Instagram and TikTok), then upload your CSV.
Step 4: Map columns and preview
Publer asks which CSV column maps to which field. Match Text to caption, Date and Time to the schedule, and Link to media. Then click Preview. Every row renders as a draft post so you can scroll and catch a broken media link or a typo before anything is queued.
Result
After you confirm, every valid row becomes a scheduled post across all selected accounts. A month of content lands on the calendar in seconds, and you only edit the exceptions instead of building each post by hand.
Watch related tutorials
11:30
13:10
12:00
10:40
15:20
17:00