Skip to main content

How to Bulk Import Posts via CSV File

Upload multiple posts at once using bulk import.

The bulk import feature in Agorapulse lets you upload and schedule multiple posts or drafts at once using a CSV file. This is especially useful for managing campaigns, importing content in bulk, or saving time when preparing posts for multiple profiles.
​

Each CSV row represents one post and can include text, media, links, scheduling details, and labels. After uploading, you can review the posts, schedule them immediately, or save them as drafts.

In this article we will cover:

How to access the bulk import feature

  1. Click Publishing (calendar icon) in the left-hand navigation bar

  2. Click Drafts

  3. Click the ⌄ icon next to Create draft

  4. Select Bulk Import from CSV to open the bulk import pop-up

How to bulk import posts via CSV

Once the bulk import pop-up has been opened, follow these steps to bulk import your posts.

  1. Choose one or more social profiles to apply to your imported posts.

    Note: These profiles will be preselected in the Publishing Composer once the upload is complete.

  2. Drag and drop your CSV file into the upload area, or click Browse files to select it manually.

    • Your CSV must include the following columns:

      • post_content – Text of the post (optional)

      • post_link – Link attached to the post (optional)

      • video_url – Public video URL (optional)

      • image_url – Public image URL(s) (optional). Use a semicolon (;) to separate multiple URLs in a cell to create a carousel (Click here for more information on creating image URLs)

      • scheduled_date – Date the post should be published (required)

      • scheduled_time – Time the post should be published (required)

      • post_label – Label(s) for the post (optional)

    • Please Note: The CSV file must not exceed 200 rows. To upload more than 200 posts, divide them into multiple files of 200 rows or fewer.

      The scheduled date format must match the format in your Personal Settings.

  3. If your CSV file contains formatting issues, they will be highlighted in red. You must correct these errors before continuing.

    Note: To fix a CSV file, you will need to open the file in Google Sheets, Excel, or another spreadsheet editor and edit the affected cells. Once you have saved your changes, return to the bulk upload screen and re-upload your file.

  4. After uploading a valid file, you will be given three options:

    • Review: Opens the bulk edit window so you can manually update each post. Posts that are edited and have a scheduled date added will be scheduled. Posts left untouched will be saved as drafts in your Library.
      Note: This option is available for Facebook, Instagram, Twitter, TikTok, and LinkedIn (only for posts without links)

    • Schedule all: Bypasses the review step and schedules all posts based on the date and time in your CSV file. You can later edit them from the Publishing Calendar.

    • Save drafts: Saves all posts as drafts in your Library without scheduling them. Use this if your content is incomplete or needs approval before publishing.

Please Note: Schedule All is not available for YouTube and Pinterest, as well as link type posts on Instagram and LinkedIn. These posts will need to be saved as drafts.

For bulk-uploaded YouTube posts, the option to add a video title is not available in the CSV file. You will need to review each post individually and add the title manually.

Did this answer your question?