The bulk import feature in Agorapulse allows you to import multiple social media posts at once, saving you time and effort.
1. Go to the Library > Draft > Create new to find the Bulk Import option
Click on the Bulk Import button to access the bulk import feature. From here, you can import posts or drafts by uploading a CSV file.
2. Select Social Profiles
Choose the social profiles on which you want to import your posts. This will ensure that these profiles will be pre-selected in the Publishing composer after uploading your content via CSV.
You can bulk import to multiple profiles at once.
3. Import CSV File
Import your CSV file either by dragging and dropping it or by clicking on Browse files. Make sure that your CSV file is in the correct format:
post_content: Content of the post (optional)
post_link: Link attached to your post (optional)
video_url: Public video URL (optional)
image_url: Public image URL (optional)
scheduled_date: Post publishing date*
scheduled_time: Post publishing time
post_label: Label(s) (optional)
⚠️ The limit per CSV file is 200 rows. If you want to bulk upload more than 200 posts, you will have to create several CSV files with max 200 rows each.
You can add multiple image URLs (or video URLs) in a single cell to create a carousel (separated by a “;” in the CSV file). To learn more on how to create public URLs for your images and videos, take a look at our help centre article here.
*Note: that format for Date needs to match the date format selected in your Personal settings. For example, if you have DD/MM/YYYY format selected then this is the format you need to use for the date in your CSV file.
4. Review your content
If there are any errors in the data format of your CSV file, they will be noted in red. In this case, you'll need to edit the errors in your CSV file and re-import it.
One easy way to edit a CSV file is by using a spreadsheet program like Microsoft Excel or Google Sheets. Simply open the file in the program, make the necessary changes, and save the file as a CSV again, before re-importing it.
5. Review, Schedule all or Save drafts
When you get to this part of the process you are given a few options to choose from. Below you can see an explanation for each option so you can decide which is the best for you:
Review
If you choose to review, the bulk edit window will open, allowing you to edit each of your posts.
If there are errors on a post (e.g. you need to add an image), you'll need to edit the post before moving on to the next one.
If you leave the bulk edit, the posts you have edited will be scheduled, but the ones you have not edited will be saved as drafts in your Library.
Note: This option is available for Facebook, Instagram, Twitter, TikTok, and LinkedIn (but only for posts without links).
Schedule All
If you are happy with your posts and there are no further edits you need to make, you can use this option to automatically skip the review part so all the posts will be scheduled automatically. You can always find these posts on your calendar if you want to edit them, but please note that they will be published at the date and time you entered on the CSV file.
Save drafts
If your posts are not ready yet to be scheduled and you want to edit them at a later date, this option will save your drafts in a folder within your Library allowing you to edit these further.
Using the bulk publishing feature in Agorapulse is a quick and easy way to manage and schedule your social media posts. Just make sure to follow the steps outlined above and pay attention to the data format of your CSV file to ensure a smooth import process.