Teams Premium reports are very confusing and contain errors

Hi @ISOLUCION Mercadeo, 

Welcome to the Microsoft Q&A forum.    

Thank you very much for sharing your experience regarding the registration and attendance reports from Teams Premium. I appreciate your patience and the details you provided. 

I understand that working with CSV files that contain multiple sections on the same sheet, or require additional steps to align columns and apply the correct delimiter/encoding, can make it less convenient when you’re simply looking for a clear, consolidated view of who registered and who attended. 

To clarify what’s happening, the Teams export intentionally includes multiple sections (e.g., Registration and Attendance) in a single CSV. Depending on regional settings and how Excel auto-detects the file (delimiter, decimal separators, and encoding), those sections can look “jumbled” when opened directly. This is a common behavior with CSVs that include multiple data blocks, and there are reliable ways to make them clean and analysis-ready. 

Below are practical options so you get one Excel file with one clean data block per dataset (Registration vs. Attendance), ready for filtering, pivots, and summaries. 

Option 1 - Open the CSV “the right way” in Excel  

1. In Excel, please go to Data > From Text/CSV and pick the report. 
2. In the import dialog: 
   1. File origin/Encoding: select UTF‑8 (prevents character issues). 
   2. Delimiter: choose Comma (,) or Semicolon (;) based on the preview (use the one that aligns the columns correctly). 
   3. Data Type Detection: select Do not detect data types so IDs/phone numbers aren’t changed. 
3. Remove any repeated headers or spacer lines and keep two tidy tables: one for Registration and one for Attendance. 
4. Load each table to its own sheet (e.g., Registration_Clean and Attendance_Clean). 
5. Add a Summary sheet with simple pivots (e.g., conversion rate = unique attendees / unique registrants). (Optional) 

If you must keep everything on a single sheet: place the Registration block starting at A1, leave two blank rows, then place the Attendance block below, and add a bold separator line (e.g., “=== REGISTRATION ===” / “=== ATTENDANCE ===”) so nothing gets mixed. 

For your references:  

• Opening CSV UTF-8 files correctly in Excel - Microsoft Support 
• Power Query Text/CSV connector - Power Query | Microsoft Learn 

Option 2 - Power Query to automatically split and clean 

This makes it one‑click to refresh for every new report. Please go to:

1. Data > Get Data > From Text/CSV to load the file into Power Query. 
2. In the Power Query Editor, split the file into two queries by filtering around the labels/headers that mark the start of Registration and Attendance sections. 
3. Promote Headers for each query and standardize column names. 
4. Close & Load to Excel as two sheets (Registration, Attendance). 
5. Next time, just drop the new CSV in the same folder (same structure) and click Refresh All the workbook updates automatically. 

For your reference: How to process Teams attendance report with Power Automate. 

Please note that this information is being provided by the moderator solely for your convenience. The referenced sites are not managed or overseen by the moderator, and therefore we cannot guarantee the accuracy, security, or suitability of any software or content available there. We recommend reviewing all information carefully and ensuring you understand any associated risks before following suggestions from the provided link.  

Option 3 - Fully hands‑off with Power Automate 

With Power Automate, you can set up an automated flow that triggers whenever a new CSV file is added to OneDrive or SharePoint.

At a high level, the flow reads the CSV using the correct delimiter, separates the content into Registration and Attendance based on section keywords, and writes each data group into an Excel Online workbook as its own table. 

For your reference: Convert a CSV file into an Excel spreadsheet - Power Automate | Microsoft Learn 

In case you require more in-depth guidance or support for these steps, I’d recommend posting your query in the Microsoft Power Automate Community. This is a dedicated channel for Power Automate discussions. The reason I suggest posting a new topic there is that in the general Q&A Forum, resources and expertise on Power Automate are limited. In the Microsoft Power Platform Community Forum, you’ll find the most qualified group of respondents, and other partners who regularly read the forums can share their knowledge or learn from your interaction. 

I hope this information is helpful. Should you have any further questions or need additional assistance, feel free to reach out.    

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

Note: Follow the steps in our documentation to enable email notifications if you want to receive email notifications related to this topic.