python - Indexing excel files in Azure - Stack Overflow

I stored excel files in Azure Blob Storage and now I am trying to index the excel files using Azure AI Search but I could not do it. Everytime I try,it throws an error notification saying failed to create index.Can someone help me resolving the problem ? I want to build a chatbot using azure credentials where my bot can able to answer questions related to excel files.

I stored excel files in Azure Blob Storage and now I am trying to index the excel files using Azure AI Search but I could not do it. Everytime I try,it throws an error notification saying failed to create index.Can someone help me resolving the problem ? I want to build a chatbot using azure credentials where my bot can able to answer questions related to excel files.

• python
• azure
• chatbot
• openai-api
• azure-ai-search

Share Improve this question Follow asked Jan 2 at 11:58 Kavya KannanKavya Kannan 1 1

• Add the error details. – JayashankarGS Commented Jan 3 at 9:56

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You follow below steps.

Go to import data in ai search.

Next,

give data source as Azure Blob Storage, data to extract as Content and metadata and parsing mode as Default.

After configuring connection to the excel files folder click Next and go to customizing index.

There you keep the content and alter the required fields accordingly.

This creates index successfully.

Output:

i had 2 files one excel file and other csv file both are indexed.