How to Find Duplicate Accounts

Need to find identical accounts? Learn the 7 steps here

Serena Edwards avatar
Written by Serena Edwards
Updated over a week ago

At the writing of this article, there is not a clear-cut way of finding duplicate accounts in Enrollsy. However, there is a workaround. Follow the steps below.

Step 1 - Choose Columns

Head to the Enrollees Table. Under "Columns," choose these three options:

  • Enrollee (or whatever you call those who enroll)

  • Account

  • Email

Click "Done."

Step 2 - Adjust Location & Enrollment Period

Make sure you are in the correct Location (top right corner), or choose "All Locations." Also, select "All Enrollment Periods" on the left.

How to find duplicate accounts in Enrollsy

Step 3 - Select All

Next, click on the top checkbox to "select all" Enrollees. Scroll to the bottom of the page and make sure "300" is selected beside "Rows per page." If you have more than 300 Enrollees, click the checkbox at the bottom to select all your Enrollees.

How to find duplicate accounts in Enrollsy

Step 4 - Export

Scroll back up to the top and select the Export button (2nd button from the left with a down arrow). Choose "Only current columns." Save the CSV file on your computer (such as to your Desktop or Downloads folder).

Step 5 - Google Drive/Sheets

Next, sign into your Google Drive. Open the CSV in Google Sheets. If you don't know how to do that, follow these instructions:

  1. Click on "New" + "Google Sheets" + "Blank spreadsheet."

  2. Once the spreadsheet opens, click "File" + "Open" + "Upload" + "Browse."

  3. Find your CSV spreadsheet and either double-click it or select it and click "Open."

  4. You may have to click "Open with" and "Google Sheets" at the top.

Step 6 - Add "Remove Duplicates" Add-On

Once you have the CSV file open, follow these steps:

  • Click "Extensions" + "Add-Ons" + "Get Add-Ons"

  • Choose the following "Remove Duplicates" Add-On:

    How to find duplicate accounts in Enrollsy

Step 7 - Use Remove Duplicates Add-On

After installing the Add-On, click the cell in the upper-left corner to select all. Click "Extensions" + "Remove Duplicates" + "Start"

How to find duplicate accounts in Enrollsy

Choose the appropriate actions in the window that pops up, then click "Search."

How to find duplicate accounts in Enrollsy

All duplicates will be highlighted, deleted, appended, copied, or moved (according to the option you selected under "And").

Did this answer your question?