Create a recurring Event or Task with Data Loader

Keep in mind when creating a Recurrence Activity with Data loader:

• Recurring Tasks and Events are available in API version 16.0 and later.
• After a Task or Event is created, it can’t be changed from recurring to nonrecurring or vice versa.

1. Create an Excel spreadsheet.
2. Add headers for the fields that need them. For example, include all required fields or the Task or Event.
3. Add the following fields in your Excel sheet:

1. ISRECURRENCE is a check box field that lets Data Loader know this is Recurrence Activity. Example: True/False
2. RECURRENCESTARTDATEONLY is a date field and is when you want to start the Recurrence. Example: mm/dd/yyyy
3. RECURRENCEENDDATEONLY is a date field and is when you want to end the Recurrence.  Example: mm/dd/yyyy
4. RECURRENCETIMEZONESIDKEY is what time zone the user is in. An example of this is "America/New_York".
5. RECURRENCETYPE is what type of Recurrence we are doing. Examples of valid values can be found in the table located in the Event documentation.
6. RECURRENCEINTERVAL is how often the Recurrence happens. This is a number field and would show how many times the Activity will repeat. Example: 1 would mean the Activity would repeat once.
7. RECURRENCEDAYOFWEEKMASK - The day or days of the week on which the task repeats. This field contains a bitmask. For each day of the week, the values are as follows.
    

• Sunday = 1
• Monday = 2
• Tuesday = 4
• Wednesday = 8
• Thursday = 16
• Friday = 32
• Saturday = 64

8. RECURRENCEDAYOFMONTH - The day of the month on which the task repeats: 1 would be for the 1st day of the month. 
9. RECURRENCEINSTANCE - The interval between recurring tasks. For example, if you want the recurrence to start on the 1st day of every month you would enter "First". This is used if you are creating the recurrence activity yearly.
10. RECURRENCEMONTHOFYEAR - The month of the year on which the Task repeats. Example: June, July

4. Save your file as .csv file.
5. Open Data Loader, log in and click Insert.
6. Select desired Salesforce Object (Task or Events).
7. Browse for the .csv file (select the file which you have saved), click Next.
8. Map your Activity columns to the Salesforce fields (manually) or click on Auto Match Fields to Columns. Click on OK then click Next.
9. Select the directory where the success and error files should be saved, then click Finish.