How to Export a Report from SmartSuite and Count Results in Microsoft Excel

If you need to count how many students are in each homeroom, SmartSuite can give you a list, and Excel can help you count them quickly.

Step 1: Export Your Report from SmartSuite

First, export your report as a CSV file. Follow this guide for step-by-step instructions:
👉 How to Export a Report from SmartSuite

Step 2: Open the File in Excel

1. Find the downloaded file (usually in your Downloads folder).
2. Double-click it to open in Microsoft Excel.

Step 3: Sort by Homeroom

1. Click anywhere in the data.
2. Go to the Data tab and click Sort.
3. Choose the Homeroom column and click OK.

Step 4: Count the Students

1. Select all the rows for a homeroom.
2. Look at the bottom right corner of Excel – it will show the Count.