Skip to content

Specify different datatypes in CSV files

To specify various datatypes in a CSV file, use the following rules:

  1. If the value is alphabetic or with a single quote ('), it is a string and the first apostrophe is stripped. For example, the following are all strings:

    • abc

    • 'abc becomes abc

    • '123 becomes 123

    • ''123 becomes '123

  2. If the input is recognized as numeric, the datatype is a Double. For example, the following are all converted to Doubles:

    • 100.00

    • 1

    • -100.00

    • -1

    • 0

  3. The following are all recognized as Boolean values:

    • True

    • TRUE

    • tRue

    • FALSE

    • false

  4. Anything that is not is considered a String.