Schedule messages in bulk

Schedule up to 350 messages 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 messages in the Publisher.

 

 

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_icon_37x44.png Smart quotes need to be disabled in TextEdit and on Mac keyboards, as these cause bulk scheduling to fail.

A maximum of 350 messages can be bulk scheduled at a time. This could be 350 messages to 1 social network, or 50 messages to 7 social networks. However, any scheduled messages already in your dashboard for those social networks need to be subtracted from the 350. For example, if there are 100 messages already scheduled to your Twitter profile, you could bulk upload 250 more messages to it. There is no limit to the number of messages 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.

To schedule in bulk

  1. Select Publisher Publisher icon from the launch menu.
  2. Under Content Sources, click Bulk Message Upload.
  3. Click Choose File, select your csv file, and then click Open.
  4. Select the date format used in the .csv file.
  5. Select the social network(s) to publish the messages, and then click Submit.

Now that your messages are scheduled, you can customize individual messages further by editing them in the Publisher.

To 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 message per time slot.
  2. In column B, enter your message. Duplicate messages will not publish.
  3. In column C, enter a URL (optional). URLs will automatically be shortened to Ow.ly links.

    Google

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

To create a .csv file using TextEdit

  1. Set TextEdit to plain text: Click TextEdit in the top-left corner of the TextEdit toolbar, and then select Preferences.
  2. Under Format, select Plain text, and then click 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 message per time slot.
  4. Enter your message, ending with a comma only if adding a URL. Duplicate messages will not publish.
  5. Optional: Enter a URL. URLs will automatically be shortened to Ow.ly links.
  6. Press ENTER to start the next message.

  7. Click 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 click Save.
  9. Locate the saved file, rename it and add .csv to the end of the file name, and then press ENTER.
  10. Click Use .csv.

To 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 message per time slot.
  2. Enter your message, ending with a comma only if adding a URL. Duplicate messages will not publish.
  3. Optional: Enter a URL. URLs will automatically be shortened to Ow.ly links.
  4. Press ENTER to start the next message.

     

  5. Click 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 click Save
  7. Locate the saved file, rename it and add .csv to the end of the file name, then press ENTER
  8. Click Use .csv.

To disable smart quotes on Mac

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

To disable smart quotes in TextEdit

  1. Click 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. 
Was this article helpful?
132 out of 182 found this helpful