How to Bulk Schedule Posts Through SocialPilot?

SocialPilot allows you to bulk schedule to create and schedule up to 500 posts at once, making it easy to manage large volumes of content efficiently. Whether you are scheduling image or text posts, you can do so using a CSV or text file. This guide will walk you through the process of creating and uploading a CSV file for bulk scheduling and how to manage your posts.

How to Create a CSV File for Bulk Scheduling?

To schedule your posts in bulk, you need to create a CSV file in the proper format. Here’s how:

For a Link Post:

1st Column: Type your post content, including the post URL. Example: 8 Awesome Ways to Create Engaging Tweets in 280 Characters http://bitly.com/2pztHvy.
2nd Column: Leave this column empty.
3rd Column: Enter the date and time you want to schedule the post. If you're using pre-set time slots, leave it blank.
4th Column: Enter the unique Account ID for the social media account you want to publish from. You can find this ID on the Accounts > Manage Account page.

For an Image Post:

Follow the same structure as a Link Post.
2nd Column: Add the public URL of the image. Ensure that the URL points directly to the image, not a webpage.

📋 Note: If your images are stored on your device, you can upload them during the review stage in SocialPilot’s bulk scheduler.

How to Save a CSV File Correctly?

Here is how you can save a CSV file correctly

Excel to CSV:

If you are using Excel, go to Save As, select Save as type from the dropdown menu, and choose CSV (comma delimited).

Text File to CSV:

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 you encounter replacement characters during upload, it might be due to an outdated version of Excel or the file not being in UTF-8 format. To fix this:

Right-click on the Excel/CSV file, choose Open with > Notepad.
Save the file with a .csv extension and ensure it’s in UTF-8 encoding before uploading.

How to Export Posts as a CSV?

Another way to manage your posts is by using the Export as CSV feature. This allows you to download posts from the queue, published posts, posts with errors, or unscheduled posts.

Here’s how:

Select the account or group you want to filter by.
Click on the CSV button to download the posts as a CSV file.

Bulk Schedule Posts in SocialPilot

Once your CSV file is ready, follow these steps to schedule your posts in bulk:

Log into SocialPilot and click on Posts > Bulk Schedule from the left sidebar.
Drag and drop your CSV file or select it from your computer.

In the preview window, you can review and edit your posts:

Edit Text Content: Click on the text box of any post to make changes.
Add or Change Accounts: Select or change accounts for each post by clicking the dropdown menu.
Manage Images: Upload, change, edit, or delete images as needed

📋 Note: For more details on editing images within SocialPilot, refer to the image editor guide.

Choose the accounts or groups you want to schedule the posts for. Note that you can only bulk schedule for one Twitter account at a time.
Click on the Schedule All Posts button to finalize your schedule.
To view your scheduled posts, go to Posts > Manage Posts.