How to Bulk Upload Tweets into HootSuite

If you have the HootSuite Pro version then you may have already tried this option. If you are using HootSuite Free then this may be the reason to upgrade, and if you are not using HootSuite at all, this may be the reason you take a look.

HootSuite is an online Twitter, Facebook, LinkedIn, FourSquare, and Facebook Page update and status scheduling tool. I have used it for team management and self management of small accounts. Just this last week I checked out the Pro account version Bulk Upload of status update features.

First although HootSuite offers a sample .csv file to review and to use for your own updates, I found that Excel kept changing the date format and did not offer the date format they wanted for load, and so I moved to Notepad to do my list creation.

This is the format to use:

09/02/2011 09:00,”Check out our blog writing prices and blog clients on this page.”,”http://ow.ly/3S5ru”

Note that the date format is day first, then month, then year followed by time on a 24 hour clock. The update must be wrapped in quotes, and then the URL wrapped in quotes. Each of these three fields is separated by a comma. You may be able to leave your URL as pointing to your own domain, but to be safe, I shrunk my URL ahead of time.

Of important note is that HootSuite will not allow duplicate updates. So you can not load more than one version. Additionally the Bulk Upload feature allows for 50 unique updates to be loaded maximum at a time. I found that the load creation was time consuming, but was able to be used on multiple accounts and as I saved the document, will allow me to use and re-use this load anytime I go on vacation for coverage.

When you go to upload your text file, you will put your select your social network from the icon list, then put your cursor in the message field. The box opens and allows you (for Pro accounts only) the option to bulk upload. Browse to your upload file then click Okay. You will then see all your updates appear in the pending stream column.

I think this is a great new feature for HootSuite. Social Oomph offers this same feature for Professional accounts as well but without duplication restriction. Please note that if you click the links in this post and purchase either Professional level accounts from these suppliers that they will pay me a commission which will allow me to buy lunch at McDonald’s. Thanks for your support and try out these two applications they may end up being big time savers for you too.