Reference: Supported File Formats for External Data in Tables and Datasets

Administrator Guide

To bring in non-Workday data as a table or dataset, Workday parses the data into records (rows) and fields. All characters must be UTF-8 encoded.

Tables and datasets support these source file formats:

Format	Description
Delimited Text	A delimited file is a plain text file format for describing tabular data. Comma-separated value (CSV) files are the most common delimited files. It refers to any file that: Is plain text (typically ASCII or Unicode characters) Has 1 record per line. Has records divided into fields. Has the same sequence of fields for every record. Records are separated by line breaks, and fields within a line are separated by a delimiter (usually a comma character). If the delimiter also exists in the field values, it must be escaped. Workday supports single character escapes (such as a backslash), as well as enclosing field values in double quotes (as is common with CSV files).

Format

Description

Delimited Text

A delimited file is a plain text file format for describing tabular data. Comma-separated value (CSV) files are the most common delimited files. It refers to any file that:

Is plain text (typically ASCII or Unicode characters)

Has 1 record per line.

Has records divided into fields.

Has the same sequence of fields for every record.

Records are separated by line breaks, and fields within a line are separated by a delimiter (usually a comma character).

If the delimiter also exists in the field values, it must be escaped. Workday supports single character escapes (such as a backslash), as well as enclosing field values in double quotes (as is common with CSV files).