Exporting Search Results to Microsoft Excel from a JavaScript Search Interface
Examples: A few scenarios where exporting search results to Excel may speed up people's work:
-
A sales person searches for his last quarter won deals, exports the results, copies the customer name and amount columns, and then pastes the information in a report.
-
An engineer searches for internal documents that are most relevant to a specific topic, exports the results, and then in Excel sorts rows by authors to see which names come more often to help him identify potential subject matter experts within his company.
-
A support agent searches for all cases opened by employees of one company during the past year, exports the results, copies the case title, date, requester, and resolution time columns, and pastes them in a table in an email to his boss who requested this information.
To export search results to Microsoft Excel from a JavaScript Search Interface
-
Access your Coveo JavaScript Search interface.
-
Using keywords and facets, leverage the search interface to create a list by gathering the documents from which you want to extract information.
-
On the right of the search box, click the Settings button, and then select Export to Excel.
Your browser manages the Excel file download.
The file name is UTC timestamped and in the form: [your_keywords]--yyyy-mm-dd--hh-mm-ss.xlsx
Notes: If the Settings button or the Export to Excel option do not appear in your search interface, contact your administrator that can add them (see Adding the Export to Excel Feature to a JavaScript Search Page).
-
In Microsoft Excel or another compatible application:
-
Open the downloaded file.
Each row corresponds to one search result and each column contains the value of on field for each result.
Note: By default, the exported Excel file contains a maximum of 100 search results sorted by Relevance. Your search interface administrator may however customize the maximum number.
-
Locate the column(s) containing the information of interest, and do whatever you want with the information, such as copying and pasting the information into another document.
-