反馈已提交

网络繁忙

Field Types that Can Be Correctly Recognized After the Excel File Upload

  • Last update：  2024-04-02

    • Overview

    FineBI supports adding an Excel dataset. You can upload Excel data in CSV, XLS, or XLSX. When you upload the data, BI will automatically determine the field types.

    This document describes the three Excel file formats that can be recognized as the correct data format when you upload Excel data.

    Uploaded Excel File in XLSX Format

    Date Types that Can Be Correctly Recognized

    Date Type
    2019/8/1

    2019-08-01

    2019/8/1 4:17 PM

    2019/8/1 16:17

    2019/8/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

    Customized Date Types that Can Be Correctly Recognized

    Customzied Date Type
    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

    2019/10/20 0:00

    00:00

    00:00.0

    1050192:00:00

    Numeric Types that Can Be Correctly Recognized

    Numeric Type
    General

    Number

    Currency

    Accounting

    Percentage

    Fraction

    Scientific

    Uploaded Excel File in XLS Format

    Date Types that Can Be Correctly Recognized

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

    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

    Customized Date Types that Can Be Correctly Recognized

    Customized Date Type

    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

    2019/10/20 0:00

    00:00

    00:00.0

    1050192:00:00

    Numeric Types that Can Be Correctly Recognized

    Numeric Type
    General

    Number

    Percentage

    Fraction

    Uploaded Excel File in CSV Format

    Date Types that Can Be Correctly Recognized

    Date Type
    *2019/8/1

    2019-08-01

    2019/8/1


    iconNote:
    Except for the types that can be correctly recognized above, the rest date types will be recognized as text types.

    Numeric Types that Can Be Correctly Recognized

    Numeric Type
    Numeric values with spaces

    Numeric values with the thousand separator ,

    Percentage with %

     


    Attachment List


    Theme： データセンター
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

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

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

    不再提示

    10s后关闭