10.2 Importing Statistics
The statistics downloaded from LISTSERV Maestro are in CSV format. They can easily be imported into Microsoft Excel in order to create tables, graphs, and other forms of reports. LISTSERV Maestro comes with an easy to use Excel Add-In that makes this import process a matter of a few clicks.
The add-in must be installed into Excel before it can be used. This step is done only once on each local computer, before the add-in is used for the first time. Click the download link located on the "Download Report Results" screen to download the add-in file to a local drive. The name of the file to download is ImportTrackerStatistics.xla
Follow the steps described below to install the add-in into Microsoft Excel 2000:
Download the data to be imported into Excel. The data is downloaded in a compressed ZIP file. Open the ZIP file. There are two files contained inside, a readme.txt file and another file named for the type of data downloaded. Extract the *.txt files and save them to a location on the local drive.
The readme.txt file will contain a summary of the report type and other information. The other file, named for the type of data downloaded, such as distributionReport.txt or uniqueSumReport.txt contains the data that will be imported into Excel. Start Excel and click on the Visualize Tracking Statistics button in the toolbar, it looks like two small footprints, see figure 67.
The Visualizing Tracker Statistics import dialog box will open. Select the "Import and convert a downloaded tracking data file" option button to create a new workbook and generate a chart based on the downloaded tracking data. Select the "Convert the current worksheet" option button, to create a new chart in the current workbook based on the data of the current worksheet. Click Start to proceed.
After clicking the Start button, a file selection box will open. Navigate to the *.txt file with the tracking data previously downloaded and open this file. Excel will automatically open a new workbook. Once the workbook has been created successfully, save it using the Save Statistic File dialog box. After the file had been saved, a message will appear saying the data has been successfully imported and saved as an Excel Workbook. Click OK to close the message.
The new workbook has two sheets. The first sheet shows the imported tracking data in chart form. The second sheet contains a value table with the downloaded tracking data.
It is now possible to use all the regular Microsoft Excel features to edit and adjust both the graph and the data table.