Import

(1) Import: Before importing the CSV file, set its encoding and the separator used in it, and whether the header row contains the column names.

(2) Top row: The header row.

(3) Row below: Filter for the individual columns. Here you can enter search terms. Afterwards, only rows are displayed that contain the entered term as a substring in this column. Note: A search term can also be negated with a preceding exclamation mark "!".

Data manipulation via context menu

All columns and header columns can be edited by selecting them. In addition, further options are available via the context menu.

(4) Add rows: Inserts a row below the selected row.

(5) Add row: Inserts several rows, either below or above the selected row or at the end (selectable in a further dialogue).

(6) Delete row: Deletes the selected row.

(7) Delete all rows: Deletes all rows, but not the header and filter row.

(8) Add column: Adds a column on the far right.

(9) Add columns: Adds several columns on the far right.

(10) Delete column: Deletes a specific column that must be selected in a submenu.

(11) Clear all: Deletes all rows, including the header and filter row.

Export

(12) Quoting: Here you can select the quoting character for the column values when exporting (13).

(13) Export: This button starts the export. When exporting, the displayed data will be used. So, as you have edited them and as they are restricted by filters (3). The encoding, the separator and whether the header row should be exported is determined by the settings in (1).