How to Use the Content Query Web Part to Rollup Data in SharePoint 2013

The Content Query Web Part for SharePoint 2013 is a powerful tool that can be used to roll up data and aggregate content from SharePoint lists and libraries from a List, Site, or Site Collection.  In this post, we’ll show you how to add the Content Query Web Part to your SharePoint environment, as well as how to configure the Web Part and display roll-up data.

Add “Content Query Web Part” to site:

  • On the Edit Page, select the Insert Web Part tab. From there, select Content Rollup from Categories, and then Content Query from the Parts list:
  • Upon completing the steps above, you should see the following:

Configure the Content Query Web Part to rollup data:

  • To begin, select the source where the data you intend to roll up is currently being housed. This can be a Site Collection:
  • A selected site and all of its sub-sites:
  • Or a List:
  • Next, select the List Type and Content Type for the rollup:
  • With the Web Part, you also have the option to add Additional Filters in the event you need to filter data while performing the rollup:
  • Next, you have the option of adjusting the Presentation of your data by applying different Grouping and Sorting settings:
  • Once you have completed configuring the settings for your data rollup, click Apply and Ok to begin aggregating your content.

Display rollup data:

Once you have successfully completed the steps above, and the data rollup process has finished, you will be able to see the data that you rolled up in the Content Query Web Part:

Want to know more about out-of-the-box web parts available for SharePoint 2013? Check out the complete series: