When I was making HootBulk I needed to consult HootSuite help files many times. There were a lot of people frustrated with the bulk uploader and with that in mind I took on the task of learning everything about it. Today I’m sharing what I learned and will walk you on how to correctly create CSV file from scratch. Let’s us begin.
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)
When you finish typing your days and times it will look like this
If that tweet has an URL write it in column “C”.
NOTE: URL’s need to have http://
Your final spreadsheet should look like this
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.
Next click “Choose File” to upload the csv file you just exported. Select the social networks you want and on “Choose Date Format” select dd/mm/yyyy hh:mm and click “Submit”.
Wait until you get a success message and your done. That’s it! You just created a correctly formatted bulk schedule csv. Go back to the publisher to review what you just uploaded.