📑 How to Create a CSV File for Bulk Upload to Publer
Step 1: Open Excel or Google Sheets
-
Open Microsoft Excel, Google Sheets, or any spreadsheet tool.
Step 2: Create These Columns
Create a sheet with exactly these columns:
Message | Media URL | Scheduled Date |
---|
Explanation:
-
Message = Your caption/text for the post.
-
Media URL = Link to your image/video online (OR you can leave it blank if text-only post).
-
Scheduled Date = When you want the post to publish (in the format:
YYYY-MM-DD HH:MM
).
✅ Example:
Message | Media URL | Scheduled Date |
---|---|---|
Welcome to our new page! | https://yourwebsite.com/image1.jpg | 2025-05-01 10:00 |
New product launch coming soon! | https://yourwebsite.com/image2.jpg | 2025-05-02 11:00 |
Step 3: Save the File
-
If using Excel: Save As > CSV UTF-8 (.csv)
-
If using Google Sheets: File > Download > Comma-separated values (.csv)
✅ Save it to your computer.
Step 4: Upload to Publer
-
Log into Publer
-
Go to Create > Bulk Upload > Upload CSV file.
-
Select the pages you want to post to (both Page A and Page B).
-
Review your posts.
-
Click Schedule or Post Now.
🎯 Important Notes
-
Media URL must be a direct link ending in
.jpg
,.png
,.mp4
, etc.
(Example: from your own website, Dropbox direct links, Google Drive public links, or Imgur links.) -
If you don't have Media URLs, you can upload images manually after uploading the CSV.
-
Scheduled Date is optional — you can leave it blank to post immediately.
✨ Summary
-
Create CSV with Message, Media URL, Scheduled Date.
-
Save as CSV UTF-8.
-
Upload to Publer.
-
Select both pages.
-
Post in bulk!