How do I Import Content via CSV?

CSV is a “comma-separated values” file which allows you to save your information in a structured way. This can be done via text files (where information is separated by commas) or via spreadsheets (where it is organized in a table) that are then saved as CSVs.

On SocialBee, you can also import previously downloaded files in CSV format. This can be especially useful if you want to migrate content from a different platform. Once you have your CSV file, make sure it’s properly formatted. You can download a sample from SocialBee to see how it should look.

These CSV files should include information about the text of your post, the link you want to add (if you want to generate a link preview with your post) and the graphics contained (image, video, or GIF). Here’s an example below: 

Make sure you only use two columns per line (one for the text and one for the link you want to add - link or image/gif/video).

Link preview

If you want to add a link preview to your text, You need to add the text in the first column and the link you want to generate a preview for, in the second column. Leave the other columns empty on that row.

Image Post

If you want to add an image, add the link of the image in the "Image URLs" column and leave the "Link" column empty.

Link with no preview, and an image

If you want to add a link to your text, without having it generate a link preview, and you want to add an image, gif or video, add the link together with the text in the first column, leave the "Link" column empty, then add the link of your image, gif or video in the designated column. 

Gif Post

To be able to post a gif, make sure you have the proper link:
Correct: https://media.giphy.com/media/4l2OVSB784S9W/giphy.gif
Wrong: https://giphy.com/gifs/4l2OVSB784S9W

Video Post

To be able to post a video, make sure you have the proper link:
Correct: https://socialbee.io/wp-content/uploads/2018/02/friends-jumping.mp4
Wrong: https://www.youtube.com/watch?v=iDwAufqMBEY

NOTE: Please keep in mind that the URLs of the Image, GIF or Video need to be public (if you would open them in a browser, they would ONLY show that image/gif/video), in order for the import to work. You cannot use any Dropbox or Google Drive links, as they are not public.

What happens if I add a link and a media link (Image/Gif/Video)?

If you add a link to the link column and an image link to the image column, the import will fail. This is why you should only fill the text column and one of the remaining columns on each row. 

If you plan on creating the CSV File yourself (as opposed to downloading it from a different platform), please make sure you follow this format. Also, you need to save the file in a .csv format instead of the Excel .xlsx format.

To import it, navigate to your content menu, and click “Import CSV”. This will take you to the import page, where you can select the social profiles you want to share your content to, the categories you want said content to be in, and also add your CSV File. Once you have all the settings done, just click import.

If you want to add the posts from the feed automatically, keep the “Add Posts as Approved” on (this is the default option). However, you might want to be selective about which posts you share. If that’s the case, you should uncheck the “Add Posts as Approved” option.

In the “Advanced Settings” section, if “Trim text for Twitter” is checked, we’ll trim the text so it is suitable for Twitter sharing. Don’t worry - we’ll trim from the title of the post, so we keep the Append text and URL intact.