How do I create a CSV file for bulk scheduling?

To schedule posts in bulk, you can use our Bulk Schedule feature. For that, you would need to create a CSV file in a proper format.

There are many types of posts you can create using SocialPilot manually like a Link Post, Image Post, GIF Post, Video Post, Carousel Post. But through Bulk Schedule, you can create a Link Post and Image Post only.

A Link Post is the one wherein you include a link in your post but doesn't select/upload an image. In a link post, we get the title, image, and description along with the post content.

An Image Post is the one where you select/upload an image to go along with your post. You can also include the web link along with the post content but the image you selected will be shown when your post gets published.

Follow these steps to create a CSV file:

Note: You can download a sample CSV  here.

If it's a Link Post:

  • 1st Column:  Type your post content/description with the post URL (From where we'll get the image preview).
    Example: 8 Awesome Ways to Create Engaging Tweets in 280 Characters http://bitly.com/2pztHvy.
  • 2nd Column: It must be empty.
  • 3rd Column: Enter a date and time you want to schedule the post for. If you're going to schedule the posts according to the time slots you have already set, leave it blank.
    Note: The date and time format must match the format you have set in SocialPilot timezone settings.
  • 4th Column: Enter the unique Account ID of the social media account you want the content to be published from. You can get the unique account ID from the Accounts >> Manage Account page.

If you want to share your post as an Image Post:

  • 1st Column: Type your post content/description with the post URL (From where we'll get the image preview).
  • 2nd Column: Add the URL of the image. Ensure you add an image URL and not a web page URL. The image URL should be a public image URL i.e when you open it in a browser, it should open an image only and not the website.

    More Information: How to create a public URL of your images while creating a CSV?
  • 3rd Column: Enter a date and time you want to schedule the post for. If you're going to schedule the posts according to the time slots you have already set, leave it blank.
    Note: The date and time format must match the format you have set in SocialPilot timezone settings.
  • 4th Column: Enter the unique Account ID of the social media account you want the content to be published from. You can get the unique account ID from the Accounts >> Manage Account page.

How to save a CSV file?

Now if the file is created in excel, go on the top left corner and click on “Save as”, now press on “Save as type” dropdown box and choose “ CSV ( comma delimited)”

 Your CSV file is ready! 

Also, If you are creating a CSV on your text editor or Notepad, use a comma (,) to separate the fields and also ensure that your post description is written in double inverted commas ( ), and save it in UTF8 format

Note: If the images you want to add are saved on your computer, you'll need to create a public link for these images by uploading them to your Dropbox. You must use Public URLs for images during bulk scheduling.

Still need help? Contact Us Contact Us