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

When working with CSV files, you have to know that they are complex documents that you need to work on carefully to make sure you get the import running from the first go. Each column has a designated role, as described below:

• The "text" column

In this column, you can type in or paste what you want to appear as the caption of your post. Keep in mind to keep your posts within the character limit of the social media platform(s) you're posting to.

• The "link" column

In this column, you can type in or paste what you want to appear as the link preview of your post. Keep in mind that filling in this row will override all other media rows you might fill in (eg. imageUrls, gifUrls, videoUrls).

• The "imageUrls" column

In this column, you can paste what you want to appear as the image of your post. Keep in mind that you should not fill in any other media-related column if you added a link here. (eg. link, gifUrls, videoUrls).

• The "gifUrls" column

In this column, you can paste what you want to appear as the GIF of your post. Keep in mind that you should not fill in any other media-related column if you added a link here. (eg. link, imageUrls, videoUrls). You can see which social media profile support gif files here.

• The "videoUrls" column

In this column, you can paste what you want to appear as the video of your post. Keep in mind that you should not fill in any other media-related column if you added a link here. (eg. link, imageUrls, gifUrls). You can see which social media profile support video files here.

• The "postAtSpecificTime" column

In this column, you can type in the date and time of when you want to share your post. This is the CSV equivalent of choosing to post at a specific time. In this column, you must format the date exactly how you see at the top of the column: yyyy-mm-ddThh:mm:ssZ. Keep in mind that this formating works in 24-hour format, not 12-hour. If you have difficulties with this, you can use this tool to help.

For example, as you can see in the last row, you have 2021-10-14T00:00:01Z. This means that the post would have been shared on October 14th, 2021 at midnight (00:00).

Importing Your CSV File

• 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:

1. Select the profiles you want to add this content to;
2. Upload the CSV file you want to import;
3. Select the category you want to add them to.

There are two other options that you can change in this tab: where you want your posts to be added in relation to your queue and add posts as Approved.

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.

Add posts as Approved is as intuitive as it can get: leave it green (to the right) for posts to be added as Approved, or click on it and make it red (to the left) for posts to be added as Not Approved. Easy peasy, 🍋 squeezy!

Advanced Settings

Next to Import CSV, there is a special tab dedicated to the advanced settings of the import. You can choose between setting posts to expire, choosing not to shorten links, and trimming your text for Twitter. Let's go through them one by one.

Setting the post to expire can be important if you want to make sure your content stays fresh and relevant. 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.

You can also choose to set them to expire after a number of days, which means that posts will be archived from your category once that time passes, even if they were never shared. This is great for news articles or fast-paced industries.

Don't shorten the links is pretty self-explanatory, we think. If you don't want your category's short link settings to be applied to the imported links (if there are any in the file) just tick this box and links will be added normally.

Trim text for Twitter is checked by default and allows us to shorten the text so it is suitable for Twitter sharing. We will only trim the caption for this profile so, if you choose any other profiles, it won't be shortened for those.

Preview your posts

Once you've got all these settings down, you might want to see how these posts will be published to your social media. If you've added the file in your Import CSV tab, you'll notice that a preview has already been generated for one of your profiles. To switch between them, navigate with your mouse to the top-right corner, click on the drop-down menu, and select the profile you want to preview your posts for.

The last 3 lines of the file will be previewed here.