Using the Force.com Excel Connector to add Campaign Members to a Salesforce.com campaign

I had a recent need to use salesforce.com to send out emails to 450 people. It's a hassle to associate those Leads as campaign members in SFDC using your browser, so I used the Force.com Excel Connector. What you want to do is simply take an xls with a column full of LeadIDs that you want to be on the campaign, have a column for CampaignID (that you want to associate these LeadIDs to), and then tell Force.com Excel Connector to Insert all these new rows as Campaign Members to that CampaignID.

1. Open the  Force.com Excel Connector and run a Lead query to export all of your Leads, or all of the ones that meet whatever criteria you are looking for.  Be sure to include LeadID as one of your fields.
2. Open a new window in Excel by clicking the New icon.
3. In a browser, go to salesforce and navigate to the campaign you'd like to use
4. In the browser, look at the URL.  This contains the CampaignID (screenshot 1)
5. Copy the CampaignID out of the URL
6. In Excel Connector, run a query to pull the Campaign MemberID, CampaignID, and LeadID (where your criteria are also met (screenshot 2). This should give you just the three columns above with no other data in the columns yet.
7. Paste in the CampaignID you copied earlier into the CampaignID column.
8. Then go back to your first xls file and copy the list of LeadIDs from there. Paste them into the LeadID column of your second xls.
9. After you've pasted in all the LeadIDs, you need to write the word "NEW" in each cell of the column for CampaignMemberID and paste that same CampaignID in the CampaignID column (screenshot 3 shows all of these pasted in)
10. Highlight all of the rows with your cursor.
11. On the Force.com connector toolbar, select "Insert".  This will insert all of the highlighted rows. 
12. You'll notice that it will replace the word "New" with a value for the new CampaignMemberID of each of the Leads.
13. Visit your Campaign in your browser and you'll notice that all of those Leads are now on the Campaign in the "Total Leads" field.

Screenshot 1:

Screenshot 2: 

Screenshot 3: