List view

To see the data in a spreadsheet, choose View → List view … from the menu. A window will open where all names from the query will be listed.

Customize visibility of fields

To change the selection of the visible fields, click on the Column visibility button. A window as shown below will open, where you can change the visibility of the columns.

 

Customize sequence

To change the sequence of the columns, just use your mouse to drag the columns to the position of your choice.

Sorting of the data

To sort the data in the grid just click in the header of the column which you want to use as sorting column. The sorting sequence will be kept even if you change values in this column. That means that if you change a value in the sorting column the changed dataset will be placed at the new position according to its new value. The sorting of a column will be indicated with an arrow for the direction of the sorting (up or down).   

Change to data in main form

To change to a name in the main form, click on the , use the button. 

Formatting the grid

To adapt the width of the columns or the height of the rows either drag the border with the mouse, double click the border to get the optimal size for one column or respectively or click on the button for an optimal height of the rows or the button for an optimal width of the columns.

Exporting data Video starten

After setting the form according to your preferences, you can export the data with a click on the button. If the data should be appended in an existing file, change the option for the file handling from (= New file) to (= Append). The botton opens the folder containing the exported file.