Bulk Scheduling (CSV Uploads)
Statusbrew lets you schedule multiple posts for all the connected social channels one at a time. We only support standard comma-separated value (CSV) file format for bulk upload.
The CSV Upload (or the Bulk Upload) feature empowers you to be more productive and organized. Additionally, in bulk scheduling, you can save your bulk posts as drafts and select approval methods.
- Users can schedule up to 400 posts (at once or in one upload). - Users can schedule text, links as well as graphical (image, GIF, and video) content
To get started with scheduling posts in bulk, all you need to do is, create a CSV file that contains all the posts, including the Image, GIF, and Video links and simply schedule them using Statusbrew Composer.
Creating CSV file
To create your own CSV file you can use Google Sheets, Numbers (on Mac), Microsoft Excel (on Windows/Mac).
You can create a CSV file in either of the two formats: one is Date-time based CSV and the other is No Date-time based CSV.
Date-time based CSV
Date-time based CSV file contains three columns. The first column contains the date and time of your post, the second column contains the content of your post, and the third column (optional) contains graphic (image, GIF, or video) URLs of your post.
Upload this CSV file when you select the Date-time based scheduling option.
This is how a Date-time based CSV will look like:
No Date-time based CSV
No Date-time based CSV contains two columns. The first column, with the content of the posts, and the second column(optional) with your graphic (image, GIF, or video) URLs.
Upload this CSV file for “Pre-select category” or “No date-time” scheduling options.
This is how a No Date-time based CSV would look like:
You’ll be using two or three columns in your CSV, depending on the type of CSV file you are making, as explained below:
Date-Time column In case you are making a Date-time based CSV, this will be the first column, otherwise, skip it. Add posting time in GMT format (mm/dd/yy hh:mm). For example, if you want to add time for a post scheduled for 3:30 PM on December 23, 2024, you will need to enter it like 12/23/24 15:30.
Set the times at least 1 hour ahead of the current time, and subsequent posts must have a time difference of 1 hour as well.
Posts column This will include the text of your post. This can also include the URL to any of your blog/video links, discount coupons, or anything else. For Instagram, the links will not be going out as active links but only as text.
Image-URL column You can add the URL of your images, GIFs, or videos that you wish to publish with your posts. Please note that these image URLs must be publicly accessible and do not require a login to view. When adding links from services such as Google Drive or Dropbox, you will want to ensure that the URL directs to the image itself, and not just a page showing the image. Typically the end URL will contain the image format (png, jpg, etc.). For Instagram, the image URL column is mandatory.
CSV uploading only allows you to attach 1 single image for each post. If you want to add multiple images, simply go to the Statusbrew Planner after uploading the CSV file, then go to the detailed view of the post and click on edit to add additional images.
Once you have filled all the content in the CSV file, you need to save the file in .csv format or download it as a CSV file if using Google Sheets.
We recommend that Windows users save all the CSVs in the UTF-8 encoding only.
Uploading CSV file
From Statusbrew dashboard, click on Bulk Schedule under Compose.
Choose the social media profile for posting content from the "Select Profile" drop-down.
To save your posts as drafts check the “Save as draft” checkbox.
Next, you will find two scheduling options: “Date-time based” and “Pre-select category”. For the Date-time based option, choose your timezone; for the Pre-select category option, select a category from the category picker drop-down. If you have checked the “Save as draft” checkbox, a new “No date-time” schedule option will also appear. The "No date-time" schedule option is designed for situations where scheduling dates and times for posts are not pre-decided.
When you choose to save your bulk posts as drafts, even with Date-time based or Pre-select category schedule options, they will remain as drafts.
If you wish to shorten the URLs that you have added to your post content, activate the link shortener by checking the “Shorten Links” checkbox. We recommend using this feature as shortening a URL will help you manage and track the reach of your content that is coming up via those shortened links.
Click "Choose Approval" to select an approver for your bulk posts. You can pick one or multiple users from the "Select User" option or choose an existing approval workflow.
Now, just upload the CSV file according to your selected scheduling options.
You can view all your posts in the Planner. Here you will find posts grouped by your selected scheduling options.
The CSV upload feature is only available on Statusbrew Web App. This feature isn't accessible in our mobile apps.
Bulk Scheduling FAQs
My posts aren't going at the time that I added in my Date and time-based CSV. What should I do?
If you are adding your posting times within your CSV file, the interface will assume that the dates and times that you have added are in the GMT format. Hence, make sure that you add your scheduling times in the GMT format in a CSV file.
I am a Windows user. I tried to save my CSV properly but it is still showing some errors. What should I do?
We recommend Windows users to set UTF-8 as their default character encoding to avoid upload errors. All the CSVs should be saved in the UTF-8 encoding only.