- Accessing the Interface Editor
- Adding Pipeline Context
- Adding Facets
- Removing Facets
- Adding Tabs
- Enabling Search As You Type
- Configuring Search Result Templates
- Adding the Export to Excel Feature to a Search Page
- Customizing the Localization of a Search Interface
- Identifying Your Interface Editor Version
- Legacy Interface Editor Overview
.xlsx file). The Excel file contains the values for all the fields of the exported search results.
The Export to Excel option is typically included within the
Settings component that exposes a button on the right of the search box.
When using Microsoft Edge, you cannot export a query that contains over 1,000 characters. You are encouraged to use another browser.
With this version:
The Export to Excel option is available by default in the search interface sample files included in the package.
The Excel file contains the field values of the first
100search results of the current query sorted by Relevance. In previous versions, the file contains the field values only for the search results of the currently displayed search page which is typically
You can specify the maximum number of search results to export using the
data-number-of-resultsattribute of the
Using an administrator account, navigate to the Coveo search page for which you want to create a search result template, and then access the Interface Editor (see Accessing the Interface Editor from Coveo Cloud V2 Hosted Search Pages or Accessing the Interface Editor in Coveo for Salesforce V2).
ExportToExcelcomponent to the HTML markup of the page (see ExportToExcel Component):
In the Interface Editor, in the upper-right corner, click the Code View tab.
In the HTML markup:
coveo-search-sectionclass containing a
<div id="search" class="CoveoBox" data-design="new"> ... <div class="coveo-search-section"> <div class="CoveoSettings"> </div> <div class="CoveoSearchbox" data-enable-omnibox="true"> </div> </div>
CoveoSettingsclass, add the
.CoveoExportToExcelvalue to the
<div data-include-in-menu=".CoveoShareQuery,.CoveoExportToExcel,.CoveoPreferencesPanel" class="CoveoSettings">
The order of the attribute values determines the order of appearance of the options in the menu. Therefore, the option corresponding to the last attribute value is displayed at the top of the menu.
Add the following
<div class="CoveoExportToExcel" data-number-of-results="100"></div>
where you can set the maximum number of exported search results using the
divcan be anywhere under the main
CoveoSearchInterfaceclass) of the page.
When the default value is
100, the export creation takes about 1 second to complete. Increasing the value progressively increases the time needed to create the export file. It is not recommended to go above
1000, which is the index default maximum number of results.
In the Interface Editor, in the upper-right corner, click the UI View tab.
In the search interface, click the More icon () on the right of the search box to validate that the Export to Excel option is now available.
In the Interface Editor, in the upper-right corner, click Save.
In the published search interface, perform a search, click the More icon (), and then click the Export to Excel option.
A Microsoft Excel file is built and downloaded containing the number of search results you specified.
Open the downloaded Microsoft Excel file, and then review the data.