Contents
Export the external list to Excel
- Navigate to the SharePoint site that contains the list.
- On the Quick Launch, select the name of the SharePoint list, or select Settings.
- Select List, and then select Export to Excel.
- If you are prompted to confirm the operation, select OK.
- In the File Download dialog box, select Open.
Open your SharePoint site in Internet Explorer. Navigate to either site permissions or any User group. Right-click on the users list page, choose the “Export to Excel” item.
What are the popular items in SharePoint 2013?
The Enhanced Search Capabilities and Analytics Processing Component in SharePoint 2013 provides a ready made solution for this. There are two types of usage report: 1.) Popularity Trends 2.) Most Popular Items This is an excel report showing daily and monthly usage statistics for item hits/users.
The simple solution to this tricky problem is to issue a dummy request to SharePoint to export the list data using following steps: Copy the URL issued to SharePoint by Command Button and analyze it.
1.) In the list/library, select the item for which report is required, 2.) From the ribbon, select Item/File tab (corresponding to List/Library) and there you will see a Popularity Trend button under “Share & Track” section. 3.) Click on this button, an excel file is generated and you can open/save this file to view report.
Where do I find popularity trends in Excel?
On the ribbon, click Popularity Trends. Click Open to open the Usage Details report in Excel. There’s one tab in the report for each item you selected. You can also see popularity trends for a page or item from the Most Popular Items view. Or, you can go to an individual page and select the PAGE tab > Popularity Trends.