Another option that I've found slightly easier (but still a couple of steps): 1. Create two static lists: (i) Existing Leads and (ii) New Leads 2. First import your external list into "Existing Leads" >> make sure you select import mode = "Skip new leads and updates" 3. Check import status when complete >> specifically "Skipped: XX leads" >> download/save this file (ie. records from your external list that are NEW leads and NOT already in your database) 4. Next, import the "skipped leads" file into "New Leads" static list created earlier >> import mode = "Optimised for new leads" This (hopefully) means no VLOOKUP or need for Excel. TIP: when first importing in step #2, make sure you include all the columns/fields you'll want to use in step #4 when creating your new leads ... otherwise you will be stuck manipulating stuff in Excel!
... View more