File requirements for Anaplan Data Orchestrator

You can upload CSV files into Data Orchestrator locally or through a connection with S3 or Azure Blob.

For local files, Data Orchestrator supports CSV files only. The file limit for local CSV files is 5 GB.

You can only upload the local CSV file manually. When the CSV file is uploaded, columns are uploaded as strings. 

Once you set up a link to the file, you can update the file with the same file or a new file. The new file must have the same structure as the previously uploaded file and have the same column headers (the content can be different).

CSV files uploaded locally must include these items:

• The first row must include the column headers.
• Every column must have a header.
• Each column header must have a unique name.

Don't include these characters in the column header names:

• Special characters (only use alphanumeric characters).
  Special characters are replaced by an underscore (_).
• White spaces at the beginning or end of the header name.

The file limit for CSV files is 5 GB. When the CSV file is uploaded, columns are uploaded as strings. 

For CSV files uploaded from S3 or Azure Blob, Data Orchestrator supports:

• Configuration of the column separators and text delimiter characters.
• Row number for the column headers.
• Start row for the data.

CSV files uploaded through a connector must include these items:

• Include column headers.
• Every column must have a header.
• Each column header must have a unique name.

Don't include these characters in the column header names:

• Special characters (only use alphanumeric characters).
  Special characters are replaced by an underscore (_).
• White spaces at the beginning or end of the header name.