反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

Upload Field Types That Are Correctly Recognized By Excel

  • Recent Updates: August 19, 2022

    • 1 Overview

    FineBI supports add EXCEL dataset , users can upload csv , xls, xlsx three formats of Excel data, BI will automatically determine the field type when importing.

    This article explains that when uploading Excel, three Excel file formats can be recognized as the correct type data format after uploading.

    2. Upload the Excel file in xlsx format

    2.1 Date types that can be correctly recognized after uploading

    Date Type

    2019/8/1

    2019-08-01
    2019年8月1日
    2019年8月
    2019/8/1 4:17 PM
    2019/8/1 16:17
    2019/8/1
    8月1日
    星期四
    Thursday
    August 1, 2019
    August 2019
    August 1
    19/8/1
    8/1
    8/1/19
    08/01/19
    1-Aug
    1-Aug-19
    01-Aug-19
    Aug-19
    August-19
    A
    A-19

    2.2 Custom date types that can be correctly recognized after uploading

    Custom Date Type
    October 2019
    October 20
    2019/10/20
    2019年10月20日
    10/20/19
    20-Oct-19
    20-Oct
    Oct-19
    12:00 AM
    12:00:00 AM
    0:00
    0:00:00
    0时00分
    0:00:00
    12:00 am
    12:00:00 AM
    2019/10/20 0:00
    00:00
    00:00.0
    1050192:00:00

    2.3 Numerical types that can be correctly recognized after uploading

    Numeric type
    常规
    数值
    currency
    Accounting only
    percentage
    Fraction
    scientific notation

    3. Upload the Excel file in xls format

    3.1 Date types that can be correctly recognized after uploading

    Date Type
    2019/8/1
    August 1, 2019
    2019-08-01
    August 1, 2019
    August 2019
    August 1
    August 2019
    8月1日
    星期四
    周四
    2019/8/1 4:17 PM
    2019/8/1 16:17
    19/8/1
    8/1
    8/1/19
    08/01/19
    1-Aug
    1-Aug-19
    01-Aug-19
    Aug-19
    August-19
    A
    A-19

    3.2 Custom date types that can be correctly recognized after uploading

    Custom Date Type
    October 2019
    October 20
    2019/10/20
    2019年10月20日
    10/20/19
    20-Oct-19
    20-Oct
    Oct-19
    12:00 AM
    12:00:00 AM
    0:00
    0:00:00
    0时00分
    0时00分00秒
    12:00 AM
    12:00:00 AM
    2019/10/20 0:00
    00:00
    00:00.0
    1050192:00:00

    3.3 Numerical types that can be correctly recognized after uploading

    Supported Numeric Types
    conventional
    Numerical value
    percentage
    Fraction

    4. Upload Excel file in csv format

    4.1 Date types that can be correctly recognized after uploading

    Date Type
    *2019/8/1
    2019-08-01
    2019/8/1

    Note: Except for the above correctly recognized types, the rest are recognized as text types.

    4.2 Numerical types that can be correctly recognized after uploading

    Numeric type

    pure numeric value with spaces

    Pure numeric values with , thousand characters

    Percentage with %


    Attachment List


    Theme： Data Processing
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭