CSV

Delimiters and structure

• The CSV delimiter can be configured per mapping

  (on the mapping header card under “CSV delimiter”).
• Default delimiter:

  Semicolon (;) commonly used in German-speaking or European locale contexts.
• Other common delimiters:

  • Comma (,)
  • Tab
  • Pipe (|)
• row 1 = Column headings,
• row 2 = data
• Encoding: UTF-8 is recommended.

Decimal separator (per column)

The decimal separator which can be configured per column helps when files originate from systems using a different locale (USA: period, Germany: comma).

• Automatic: Based on the Business Central server locale.
• For both periods (.) and comma (,): values such as 1,234.56 are interpreted correctly; commas used as thousands separators are removed.

If your CSV file uses commas as field delimiters and commas also occur in decimal numbers you must carefully align the delimiter and decimal separator settings; otherwise, parsing errors may occur.

German Excel “CSV” exports are often semicolon-delimited and use a comma as the decimal separator. In this case set the CSV delimiter to ; and the decimal separator to comma (,).