List duplicate registrations with participant reports and Excel

Have you noticed duplicate registrations in your event? This can happen for instance if you are using open registration links.

There's no need to worry, it's possible to prevent those from happening in your future events. You can check how to prevent duplicates here. 

But in the meantime, you still need to know how many duplicates you have in your current event, and who they are.

By using a participant report and Excel, you can create yourself a list in only a few clicks. Check this video below to see how.

Make sure the captions are on!