Export as CSV

Added in 3.1.1Professional Edition

If you need to export all your scan values and scan information, click File › Export › CSV via Main Menu. The resulting CSV file can be used to create spreadsheets for Microsoft Excel or other external software programs. In figure 1 the Export as CSV Dialog is shown.

Export CSV Dialog
Figure 1: Software dialog "Export as CSV" with several export options

First, select the designated folder and filename for your CSV file. If you check the option Open CSV after Export, an external software program, that has been associated with the CSV file extension, will open up after your CSV file has been exported.

For that, you have to select what kind of information you would like to include in your generated CSV file. The file will be created using the UTF-8 character encoding.


Following export options are available:

  • Characteristics
    Check this option to embed your individual project information (title, description, GPS coordinates, field length and width, operating mode). These kind of information can be added to your measurement as described in section Scan Information / Characteristics.

  • Meta Data
    Check this option to include all your individual Meta Data in the exported CSV file.

  • Soil Type
    Check this option to embed additional information regarding the selected soil type (dielectric constant, relative permeability, mineralization, humidity, homogeneity). If you are using the Professional Edition of OKM Visualizer 3D Studio, you may add your own soil types as described in section Soil Types.

There are some more export options to define the output format of the resulting CSV file itself:

  • Column Separator
    The column separator, which is a single character, is used to separate all of the selected columns (see below).

  • String Delimiter
    If one of the selected column contains the character, that has been chosen as column separator, any external program interprets this as the end of the column rather than as part of the text. In order to prevent this, it must have a string delimiter. This string delimiter is placed around each column. The default string delimiter is double quotes (").

  • Decimal Separator
    Select either comma (,) or point (.) as your decimal separator of choice.

  • Decimal Places
    Select the number of decimal places in the range from 0 to 8.


Additionally, you can decide which columns you want to embed into the resulting CSV file. The number and type of available columns may vary from measurement to measurement. Figure 1, as an example, represents all columns of a Ground Scan.

  • Apply Active Modifiers
    Check this option if all active Modifiers (Interpolation, Subdivision, etc.) should be applied before exporting the scan values. If you intend to export raw scan values, as received from the detector itself, keep this option unchecked.

After setting up all your export options and columns, click on Export to start generating your CSV export file.