Exporting spreadsheet data/reports
Contents
You can save data from spreadsheet and list dialog boxes by exporting it to a file. By exporting spreadsheet data and views to a file, you have a backup copy of a report to reference later or import into another case. This is especially helpful if you have organized fields into a spreadsheet view that also include custom fields.
When you export data, CaseMap creates a text file and loads the data from the spreadsheet or list dialog box into it. The format of the data in the text file is based on the file type you select during the export.
Export data to the following text file formats:
| • | Delimited text files — A text file where each field value is separated by a comma or tab character. |
There are two comma delimited text file types: .csv and .txt. The .csv file type allows you to open the file using Microsoft® Excel without having to modify the format of the file. The .txt files requires you to format the file prior to viewing it in Excel.
| • | Non-delimited text files — A text file where each field value is displayed on a separate line. |
Data export considerations:
| • | If spreadsheet data has been filtered, then only the filtered data or current spreadsheet view will be exported. |
| • | The tag field and any tag icons for case records are not loaded into the export text file. |
| • | Data from check boxes and Evaluation fields displays as text instead of icons. Text files cannot display graphic images. |
 |