CSV

CSV (Comma-Separated Values) is a popular file format used for storing and exchanging tabular data.

You can fine-tune importing data from a CSV file with the following options:

Encoding

Specify the file encoding as one of:

  • UTF-8

  • UTF-16

  • Win-1250

  • Win-1251

  • Win-1252

  • Win-1253

The default encoding is UTF-8.

First row is a header

This checkbox option indicates whether the first row of the CSV file contains column names.

When checked, the app will treat the first row as headers, enabling you to map the data columns to their corresponding fields based on these names.

When unchecked, the app will interpret all rows as data. You'll need to reference particular columns by uppercase letters A, B, C, D, E, and so on.

Ignore inconsistent number of columns

This checkbox allows you to instruct the app to ignore rows in the CSV file that do not have the same number of columns as the header row. This can be useful if some rows have missing or extra data.

Start from line

This field allows users to specify the line number from which the app should start processing the CSV file. The default value is "1", which means processing will begin from the first line of the file.

Last updated