Hi - I’m looking to develop a pickaxe where the users can upload some data in an excel file and the Ai will provide some analysis and summary.
After querying the chatbot a lot I have come to understand that when and excel / csv (by the way .csv files seem to not be uploading at the moment) is uploaded all the chatbot receives is a preview of the file in JSON or similar format. This includes just a small number of actual data rows depending on how many columns it has.
After some research it seems this process is common for custom GPTs, and people suggest writing a python script using pandas library to import the whole file into markdown for the chatbot to work with. I tried to do this but the chatbot tells me all it can access is the JSON preview and does not have access to the file itself.
So my question is would this be possible within pickaxe chatbots - for the chatbot to have access the entire excel file itself so it can import the full thing through python or would we be restricted that the actual excel file is not accessible?
PS. I understand I can ask the chatbot to write excel macros based on the preview it receives to analyse things and have the user run them. But I’d like this functionality as it would be much more user friendly.
Thanks!