When I was making HootBulk I needed to consult HootSuite help files many times. Today I’m sharing what I learned and will walk you on how to correctly create CSV file from scratch. Let’s us begin.
1. Make a new Excel template workbook
Select column “A” completely. Putting the mouse pointer in “A” does this (it changes to an arrow pointing down). When you left click column “A” it will turn blue.
Go to Home > Number format (you will see an option that says “General”). Click the dropdown menu and select “Custom”. In “Type:” write dd/mm/yyyy hh:mm (with a space between yyyy and hh)
2. You just save yourself a lot of headaches with the previous step. The next step is to decide your starting day, the number of tweets you will like to send per day and the time period (days, weeks, months). Let’s say that you want to start sending tweets on December 24, send two a day and for two days. Let’s start with the days:
- In column “A1” type 24/12/2012 11:00
- In column “A2” type 24/12/2012 16:00
- In column “A3” type 25/12/2012 08:00
- In column “A4” type 25/12/2012 14:00
When you finish typing your days and times it will look like this
- You don’t need to add quotations in the days (I figure out this the hard way when making HootBulk)
- Times need to be in the 24-hour clock. If you want to know which times is which just subtract 12. E.g 16:00 is 4:00 pm
- All times must be at least 10 minutes from upload time. The best solution to this is to upload the csv the day before the first tweet. E.g you upload on the 23rd and the bulk tweets start on the 24th
- Posting times must end in 5 or 0. This mean that you should not put 8:53, 11:11, etc. Only ending with 5 or 0, such as 12:00, 13:05, etc.
- Only one message per time slot. This means that you can’t send a tweet at the exact same time. E.g you can’t have column”A1” with 24/12/2012 11:00 and column “A2” with 24/12/2012 11:00. You are duplicating the times.
3. The next step is to add the tweet in column “B” corresponding the time slot in column “A”. In other words the tweets you write in column “B” will go at the time and day specified in column “A”.
If that tweet has an URL write it in column “C”.
NOTE: URL’s need to have http://
- Messages in column “B” don’t need to be inside quotations.
- If you duplicate messages HootSuite will send you an error. Make sure you have different tweets per column.
4. We finished formatting the bulk scheduler. Go to file > Save As > Select Comma Separated Values (.csv)
NOTE: If a popup message appears telling you that the csv file cannot save multiple sheets just click “Save Active Sheet”. If you see the content, it is the selected and active sheet.
5. Go to your HootSuite dashboard and to the publisher. Click the button “Bulk Composer”
Next click “Select file to upload” to upload the csv file you just exported. Then select the social networks you and click “Next: Review Messages”.
Now you can click "Schedule All Messages" on the right sidebar or edit each message individually. With Hootsuite Bulk Composer now you can edit link previews and attach images.
That’s it! You just created a correctly formatted bulk schedule csv. Go back to the publisher to review what you just uploaded.