threads
Product Updates

Import & Schedule posts from CSV Files

April 28, 2020
Import & Schedule posts from CSV Files

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

schedule posts from CSV Files

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.

Speaking of the columns, the CSV file you’re uploading needs to have 6 columns:

  1. The date you want your post to be published at (optional). The preferred time format is yyyy/mm/dd hh:mm (24-hour military time), but other formats should work too.
  2. The message / caption / description of the post. This column is required if your post is a status update.
  3. An external URL if you want your post to be a link. This column takes precedence over the 4th column.
  4. 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.
  5. The Title of your new Album or Video if your post is any of these two (optional).
  6. The label of your post. Used if/when AutoScheduling in Bulk (optional).

Keep in mind that your CSV file must have the column names (Date, Message, Link, Media URLs, Title, Label) otherwise it won’t work. To make it easier for you, we have created a Template with only the column names. You can simply download the Template, fill it with your posts using Excel (without changing/removing the column names) and upload it back to Publer.

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

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 / the Wall will be posted without any specific order.

Importing Posts with multiple photos

Some Info

Your logo (if any) will be automatically added to each photo, video and link thumbnail. To learn more, check out our comprehensive guide on Watermarking.

Import & Schedule posts from CSV Files

You can select a different Album other than the “default” one for each uploaded photo or even create new Albums!

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.

With Publer Argentum you can still (auto) schedule in bulk up to 500 individual photos as well as import and schedule links from RSS feeds and Trains.

Let's stay in touch

Subscribe to our newsletter, and we will keep you updated on our newest game-changing features and special offers. Plus, you will be the first to know about the latest social media trends, tips, and tricks.