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?
I’ve a CT which targets multiple lists. So, only managed properties will be exported.
Here is a sample of code.. This will allow you to export to csv. You can then convert csv to excel and then format it they way you want. I added the upload to sharepoint list piece as well. Do with this what you want.. BTW, this works with SP2010.. I have not done this with SP2013 yet. check this out also: https://code.msdn.microsoft.com/office/Query-Search-with-the-372139b5
You can do this with Powershell.. I will provide you a sample script. The formatting of the excel wont be what you like, but you can manually format it.
The answer depends on your version of SharePoint.
You could try to make sure the SharePoint search results come back as an XML and suck them into Excel that way – or look at the Opensearch and srchrss.aspx pages.
Do you have that script?