How do I Import Content via CSV?
CSV s a “comma-separated values” file that 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 CSV.
Creating your CSV file
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. Keep in mind that a maximum of 1,000 rows can be imported at once.
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).
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.
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.
If you want to add a gif, add the link of the gif in the "Gif URLs" column and leave the "Link" column empty.
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
If you want to add a video, add the link of the video in the "Video URLs" column and leave the "Link" column empty.
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
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), for the import to work. You cannot use any Dropbox or Google Drive links, as they are not public.
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.
Importing your CSV file
To import the CSV file you have created, navigate to the Content menu, and click Import CSV. This will take you to the import page, where you can start working on the import. Here, you will be able to see 3 big buttons that will help you get a better grip of this functionality:
- How do you prepare your spreadsheet, which will take you to a video tutorial on how to prepare your file.
- Download a sample spreadsheet, which will download the sample CSV file.
- View the FAQs if you have questions, which will take you to our Help Articles.
Below, you will see the buttons that will allow you to import your file. Like with any import, you will have to take 3 steps:
- Select the profiles you want to add this content to;
- Upload the CSV file you want to import;
- Select the category you want to add them to.
To select where to add posts in relation to your queue, you have 3 main options: Add posts to the category default (will be filled in automatically, according to your category settings), add them to the top, or add them to the bottom.
You can choose to set posts to expire after they've been published a number of times. This means that your posts will remain in the category until that limit is reached.
Preview your posts