Hey everyone,
Since this morning, GPT-4 hasn’t been able to process any of the xlsx files I’ve sent over. I keep getting this message: “It seems I’m facing a technical issue that’s preventing me from analyzing the Excel file you uploaded. This might be due to specific file formats or data that’s not easily processed with the tools I have available.” Anyone else run into something like this?
5 Likes
I just checked, I’m having the same issue in the ChatGPT Interface.
Must just be something funky on OpenAI’s end.
2 Likes
Not a particularly helpful reply, but did you try CSV?
1 Like
I’ve been thinking of adding reading excel files to a GPT for just this reason. Something to just give some basic read commands and operations. I already have a GPT just for me that I’ve started throwing my random oh hey I need to do X operation a lot.
It came back to working correctly this morning. 
I had a problem when trying it on GPT4 but then I tried it on the dynamic mode and everything worked…
What is dynamic mode and how to use it? I have been trying to upload xlsx and cvs files with no luck.
when you go to the ChatGPT 4 - you can select the model to use … Dynamic use is under that menu - I was able to make it work under the Dynamic model- but be aware to complete the analysis as if you start (uploading the file) and then try to do it later or another day, it will not work . you have to re-authenticate and even then it has a problem… hope this helps…
Not seeing the ‘Dynamic’ option, all I see is GPT-4, GPT-3.5 and Temporary chat.
Same here. ChatGPT and Excel working together, would be an absolute game changer for everyone
I figured it out.
Steps:
- Using Pycharm or any Python API interpreter
- Copy the python code which is generated from ChatGPT into Pycharm
- make sure pandas and openpyxl are imported in the code.
import pandas as pd
import openpyxl - change the file_path and printf as an example below.
Save the DataFrame to an Excel file
file_path = ‘yourfile.xlsx’
df.to_excel(file_path, index=False)
print(f"Data has been successfully saved to {file_path}")
I am experiencing same thing now. July 16 2024. It worked a few days prior.
Unfortunately, I’m experiencing this bad behavior every now and then. Since this morning, I haven’t been able to access the custom GPT knowledge base bot built on XLSX or CSV files (plus the license).
I’m replying to myself to share what I’ve ‘learned’ from this buggy GPT-4 behavior: when I create a new custom GPT using the same instructions and the Excel files as the knowledge base, the new GPT works flawlessly at first. Unfortunately, even this new GPT stops working after a while.
1 Like
I have the same issue again. It works to start with then it just stops after a day or so and says it cannot access the Excel data.
1 Like