Click here to Skip to main content
13,353,462 members (64,374 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


Posted 11 Jun 2012

SharePoint 2010 - Export Selected Items to Excel

, 10 Oct 2013
Rate this:
Please Sign up or sign in to vote.
Export custom list items to Excel in SharePoint 2010.

In SharePoint 2010, sites can export custom list items to Excel using the Export to Excel option in the ribbon toolbar. It will export all items in that particular view in which the option is invoked. SharePoint literally is not exporting the items it creates in the query file instead, which will have the view id and helps to query the SharePoint list data and the results are shown in the excel spreadsheet.

Now if I have a requirement something like, I need to export only specific items from the list. Let's say I want to export only 10 items out of 30 items shown in the view then there is no direct option for that. I need to create a view and apply filter to extract only the specific 10 items which I want to export. But I can' t create views every time to export any specific items. What if I don't have appropriate permissions to create views? To overcome these kind of issues, I have created a component which will export the specific items from the custom list. Its a custom action which will create the "Export to excel" ribbon button. Just selected the items and click on the button in the ribbon to export the items.

How To

  1. Deploy the WSP to the concerned web application
  2. Go to site features and activate the feature
  3. Use the export functionality in the custom list


You can download the WSP and code from here.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

United States United States
I'm interested in C#, AJAX, SilverLight,and SharePoint now. I enjoy listening to music, movies, driving.
I love posting answers to forums, especially questions related to SharePoint Technology. Started career as c++ developer, then .Net Mobile Technologies and SharePoint now.

You may also be interested in...

Comments and Discussions

QuestionSource Code? Pin
Member 22538649-Dec-15 11:30
memberMember 22538649-Dec-15 11:30 
QuestionNeed the source code of this wsp Pin
Member 1175842431-Aug-15 5:12
memberMember 1175842431-Aug-15 5:12 
QuestionWhere can I download the source code of this wsp Pin
Member 1161510417-Apr-15 0:17
memberMember 1161510417-Apr-15 0:17 
QuestionSharrepoint Online Pin
AlwinStephen1-Apr-15 2:06
memberAlwinStephen1-Apr-15 2:06 
QuestionExport Excel with grouping Pin
Khaniya2-Dec-14 22:26
memberKhaniya2-Dec-14 22:26 
QuestionNon-farm solution? Pin
Cynthia Dingman10-Sep-13 11:38
memberCynthia Dingman10-Sep-13 11:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180111.1 | Last Updated 10 Oct 2013
Article Copyright 2012 by Rajesh.Sitaraman
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid