Cut and Paste from Web to Excel
Your task should you choose to accepts it is actually 3 things:
A. Merge the TYPE entries for any duplicates before deleting said duplicates
B. Delete entire ROW for duplicates (merging the TYPE on to the one you keep.
C. Visit every site and simply paste in the Sign-up URL
Making sure the Sign-Up URL appears as a clickable link.
Send back the Excel File.
You should end up with ~500 to visit?
I can pay 10 cents USD for Unique Sign-up URL that gets pasted in!