Mass Post to Salesforce Chatter Feeds and Comments Using Data Loader

To bulk-create Chatter posts using Data Loader, prepare a CSV file with the required fields and use Data Loader's Insert operation on the FeedItem object. For bulk comments on existing posts, use the FeedComment object instead.

Step 1: Prepare Your CSV File

Create a CSV file (comma-delimited) with the following columns:
Required Fields:

• ParentId — Specifies where the post will be created:
  • Use a Chatter Group ID to post to a group.
  • Use a record ID to post on the feed of a specific record.
  • Use a User ID to post to a user's feed.
• Body — The comment or message content you want to post.

Optional Fields:

• Title
• CreatedDate
• IsRichText
• LastEditById
• RelatedRecordId
• Type (Feed Item Type — Picklist)

For a complete list of available FeedItem fields, see the FeedItem API documentation.

Step 2: Insert Records Using Data Loader

1. Open Data Loader and click Insert, then log in.
2. Click Show All Salesforce Objects.
3. Select the object: Feed Item (FeedItem).
4. Select your prepared CSV file and click Finish.

A similar process can be followed to insert comments on a Chatter post. See the FeedComment API documentation for the fields to use.

Additional Video:
How to Prepare a CSV File to Insert Using Data Loader