How to create a grouped PivotTable in Excel Grouping is what Excel’s PivotTable objects do, and it’s easy to summarize groups of data using any number of functions.

To do this, select the imported data and navigate to the Insert section in Excel. Then, click on Table. You'll now have a table structure along with the imported data that is ready to be worked on.