How to create a group from CSV file?

Question

I have a CSV file with email addresses. Part of these addresses are in CiviCRM.

How can I create a CiviCRM group that includes contacts with emails matching those in CSV file?

In your group, do you want only existing CiviCRM contacts who are also in your CSV - or all the addresses in your CSV? — Aidan♦, Dec 1 '20 at 12:18

petednz - fuzion · Accepted Answer · 2020-12-02 23:06:03Z

1

(EDIT - read Lars' suggestion first)

Seems clumsy but this might work.

Run the import with SKIP and at the final step of the import there is an option to either add the contacts to a New Group (A) for the same.

This should give you a group of those who did not exist in db before import

Then re-run the import without SKIP and create new group (B) so that should give you all the list.

then use Custom Search called Include/Exclude and

answered Nov 30 '20 at 18:50

petednz - fuzion♦

25.4k3 gold badges17 silver badges54 bronze badges

2

Could also simplify a little bit by using IGNORE and then search by date added in an advanced search, so you'd only have to do one import. – Lars SG Dec 2 '20 at 20:42
If this is something ongoing, maybe a Google Sheet with an Apps Script that calls the API? – Lars SG Dec 2 '20 at 20:43
good idea about running that single import. – petednz - fuzion♦ Dec 2 '20 at 23:05

Add a comment |

1 Answer 1