Oho exports one row per check or accreditation, so a person with multiple checks (for example a WWCC and an NDIS clearance) appears on multiple rows.
There's no way to deduplicate this within Oho before export. To deduplicate after export:
- Excel: Select all data, Data tab, Remove Duplicates, select only the person_id or full_name column. Excel keeps the first row for each person and removes the rest
- Google Sheets: Data > Data cleanup > Remove duplicates, select only person_id or full_name
Caveat: This removes rows for secondary accreditations. You'll lose visibility of additional credentials in that export. Confirm this is OK before proceeding.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article