Import Settings

Import settings tab contains basic settings for your file

Let's look into Import Settings tab. You would find a variety of settings here that are related to format of your file.

The first settings is related to the first row of your spreadsheet file. Usually you would use first row for names of your columns and actual data would start in the second row and on. If this is the case, you need to check the first setting. This option is enabled by default.

Different filetypes use different symbols for delimiting columns. CSV (Comma Separated Values) files are using commas for this purpose. When saving your file you can also use semicolon or other symbol. Use your symbol in this setting for a correct import.

The next setting is also a part of CSV file format. Sometimes values in CSV file are wrapped in quotes, so that commas inside of values are not confused with commas that are delimiters. Input your enclosure for a correct input.

If you are importing some dates with times you would need to input your datetime format in the next field. For example yyyy-dd-MM hh:mm tt or dd.MM.yyyy hh:mm:ss.

Decimal delimiter is used when importing numbers. In some regions people use dots (for example 1.5), and in other people use commas (for example 1,5).

Depending on entity that you are importing, you would find more settings under this tab. Refer to corresponding entity under Column Mapping section for additional information about these settings.

Last updated