Social PublishingIntermediate

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.

9 minIntermediate

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.

publer-bulk.csv
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.mp4

Step 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.

Publer - Bulk import
Bulk schedule Accounts: (YT) (IG) (TT)
---------------------------------------------------
Upload CSV: publer-bulk.csv (3 rows detected)
Map: Text->Caption Date->Date Time->Time
Link->Media URL
[ Preview posts ]
Map your CSV columns to caption, date, time and media, then preview.

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.

Publer - Bulk preview
Preview (3 posts)
---------------------------------------------------
1 Jul 01 18:30 clip01.mp4 ok
2 Jul 03 13:30 clip02.mp4 ok
3 Jul 05 18:30 clip03.mp4 media not reachable !
[ Schedule all valid ]
Each CSV row becomes a draft you can scan before confirming.
Media must be reachable
If a media URL is behind a login or returns a 403, that row fails to import. Host files somewhere public, or upload them to the Publer media library first and reference those instead.

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

Tags
#publer#bulk#csv#scheduling