I need a functionality to export search results to Excel for SharePoint. I've researched a lot and found many answers though no blog provides end to end solution. Best I could find is: Catch search object that's returned and work on it. I'm not sure how to proceed on it. Also, is it possible to make a generic App which when added, will provide a button to export to excel option?

Update: At the moment I using REST to hit the server and parse objects. Problem is that I've to export 60,000 records and REST doesn't return more than 500 per search.

Environment: SP 2013 EE.

  • What exactly do you want to export? The managed properties, the binary documents? How will you choose what properties to include? Aug 31, 2015 at 19:34
  • @MatthewMcDermott CT targets multiple lists. So, only managed properties will be exported.
    – vikbehal
    Sep 2, 2015 at 5:55

1 Answer 1


Since search results are just JavaScript and HTML you could create a Control Template and Display Template that presents your results, then add your own feature to Export the data.

Look at something like this sample: http://dhtmlx.com/docs/products/dhtmlxGrid/samples/12_initialization_loading/13_pro_load_csv.html

Any JavaScript that can serialize the data will work.

  • We are displaying results in tabular format. Is there a way to catch the search result object in SharePoint? Exporting current page isn't the solution since search results spans across multiple pages.
    – vikbehal
    Sep 4, 2015 at 6:44
  • You could re-execute the query without paging using REST and dump the whole dataset using the same CSV export code. Sep 4, 2015 at 22:13
  • We've more than 60,000 records. REST doesn't return more than 500 records.
    – vikbehal
    Sep 7, 2015 at 9:13
  • OK, you didn't mention that. That's a totally different scenario. Sep 8, 2015 at 12:04

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.