Demo Dataset

Sample files that follow the Data Model.

Excel format

Sample XLSX file

CSV format

Sample CSV file Comma-delimited UTF-8 Recommandations

  1. Each record is one line - Line separator may be LF (0x0A) or CRLF (0x0D0A), a line seperator may also be embedded in the data (making a record more than one line but still acceptable).

  2. Fields are separated with commas.

  3. Leading and trailing whitespace is ignored - Unless the field is delimited with double-quotes in that case the whitespace is preserved.

  4. Embedded commas - Field must be delimited with double-quotes. A single cell with the text apples, carrots, and oranges becomes "apples, carrots, and oranges".

  5. Embedded double-quotes - In fields containing a double quote, the double quote must be escaped by replacing the single double quote with two double quotes.

  6. Embedded line-breaks - Fields must be surrounded by double-quotes.

  7. Always Delimiting - Fields may always be delimited with double quotes, the delimiters will be parsed and discarded by the reading applications.

Last updated

Was this helpful?