Column mapping

Before converting a table in CSV or Excel format, you can assign the columns of the table to the fields of the payment on this page. The fields depend on the selected payment type. To the right of each field, you can either use a drop-down list to select a column from the table, leave the field blank, or for some fields enter a fixed value below the drop-down list, which is then used for all rows in the table.

At the top of the list of fields is the checkbox Data contains header, with which you specify whether the first row of the table consists of column headings. In the row below that, you can select the Number format, i.e. whether a comma or period is used as decimal separator.

Below the fields, the assignment you configured is displayed as a preview with the values from the table. This makes it easier to make the settings and allows you to check them easily.

Figure: Form for assigning columns to fields