Instead of manually creating your posts, you can import them into Publer's Bulk Uploader using a CSV file.

You can import any kind of post (status update, link, photo, multi-photo post, album, and video) depending on the columns that are filled in.

The CSV file you're uploading needs to have 6 columns:

The date you want your post to be published at (optional). The preferred time format is yyy/mm/dd hh:mm (24 hour military time), but other formats should work too.
The message / caption / description of the post. This column is required if your post is a status update.
An external URL if you want your post to be a link. This column takes precedence over the Media URLs column.
The direct link to an image on the Internet, the link to a video on the Internet (including YouTube, Facebook etc) or even several links to images on the Internet separated by comma. Keep in mind that you cannot mix media types within the same post.
The Title of your Album or Video if your post is any of these two (optional).
The label of your post (make sure you select the social accounts first before uploading the CSV file). Used if/when AutoScheduling in Bulk (optional).

To make it easier for you, we have a created a Template with only the column names. You can simply download the Template, fill it with your posts using Excel or Google Sheets, and upload it to Publer.

If you don't like Excel, you can also use Google Sheets. Take a look at this working example. Simply make a copy of the Google Spreadsheet (File -> Make a copy). Fill in your posts (without changing/removing the column names) and save it as a CSV (File -> Download As -> Comma-separated values).

When including special characters (symbols etc.), it is recommended to use Google Sheets instead of Excel.

Importing Posts with multiple photos

In the Media URLs column you can add direct links of up to 50 external images on the internet. The links need to be separated by a comma as shown below. Keep in mind that photos to Albums other than the Timeline photos will be posted without any specific order.

The message column is used also for captions. To specify captions for your photos, separate your captions in the message field with a double pipe "||".

Keep in mind that the "first" caption is reserved for the description of your post/album. If you don't need a description, but need captions, type

|| First caption || Second Caption

The description will be left blank (notice the trailing || in the front).

Some info:

Your logo (if any) will be automatically added to each photo, video, and link thumbnail.

This Superpower comes with both paid versions of Publer (Argentum and Aurum), but you can still try it for FREE up to 5 times. Keep in mind that ONLY Publer Aurum supports Multi-Photo posts, Albums, and Videos.
Was this article helpful?
Thank you!