How to tell what is in a department?

The product export includes a column for the department, it will list the associated department for each product that has a department selected. The column will be blank for products that don't have a department selected.
Here is a link to our documentation on How Do I Export Products? for easy steps to export products.