Extract data from excel to vapi
# support
a
How can I make my Vapi bot read data from an Excel file to answer client questions? Any docs or examples for that?
v
Vapi does not support direct reading from Excel files, but you can use your Excel data by converting it to a supported format and uploading it as a Knowledge Base. Here's how: 1. Convert your Excel file to CSV or TXT format. 2. Upload the file in the Vapi dashboard under
Build > Files
.
3. Associate the uploaded file with your assistant in the Knowledge Base section. This enables your Vapi bot to answer questions using the data from your file. [See the Knowledge Base setup guide for details.](https://docs.vapi.ai/knowledge-base#how-to-create-a-knowledge-base) Source: - [Vapi Knowledge Base Documentation](https://docs.vapi.ai/knowledge-base#how-to-create-a-knowledge-base)
a
Is there a way to do it with make or another tools. Because the excel with the informations will take too many tokens and it will cost a lot @User @Vapi Support Bot @Shubham Bajaj
v
Yes, you can use Make (Integromat) to connect your Excel data to Vapi and avoid uploading large files as a knowledge base. Here's a high-level approach: 1. Set up a Make scenario to process your Excel file and expose the data via a webhook or API endpoint. 2. Configure a Vapi custom tool or webhook to call this endpoint when a user asks a relevant question. 3. Vapi will fetch only the needed data on demand, minimizing token usage and cost. For more details, see the [Vapi Tools & Integration Guide](https://docs.vapi.ai/tools#integration-tools). Source: - [Vapi Tools & Integration Guide](https://docs.vapi.ai/tools#integration-tools)
k
Upload the file via the dashboard or API to the assistant’s knowledge base, or use tools like the query tool. https://docs.vapi.ai/knowledge-base