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!