Oct 10 2022 09:26 AM
If I perform a search on a sharepoint list using the sharepoint site's top search bar, how can I export the results to Excel or CSV?
Oct 16 2022 10:58 PM
Hello @FGomesDSI
there is no OOTB way to export the search results.
You can use PowerShell to export search results into a csv, here are one article, you can search for more:
Regards, Dave
Oct 17 2022 04:27 AM - edited Oct 17 2022 04:33 AM
OOTB this is not possible. We have therefore extended the search bar functionality with sort and filters and also included an export to CSV option. Example
The custom search bar uses search rest api and the exported CSV contains the name, full URL and modified date. Which fields do you need?
Who is going to use the functionality? end-users or administrators or ...
If only administrators need it then PowerShell is also a pragmatic option.
Oct 17 2022 07:55 AM
Dec 06 2022 09:49 AM
@Paul_HK_de_Jong
Missed a bit of Context- is this a third party Plugin Search bar?
Dec 07 2022 12:06 AM
No, it is not a third party plugin search bar. It is part of an app that mimics File Explorer in a browser (link). The logic for the search bar (plus the sorting options and search filters, see example) can in principle be isolated and be included into a separate custom search bar App.
The search REST API is rich in functionality and performance is awesome. This allows for building apps that simplify use of SharePoint.