How can I export search results headers to xls format? (4324439)

How can I export search results headers to xls format?

A user wants to generate a report or spreadsheet (XLS/CSV) containing the headers of search results (e.g., Sender, Subject, Date) for analysis. However, the Archive Manager website primarily allows exporting full email messages (EML/MSG) and does not have a visible "Export to Excel" button.

The Archive Manager web interface does not have a native feature to export the search grid directly to a CSV or XLS file.

However, you can utilize the Search Exporter tool to generate an HTML summary of the search results, which can then be opened and saved in Microsoft Excel.

To export search results to Excel, you must use the Search Exporter external tool and then import the resulting HTML file into Excel. 

Step 1: Install the Search Exporter Tool

1. Log in to the Archive Manager Website with Administrator privileges.

2. Click on the Administrator tab (top right).

3. Click Download Tools (bottom left menu).

4. Download and install the Search Exporter tool on your local machine.

   • Note: Do not run the tool yet. It is triggered automatically by the website in the next steps.

Step 2: Perform Search and Export

1. Return to the Search tab and run your desired query.

2. Once the results are displayed, click the Export icon located above the search results grid.

3. When prompted by the browser, choose to Open the file. This will automatically launch the installed Search Exporter tool.

4. In the Exporter window, select a Destination Directory for the files.

5. Click Start to begin the download.

   • Warning: This process exports the full content of every email in the search results. Ensure you have sufficient disk space before proceeding.

Step 3: Import into Microsoft Excel

1. Once the export is complete, open Microsoft Excel.

2. Go to File > Open and browse to the destination directory you selected in Step 2.

3. Change the file type dropdown from "Excel Files" to "All Files (.)" or "Web Pages".

4. Select the default.html file generated by the export and click Open.

5. Excel will convert the HTML table into rows and columns. You can now delete any unwanted columns (such as the message body links) and save the file as an Excel Workbook (.xlsx).

Because the Search Exporter downloads the actual email messages (.eml files) alongside the default.html index, this process can consume a large amount of disk space. Once you have saved your Excel file, you can safely delete the export folder containing the .eml files and the .html index to reclaim space.