Overview

Files imported into Adept are stored as datasets, which are tables composed of rows and fields (or columns).

Data transformations

No data transformations are performed during the import process. Therefore, the data you import must exactly meet the requirements described below.

Supported file formats and file size

Adept supports importing .csv and .tsv files up to 10 GB in size. .zip files are also accepted, provided they contain only a single file.

Formatting requirements

When preparing your files for import, please follow these strict formatting rules:

• Numbers
  • Do not use thousands separators.

// Valid number
1000000

// Invalid numbers
1.000.000
1 000 000

• Decimals
  • Use a comma , as the decimal separator for float and double.

// Valid float/double
250,55

// Invalid float/double
250.55

• Date-Time Format Check: This is not correct, we actually do not accept ISO8601

  • We offer flexibility for custom date-time formats, but the preferred one is ISO8601.

  // Preferred date-time format
  2026-01-06T15:24:49.122Z

  • When providing a custom date-time format to our csv parser, you must follow the Java format patterns.

  WARNING

  Java format patterns differ from those in other programming languages (Python, R, C and Unix-like systems), which follow the POSIX standard.
  
  

  Example: 2024-10-25

  Java format pattern	POSIX standard
  yyyy-MM-dd	%Y-%m-%d