Saving Results as a CSV Spreadsheet

Saving results as a Text Export file generates a *.csv file that is plain text and not encrypted.  Files saved in this format must be kept secure.  These can easily be opened in Excel or another spreadsheet or database program but cannot be opened in Spirion.  To save your results in this format, click the Save As icon in the File ribbon.  Once you choose Save As, the Save As dialog box will open.  You may select the folder location and filename for your results.  You will see the Options button on the bottom right of this dialog.  Clicking the Options button will open the Text Export Save Options dialog box that allows you to choose what to include in your saved file and allows you to omit information depending on what type of file you are saving. The following save options are available:

• Please select the categories to include your Text Export: The checkboxes under this heading correspond to each of the columns in the Results View and allows you to select which information will be included in the saved file. For the Data Match itself, you can choose to save the Complete Match, the Last four characters only of the match, or the Last four characters of each match except for Credit Card Numbers which will save the first six and last four. Any characters that are not saved will be included in the saved file as an asterisk (*).
• Please select how you would like Multiple Matches saved: When a location contains more than one unique match, a row is displayed in the Results View that includes the words "Multiple Matches" and a total number of matches found in the location. There are several options for handling these types of rows:
  • Save Parent/Child Rows: This option will save the Multiple Matches rows and display the information in the saved file the same way as it appears in the Results View.
  • Repeat all information on every row:  This option will repeat the location and other information on every row of the saved file and create a matrix with no empty cells.
    • Show "Multiple Matches" rows: When repeating all of the information on every row, it may not be necessary to include the parent row summary as all of the information other than total number of matches per location is contained within the other rows and the total can be obtained by summing all of the rows for that location.
• Please select whether to save all or only selected results: By using the checkboxes in the Results View or ctrl/shift with a single left click, it is possible to select individual results in the Results View. The settings in this section specify which rows will be saved.
  • Save selected (checked) rows only:  This setting allows you to save the information from only rows selected in the Results View or all of the locations in the Results View.
  • Save parent rows only: This setting allows you to save only the parent row for each location which will allow you to have a summary of all of the locations with matches without having the individual data matches themselves saved in the file.