ELM provides very powerful ways to manipulate the event data on your screen through customizable filters in views, reports and more, but sometimes that just isn’t enough. This tech tip article will walk you through a few quick and easy steps to export the contents of a view out to a file and quickly into Microsoft Excel for further formatting and customization.
We start with the console open and pick a View to export. In this example we’re going to take a look at All Messages — Errors View. The first step in this process is to click on the View itself so that the right pane of the console is populated with the events specific to that View. If you skip this and try to perform the function from another View in the list without first populating the right pane it will not work.
With the View selected we’ll simply right click and choose “Export List” near the bottom of the menu. Note there is an option to “Export To” at the top of the menu which gives the options of Clipboard or File, neither of which is the operation we want for this exercise.
After we choose “Export List” a dialog will prompt asking where we want to save the file and what type of file we want to save as. We’ve selected a drive on the MKTG machine for demonstration purposes. Next we’re going to name the file the same as the view “All Messages — Errors View” and choose a Text (Comma Delimited) CSV file. Click Save when done.
Now we’ll swing over to the local desktop, launch Microsoft Excel (version 2010 for this example), and then select the Data tab. From here we’ll start the import by clicking on the “From Text” button on the ribbon and another dialog will prompt us for the file we want to import. Here you can see the All Messages — Errors View.csv file we just created from ELM and saved to the D drive.
The Excel import wizard will then walk through the steps of properly formatting the imported text file, comma delimited in this case, and we will finish it up by selecting where we want the imported event data to be placed in a spreadsheet.
The event data has been dropped into a spreadsheet and can now be formatted, organized, and customized as needed per our requirements!
In just a few short steps you go from ELM Event View to Spreadsheet customization!
We hope that you found this article on How to Export Event Views to Microsoft Excel useful and wish you continued success with ELM.