CSV File Requirements

Before you upload a CSV file or a plain text file into your workspace, ensure that it meets the following requirements:

  • Up to 1 GB
  • Up to 250 columns
  • Up to 255 characters per cell
  • Delimiters:
    • Comma (,)
    • Semicolon (;)
    • Vertical bar (|)
    • Tab ()
  • The date in a supported format
  • Decimal separators:
    • Comma (,)
    • Dot (.)
  • (Only for CSV Uploader; see Use CSV Uploader for Ad-hoc Analysis) At least one column that contains numbers (measurable data)

    The measurable data is converted to facts with the DECIMAL(15, 3) data type. The numbers with a greater scale are truncated to three decimal places and rounded up/down.

Contents:

Supported Date Formats

  • The order of day, month, and year:
    • dd-mm-yyyy
    • mm-dd-yyyy
    • yyyy-mm-dd
    • dd-MMM-yyyy
    • MMM-dd-yyyy
    • yyyy-MMM-dd
    • MMM dd, yyyy

    The MMM month specifier requires the month as an abbreviation (Jan-Dec) and is not case-sensitive.

  • Separators:
    • Dash (-)
    • Slash (/)
    • Dot (.)
    • Space ( )
    • No separator as in yyyymmdd
  • The year between 1900 and 2050 inclusive
  • No time stamp

Two-digit Year Format

 The following date formats support the two-digit format of the year:

  • dd-mm-yyyy
  • mm-dd-yyyy
  • yyyy-mm-dd

That is, 18-08-14 and 18-08-2014 are interchangeable and will both work.

If you use the two-digit year format, consider the following:

  • The values from 00 to 68 inclusive refer to the years from 2000 to 2068 correspondingly.
  • The values from 69 to 99 inclusive refer to the years from 1969 to 1999 correspondingly.

Let's look at some specific cases:

  • If you use the yy-mm-dd format, the date 66-12-12 will not be accepted: according to the rules, it refers to the year of 2066, and 2066 is outside of the allowed range (which is, between 1900 and 2050 inclusive).
  • If you use the yymmdd format, the date 661212 will not be accepted as a date for the same reason as in the previous case. Instead, it will be treated as a measure.

One-digit Day and Month Format

All date formats support both one-digit and two-digit formats for a day and a month.

That is, 01-08-2014 and 1-8-2014 are interchangeable and will both work.

Examples of Dates

The following dates are supported and will work well:

  • 18.8.2014
  • 08 18 2014
  • 08-18-14
  • 18/08/14
  • Aug-18-2014
  • 2014.aug.18
  • 18 AUG 2014
  • Aug/18/2014
  • Aug 18, 2014

The following dates are not supported and will not be accepted:

  • August 18, 2014
  • 8\18\2014

Using a Comma as a Delimiter and as a Decimal Separator

  • If you use a comma (,) as a delimiter, use a dot (.) as a decimal separator.

    product_name,category,price,quantity
    Shirt,Clothing,100.33,1.00
  • If you use a comma (,) as a decimal separator, use a semicolon (;), vertical bar (|), or a tab () as a delimiter.

    product_name,category,price,quantity
    Shirt;Clothing;100,33;1,00
  • If you have to use a comma (,) both as a delimiter and as a decimal separator, put decimal numbers inside double quotation marks.

    product_name,category,price,quantity
    Shirt,Clothing,"100,33","1,00"
Powered by Atlassian Confluence and Scroll Viewport.