AskTable Plugin User Documentation
Overview
AskTable provides two plugins: "One Sentence to Query Excel or Database" (plugin link) and "Excel Reader" (plugin link), which help users query data from Excel, CSV files, and various databases using natural language.
- One Sentence to Query Excel or Database: Suitable for scenarios where you already have an Excel file or database added to the AskTable platform and want to query data through an API.
- Excel Reader: Suitable for scenarios where you directly provide the Excel file URL and want to query the data in the file immediately.
Plugin Introduction
One Sentence to Query Excel or Database
Applicable Scenarios
- You have an Excel file or database that has been uploaded or added to the AskTable platform.
- You want to turn it into a chatbot that anyone can use to query data through conversation.
- You need to query data based on an API and hope to integrate it into your own business system.
Data Support Scope
- Excel Files: Up to 50MB, up to 10 worksheets, up to 5 million rows of data, up to 200 columns.
- CSV Files: Up to 100MB, up to 10 million rows of data, up to 50 columns.
- Supported Databases: MySQL, Oracle, PostgreSQL, StarRocks, etc.
Excel Reader
Applicable Scenarios
- You want to temporarily query data from an Excel/CSV file without uploading it beforehand.
- You have an online URL for an Excel file and want to use natural language to query its data.
- Suitable for scenarios where you need quick data queries, such as exam score inquiries or inventory data inquiries.
Data Support Scope
- Excel Files: Up to 50MB, up to 10 worksheets, up to 5 million rows of data, up to 200 columns.
- CSV Files: Up to 100MB, up to 10 million rows of data, up to 50 columns.
How to Choose the Right Plugin?
- If your Excel data has already been uploaded to AskTable and you want long-term use, choose "One Sentence to Query Excel or Database".
- If you have an online URL for an Excel file and just need a temporary query, choose "Excel Reader".