Azure Open AI Chat with Uploaded Excel

Question

Hi,

Can we use Azure Open AI Service to build an interface where user can upload excel and chat with uploaded excel?

Thank you?

Answer 1

Hi Avni Bhatt,

Thanks for reaching out to Microsoft Q&A.

Yes, it is possible to use the Azure OpenAI Service to build an interface where a user can upload an Excel file and chat with the data contained in the Excel file. Here are the key steps and considerations:

1. Data Preparation: Extract the data from the Excel file and send it to the Azure OpenAI API in your prompt. This can be done using the Power Query add-in for Excel, which is capable of calling the Azure OpenAI service2.
2. API Integration: Use the Azure OpenAI API to process the data. The API supports various file types, including .xlsx, but you will need to extract the data from the Excel file and send it to the API in a format it can process.
3. Data Ingestion: You can upload the data to Azure Blob Storage and then ingest it into an Azure AI Search index. This allows you to use the data with the Azure OpenAI service.
4. Function Calling: Some Azure OpenAI models allow you to define tools and tool_choice parameters to enable function calling. This can be set up through the REST API /chat/completions.
5. Customization: You can fine-tune the model by uploading training data in JSONL format. This data must be less than 512 MB in size and encoded in UTF-8 with a byte-order mark.

By following these steps, you can create an interface that allows users to upload Excel files and interact with the data using the Azure OpenAI Service

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.