My manager requested some reporting based off of a SharePoint site that was created to be used as a support portal for our team.

I originally created an Excel spreadsheet with a data connection to the SharePoint site, but because he's running Office 2010, some of the graphs and queries that were running didn't work for him. He told me that he believes that SharePoint has some innate/built-in reporting capabilities, and suggested I reach out to you for advice on how to access them.

Does SharePoint actually have built-in reporting? Or is Excel the best option?

  • Reports of site usage or reports with data from lists and libraries?
    – mannaggia
    Commented Jan 13, 2018 at 1:02
  • Data from lists, in particular (hopefully able to be summarized and/or curated in some way).
    – phroureo
    Commented Jan 16, 2018 at 16:28

2 Answers 2


There is some basic built-in reporting at the Site and Site Collection levels. 1) Under Site Settings, Site Administration, Popularity Trends. 2) Site Settings, Site Collection Administration, Popularity and Search Reports.


There are several report solutions based on your report complexity.

Power Pivot

SSRS for SharePoint

Other front-end report libraries like Google chart

  • Thanks. Unfortunately, I'm but a minion of a much larger organization, so my account doesn't have access to link Sharepoint to SSRS (I already tried), so that option is a no-go. Option 2 also looks like I would have to be a SharePoint administrator, so that's not possible either. :( Thanks for the answer, though.
    – phroureo
    Commented Jan 16, 2018 at 16:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.