Skip to main content

  Article updated: July 09, 2024

Schedule posts in bulk (Legacy)

Have you tried our Bulk message upload yet? It's an improved version of our bulk uploading tool that lets you preview, edit, and add images to your posts before scheduling.

Schedule up to 350 posts at a time to your social networks by uploading pre-populated, comma-separated value (.csv) files into the bulk uploader. Images cannot be included in the bulk files, but can be added after the upload by editing your scheduled posts in your content calendar in Plan.

Create your .csv files with Google Docs, TextEdit (1.7 and later) or TextWrangler. Excel files are incompatible as they don’t support exporting in UTF-8 and convert certain characters into unreadable fonts.

Important: Smart quotes need to be disabled in TextEdit and on Mac keyboards, as these cause bulk scheduling to fail.

A maximum of 350 posts can be bulk scheduled at a time. This could be 350 posts to 1 social network, or 50 posts to 7 social networks. However, any scheduled posts for those social networks need to be subtracted from the 350. For example, if there are 100 posts already scheduled to your Twitter profile, you could bulk upload 250 more posts to it. There is no limit to the number of posts that can be manually scheduled in addition to the 350 after bulk uploading.

Link preview images are not generated when bulk scheduling. To generate preview images, edit your scheduled posts in your content calendar after bulk uploading.

Schedule in bulk

  1. Go to Plan.
  2. Select the Content tab at the top, then under Content Sources, select Bulk Message Upload.
  3. Select Choose File, select your .csv file, and then select Open.
  4. Select the date format used in the .csv file.
  5. Select the social network(s) to publish the posts (only one Twitter profile can be selected), and then click Submit.

Now that your posts are scheduled, you can customize individual posts further by editing them in your content calendar in Plan.

Create a .csv file using Google Sheets

  1. In column A, enter a date and time (in 24-hour time) in the following format:
    • dd/mm/yyyy hh:mm or mm/dd/yyyy hh:mm. Use one format exclusively throughout.
    • One space between the date and time.
    • All scheduled times must be at least 10 minutes after upload time.
    • Posting times must end in 5 or 0. All other times will be rounded up to the next five-minute slot.
    • Only one post per time slot.
  2. In column B, enter your post. Duplicate posts will not publish.
  3. In column C, enter a URL (optional). URLs will automatically be shortened to Ow.ly links.

    Google sheets, csv example.

  4. Select Untitled spreadsheet in the top-left corner and enter a file name.
  5. Select File, select Download as, and then select Comma-separated values.

Create a .csv file using TextEdit

  1. Set TextEdit to plain text: Select TextEdit in the top-left corner of the TextEdit toolbar, and then select Preferences.
  2. Under Format, select Plain text, and then select the X in the top-left corner to close Preferences.
  3. Enter a date and time (in 24-hour time) into your file in the following format, ending with a comma:
    • dd/mm/yyyy hh:mm or mm/dd/yyyy hh:mm. Use one format exclusively throughout.
    • One space between the date and time.
    • All scheduled times must be at least 10 minutes after upload time.
    • Posting times must end in 5 or 0. All other times will be rounded up to the next five-minute slot.
    • Only one post per time slot.
  4. Enter your post, ending with a comma only if adding a URL. Duplicate posts will not publish.
  5. Optional: Enter a URL. URLs will automatically be shortened to Ow.ly links.
  6. Select ENTER to start the next post.

    TextEdit example, CSV.

  7. Select File in the top-left corner of the TextEdit toolbar, and then select Save.
  8. Enter a file name, select a save location, and then select Save.
  9. Locate the saved file, rename it and add .csv to the end of the file name, and then select ENTER.
  10. Select Use .csv.

Create a .csv file using TextWrangler

  1. Enter a date and time (in 24-hour time) in the following format, ending with a comma:
    • dd/mm/yyyy hh:mm or mm/dd/yyyy hh:mm. Use one format exclusively throughout.
    • One space between the date and time.
    • All scheduled times must be at least 10 minutes after upload time.
    • Posting times must end in 5 or 0. All other times will be rounded up to the next five-minute slot.
    • Only one post per time slot.
  2. Enter your post, ending with a comma only if adding a URL. Duplicate posts will not publish.
  3. Optional: Enter a URL. URLs will automatically be shortened to Ow.ly links.
  4. Select ENTER to start the next post.

    TextWrangler example, csv.

  5. Select File in the top-left corner of the TextWrangler toolbar, and then select Save As.
  6. Enter a file name, select a save location, and then select Save.
  7. Locate the saved file, rename it and add .csv to the end of the file name, then select ENTER.
  8. Select Use .csv.

Disable smart quotes on Mac

  1. Open the computer’s System Preferences.
  2. Select Keyboard, and then select the Text tab.
  3. Clear the Use smart quotes and dashes box.

Disable smart quotes in TextEdit

  1. Select the TextEdit menu in the top-left corner of the screen, and then select Preferences.
  2. Under Options, make sure the Smart quotes and Smart dashes boxes are unchecked.

 

Can't find what you're looking for? We're here to help