1. We typically recommend the following steps to clean up your download of
   duplicates, errors, etc…
2. Exclude “Archived” patients if you have not already and IF you typically use “archive” to exclude patients you do not want to see.
3. Exclude minors by sorting by birth date and deleting any under the age of 18.
4. Exclude duplicate phone numbers.

• • • Sort by phone number.
    • In Excel you can highlight duplicates in formatting.
    • Delete one of each until no duplicates remain.

5. Keep in mind that the values in the “First Name” column will be used even if
they are technically incorrect. Look through and fix anything that would be wrong to use.