Skip to main content
Hootsuite bulk tweet upload Google Spreadsheet tool

Spreadsheet Sunday: Hootsuite Bulk Tweet Scheduler

Hootsuite is a great tool for almost any social media manager out there. It lets you manage multiple accounts and schedule social media posts across channels. Hootsuite is probably most used by marketers to help manage multiple twitter accounts and streams, and it is a great tool for doing that.

One of the power features that Hootsuite offers is bulk message scheduling via a CSV file. Bulk scheduling tweets can be a huge time saver, especially if you want to promote certain tweets or links several times throughout a month. However, creating a bulk upload sheet can be a bit of a pain with the default CSV template that Hootsuite provides.

Worry no more, you can use this simple Google Spreadsheet to help you bulk schedule your tweets with ease! Simply use the “Editor” sheet in this Google Doc and you can enter your tweet’s information. What this sheet will help you do is after you add your message and a link (if you want to include one) and this sheet will perform a character count for you to make sure your tweets are within the 140 character limit. You can also choose the time and date with ease by clicking on the little triangle in the cell and selecting the options you want from a drop down menu.

When you are ready to schedule your tweets, simply go to the “Export” sheet and export the sheet as a CSV file to upload to Hootsuite. This “Export” page automatically puts the data in the proper format for uploading to Hootsuite, so there is no extra work for you to do.

To get your own copy, click the button below, select “File” from the menu, then select “Make a copy…” to create a copy that you can use. Don’t forget to share this page with anyone who you think might find it useful!

Get It Now

728x90_landing

11 thoughts to “Spreadsheet Sunday: Hootsuite Bulk Tweet Scheduler”

  1. Can you please advise as to how to indicate am or pm. It is a wonderful template but it is 11 am here currently. When I upload the csv file it is seeing it as 1:15 am etc.

    Schedule messages at least 10 minutes from upload time. Based on your chosen time zone, the current time is Mar 2, 2015 11:04:11 AM
    Line #1: 3/2/2015 1:15, Allow W Marketing Services to connect the dots with your clients and build your business., http://goo.gl/FdlYGj
    Line #2: 3/2/2015 2:30, Make the most out of networking events by applying the SMART approach, http://goo.gl/teM4iF
    Line #3: 3/2/2015 3:15, High performers know their value. Workaholics allow others to determine their value,
    Line #4: 3/2/2015 4:20, The Area Agency on Aging of Pasco-Pinellas, Inc. annual luncheon on April 24, 2015 Click For details, http://goo.gl/uruOpU

    1. Sonja, great question! I have not run into that problem yet myself. I do not seem to see anything about it in Hootsuite’s documentation either. If you can point me to the documentation for bulk uploading images, I’d be more than happy to make it work with this sheet or something similar.

  2. Hi Chris, this spreadsheet is great! Thanks for making it public! My only question is hot would I make change the date format from mm/dd/yyyy to dd/mm/yyyy? I work from the UK :) my excel skills aren’t up to it and it would be a big help if you could give me a hand.

    Thanks.

    1. Hi Sakis. I’m in the UK too! When you use the Hootsuite bulk uploader, it asks you to choose whether you’re using the mm/dd/yyyy or dd/mm/yyyy format. So it doesn’t matter which you use as long as you choose the correct option when uploading.

      Hope this helps!

  3. Hi Chris – I downloaded your worksheet but it is “view only”. Am I suppose to be able to actually use this? It’s a great worksheet and would save me from creating my own. Thanks.

    1. When you click the link at the end of the article and are taken to the spreadsheet, select “File” from the menu, then select “Make a copy…” to create a copy that you can use with your Google account. I have not tried downloading to use in Excel if that is what you are doing. Often times there will be a button in excel that will let you enable editing on your document. I will look into this a little more and let you know.

What do you think?