As of today, OpenAI hasn’t been able to answer accurately from excel files. We have tested it for multiple customers at Kommunicate. We have come up with a solution using Pandas AI library.
There are multiple ways to solve it:
- Convert the user input to a filter criteria and then run it against the excel sheet
- Directly use Pandas AI library which internally uses some prompts to generate python code to get the answers. Based on our research its almost near to accurate answers.
Flow for #1 Approach
Alternatively you can use our product Kommunicate to achieve the same