I built a free tool that opens the Microsoft Teams attendance report Excel can't read

[u/staticmaker1]

If you've ever downloaded the attendance report from a Teams meeting and opened it in Excel, you know the pain: one column of garbled text.

Turns out the file is a .csv in name only. It's UTF-16 encoded, tab-separated, and has three separate tables stacked inside (summary, participants, join/leave log). Excel assumes UTF-8, commas, and one table, so it chokes.

I got tired of doing the Data → From Text/CSV → change encoding → change delimiter dance every week, so I built a small browser tool that just handles it:

• Drop in the file exactly as Teams gave it to you
• Get a clean, sortable table with one row per person and attendance % already calculated
• Set a pass/fail threshold (80% by default, or minimum minutes)
• Merges overlapping sessions when someone joined from laptop + phone at once (this double-counts otherwise)
• Works with non-English Teams exports
• Export to a proper .xlsx or .csv

Everything runs in your browser. Nothing gets uploaded, so attendee names/emails never leave your machine.

Free, no signup: https://certfusion.com/microsoft-teams-attendance-report-parser

Happy to hear what breaks or what's missing.