CSV Editor

With the CSV editor you can import CSV files, manipulate them in a grid and then export them again.

Import


images/download/attachments/137310341/1638-version-1-modificationdate-1689729462656-api-v2.png


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

(2) The header row.

(3) 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 (!).

(4) Opens another tab.

Data Manipulation


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


images/download/attachments/137310341/1639-version-1-modificationdate-1689729462666-api-v2.png


(5) Inserts a row below the selected row.

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

(7) Deletes the selected row.

(8) Deletes all rows, but not the header and filter row.

(9) Adds a column on the far right.

(10) Adds several columns on the far right.

(11) Deletes a specific column that must be selected in a submenu.

(12) Deletes all rows, including the header and filter row.

Export


images/download/attachments/137310341/1640-version-1-modificationdate-1689729462676-api-v2.png


When exporting, the displayed data will be exported. So, as you have edited them and as they are restricted by filters (3).

In (13) you can select the quoting character for the column values.

The encoding, the separator and whether the header row should be exported is determined by the settings in (1).