How to bulk upload to Hootsuite Fast (w/ pictures)

[fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=”” min_height=””][fusion_text]

Why do people curate?

People curate so they can provide high-quality articles to their audience. You give them as much information as you can in order to help them. It creates loyalty, and they will keep coming back to your website.

There are many steps, but, once you start using it, you will never go back to doing it manually. I promise. 🙂

Tools:

  1. OneTab
  2. Google Chrome
  3. Microsoft Excel or Google Sheets
  4. Hootsuite Pro
  5. Follower Wonk
  6. Feedly account (free is fine).

How to find the best times to publish

Sometimes it’s hard to find the best time to publish. You can find this information by going to follow or walk. I’m pretty sure there are other tools out there that will help you find this information. If you find something that can be alternative to this, please mention it in the comment section.

Make sure you find the best times to publish for Facebook and Twitter for your audience. Choosing the best time to publish it so the majority of your audience will be online and will get to see your update in real time. Most people do not try and check all their updates. They only see whatever is shown to them on the screen because most have a lot of updates.

Steps

1) Open up feedly and select the urls you want to add.

One thing I like to do is search for websites similar to my niche. Once I find these websites I go look at the blocks. I then add the seeds into Feedly. I name them according to whatever I need for them to be labeled

Feedly Curation Folder

2) Get all links you’re interested in

I used to have a big problem with this. I hired a VA especially for my content curation because it can be a tedious task. Not only is it a tedious task, but it is also time-consuming. The time you spend doing this task correlates to how fast your Internet speed is and how fast your computer is.

Loading all links

Don’t tell anybody, but here is a tool I use. As a power user, I use the “OneTab” tool. This tool grabs whatever tabs you have on your browser, and it’ll compile it and put it in a clear list. This stops your computer from slowing down and increases its speed. This is especially useful for people like me who have a lot of ideas and have a hard time organizing them.

3) Install OneTab on Chrome

Going back to feedly, you can hold down the control key and then press each link you want to open. Instead of right clicking or doing this manually, this will open up each tab without you leaving the current.

Press one tab extension

Once you are happy with the number of links you have collected, press the OneTab icon on the top right-hand corner of the screen.

You will see OneTab will merge all the links together and add them as a list on its tab.

4) Export!

Now, you will have these beautiful links that put in your spreadsheet. Click on the import/export link which is located on the top right-hand corner of OneTab. Once you press this link, it’ll show you a box of all the links. Copy this and paste it on your spreadsheet.

Compile all list into one-tab

My long list of content

Export URLs

The link is at the top-right hand corner

 

Copy and paste to text file

5) Copy and paste to your notepad (.txt) file and save it.

6)Open up Microsoft Excel and open the (txt) file.

Open in Excel

Make sure it's in .txt format

Since it is a txt file, excel will ask you how you want it to be formatted when importing the file. Follow the steps below.

text import 1

Step 2

Step 4 text

7) Rearrange the column according to Hootsuite’s format.

ctrl x

8) Add your comments and upload

Once you have your beautiful list of URLs, now is the time for you to comment on them. You could comment on them however you want; although just inputting the title would not be the best way to comment on them. Your audience wants you to be authentic. Therefore, you would want them to think that you read the article.

You must learn how to skim articles and be able to see the main point of them. What I usually do is skim the article, find the most useful point, then comment on it. This comment will be my tweet.

9) Add Dates

Choose date and time in column one.

When you’re choosing a date and time for column one, select the date and time in which you want this content to be published. After that, click the drag button. It won’t change the time, but it will change the date. You could change the time by adding another. Now, all you need to do is put some more content on that tab.

 

date section

 

10) Once you arrange the columns, save the file as a CSV file and upload it to HootSuite.

bulk upload in hootsuite

 

Tips:

Know the optimal time to send a tweet. You may send a tweet three to six per day. You don’t have to do all the way to six tweets. But if you are a big company, definitely do six tweets. But if you are starting out, three tweets would be enough.

For Facebook, I would recommend sending two posts per day unless you have really humorous posts to where they have a tendency to go viral. You don’t want your Facebook audience to get sick of your posts and unfollow you.

A better way to know is by testing. Nobody can tell you how you to do anything because each business is different. It is up to you to research more about your audience so that you could cater to them.

[/fusion_text][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]To Recap:[/fusion_title][fusion_text]

1) Get our links using feedly.

2) We used Onetab to compile them all into a neat list

3) We saved this list as a txt file and upload it to excel.

4) We rearranged the columns according to Hootsuite’s standards and uploaded it into their bulk uploader.

 

Did you get that?

Good! If you have any questions, feel free to comment below and I’ll be sure to clear things up for you!

 

If you found this helpful, please help spread the word through social media. Thanks!

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

16 replies
  1. Elizabeth O.
    Elizabeth O. says:

    That’s such an awesome and detailed tutorial especially for people who are new to hootsuite. I think it’s an amazing platform for bloggers who needs to promote on a daily basis. Thanks for the tips!

    Reply
  2. Sheri @ A Busy Bees Life
    Sheri @ A Busy Bees Life says:

    For someone new to blogging and does not know much about what this does it is somewhat hard to understand. What exactly is one tab or feedly. I would have to go back and read on the items listed to be able to understand how this post would help me.

    Reply
  3. Kathy Kenny Ngo
    Kathy Kenny Ngo says:

    My friend needs to upload too many files in hootsuite. She needs this article. I will share this to her. Thanks for sharing!

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *