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: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
