The simplest and easiest way to solve your problem making an email verification process and when they verify their email register them as members with the emails and passwords that are stored, this way they become new members without creating new passwords.
Then you set a jobScheduler to delete the already registered members data from the collection that you’ve imported, or at least clear their passwords.
There might be other ways, but I think this is the easiest one.