Local file currently supports CSV and Excel.
Excel Version
Excel 97-2003 and above (inclusive)
Encoding Support
CSV files automatically detect file encoding; manual setting is not supported.
File Size Support
| Type | CSV | Excel |
|---|---|---|
| Maximum File Size | 200M | 20M |
Excel Formula Support
- Supports direct row and column references (A1, B2, etc.), does not support table references ([Column1], [Column2], [@Column3], etc.)
- Supports formulas starting with '=', does not support '{=...}' formulas. Supported Excel functions list is as follows:
ABS, ACOS, ACOSH, ADDRESS, AND, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, CEILING, CHAR, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, DAY, DAYS360, DEGREES, DEVSQ, DGET, DMIN, DOLLAR, ERROR.TYPE, EVEN, EXACT, EXP, FACT, FALSE, FIND, FIXED, FLOOR, FV, HLOOKUP, HOUR, HYPERLINK, IF, INDEX, INDIRECT, INT, INTERCEPT, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, LARGE, LEFT, LEN, LN, LOG, LOG10...
Custom SQL Support
Not supported