Tool
Name Matcher
Match display names to UPNs from a TAC CSV or PowerShell export. Handles Last, First and First Last formats. All processing runs in your browser.
1. Load files
User list (CSV)
Click or drag CSV here
TAC export or Get-CsOnlineUser CSV
Columns: DisplayName, UserPrincipalName
Columns: DisplayName, UserPrincipalName
Names to match (TXT)
Click or drag TXT here
One name per line
Supports "Last, First" and "First Last"
Supports "Last, First" and "First Last"
How to get your user list
βΎ
Option A β PowerShell (requires Connect-MicrosoftTeams session)
Get-CsOnlineUser -Filter "AccountEnabled -eq $true" | Select-Object DisplayName, UserPrincipalName, LineUri | Export-Csv -Path ".\users.csv" -NoTypeInformation
Option B β Teams Admin Centre (TAC)
- Sign in to admin.teams.microsoft.com
- Go to Users > Manage users
- Click Export > Export all users to CSV
- Use the downloaded file as your user list
2. Set confidence threshold
Scores 45βthreshold are flagged for review (fuzzy). Below 45 = no match.
Results
| Submitted name | Matched display name | UPN | Score | Status |
|---|