Skip to content

File Format

Files uploaded to the platform must follow a specific format:

  • The data should be in CSV (Comma-Separated Values), xlsx, xls, or xlsb format.
  • The separator in CSV files must be a comma (,).
  • Decimal numbers should use a period (.) as the decimal separator.
  • Each row should represent a single record.
  • The first row must contain headers (column names) for each field.
  • The order of the fields in each row must match the order of the headers in the first row.
  • Missing values should be represented by an empty string or a placeholder value.
  • Ensure proper encoding (UTF-8 is recommended) to handle special characters correctly.

Most Common Issues

  • Date Formatting: When using Excel, be aware that date formatting may change based on your location.
  • CSV Separator: Ensure that when saving files in CSV format, you use a comma as the separator. Excel might default to using a dot or semicolon instead.
  • Thousand Separators: Avoid using thousand separators. For example, 100,000 might be split into two columns instead of being treated as 100000. In some European countries, 100.000 might result in 100 instead of 100000.
  • Text Fields with Commas: Ensure that text fields, such as a Product column, do not contain commas, as this can cause the data to split into multiple columns instead of remaining in one.