Skip to main content

What kind of Excel/CSV files does AskTable support?

AskTable supports Excel (.xlsx/.xls) and CSV (.csv) files as data sources, but to ensure accurate data parsing, the following rules and limitations must be followed when using them.

1. File Size and Content Limitations​

Excel Files (.xlsx/.xls)​

  • File size: Maximum supported is 10MB.
  • Number of sheets: A single file can have up to 20 sheets.
  • Column limit: Each sheet can have a maximum of 30 columns.
  • Table structure: A single sheet can only contain one table, so if there are multiple tables (e.g., one on the left and one on the right), that sheet will be ignored.
  • Header position: The header must be at the top, not on the left.
  • Number of header rows: Up to 5 rows.
  • Suggested header column name length: For better recognition, header column names are suggested not to exceed 6 Chinese characters or 18 characters.
  • Avoid totals row: The bottom of the table should not include data rows such as "summary" or "total", as it may affect the calculation results.

CSV Files (.csv)​

  • File size: Maximum supported is 20MB.
  • Row limit: Up to 5 million rows.
  • Column limit: Up to 30 columns.
  • Table structure: A CSV file is considered as a single table.
  • Header: A header is optional; if present, it can only be 1 row.
  • Suggested header column name length: For better recognition, header column names are suggested not to exceed 6 Chinese characters or 18 characters.
  • Avoid totals row: The bottom of the table should not include data rows such as "summary" or "total", as it may affect the calculation results.

2. Data Source Management Rules​

  • Multiple Excel and CSV files can be combined into a single data source (Datasource).
  • A single data source can support up to 100 tables.

Following the above rules ensures that AskTable correctly parses the data and improves query accuracy. If special requirements exist, please preprocess the data before uploading.