Schedule posts in bulk (legacy)

  

Have you tried our Bulk Composer 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 the Publisher. Bulk scheduling is available for Hootsuite Professional, Team, Business, and Enterprise plans.

Create your .csv files with Google Docs, TextEdit (1.7 and above) 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 already in your dashboard 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.

Note that link preview images are not generated when bulk scheduling. To generate preview images, edit your scheduled posts in the Publisher after bulk uploading.

Schedule in bulk

  1. Go to Publisher planner-icon.png.
  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 the Publisher.

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. Press 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 press 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. Press 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 press 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. Uncheck 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.