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

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

Note:

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 %

Previous：SQL Dataset Preview Error Troubleshooting

Next：Excel File Upload Failure

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

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

Overview

Uploaded Excel File in XLSX Format

Date Types that Can Be Correctly Recognized

Customized Date Types that Can Be Correctly Recognized

Numeric Types that Can Be Correctly Recognized

Uploaded Excel File in XLS Format

Date Types that Can Be Correctly Recognized

Customized Date Types that Can Be Correctly Recognized

Numeric Types that Can Be Correctly Recognized

Uploaded Excel File in CSV Format

Date Types that Can Be Correctly Recognized

Numeric Types that Can Be Correctly Recognized

附件列表