ChatGPT's inability to read Excel files

I am a user of TeamPlan.

Lately, I have been experiencing frequent and prolonged errors with ChatGPT’s inability to read Excel files. Two days ago, there was an instance where it could not read an Excel file for over 12 hours, and today, after initially reading files successfully, it has started failing again.

I have been promoting ChatGPT’s data analysis capabilities to various companies because of its proficiency. In fact, I am scheduled to conduct a special lecture next week for over 100 HR and training managers of Korean companies. However, the ongoing issues are causing me significant anxiety.

I am supposed to demonstrate data analysis in front of these corporate employees, and it would be extremely embarrassing and terrible if I am unable to read Excel files during the demonstration.

This problem persists across multiple computers and locations.

Has anyone else experienced this issue?

9 Likes

Me too, have this issue, it gave me several error analyzing.

3 Likes

Having same issue, GPTs cannot seem to see Excel or CSV files:

2 Likes

This is definitely an issue. It is not reading csv, xlsx, or txt files. Big problem.

3 Likes

ChatGPT4 was able to provide very good analysis for data on two excel files that I uploaded. After that, it started to act up and I was not able to proceed with more files. Terribly upset as I have to finish the analyses within a short timeline. I see several feedback on the same problem in this forum but there were no response or solutions from OpenAI or other community users? Is this a bug or some kind of limitations? Hope someone can shed light on this issue and provide some workaround.

3 Likes

I’m also having the same problem. I upload the file in .xlsx, but ChatGPT reports that it did not receive any file.
Later, I cleaned the cookies and sent it again and ChatGPT informed me that it was unable to perform data analysis, as it had previously analyzed the same table.

3 Likes

I still see the same problem. OpenAI doesn’t seem to do anything about this problem. We are using a paid service!!!

3 Likes

I experienced an issue where I couldn’t read an Excel file, which appeared temporarily and then resolved over time. Fortunately, I haven’t encountered the same problem since then. However, looking at the comments, it seems many users have suffered from the same issue. I hope it gets fixed soon.

Last week, I encountered a new issue where GPT wouldn’t respond on the web. Even though I sent messages, there was no response. I searched for a solution and found that clearing the cache or using an incognito window could work, so I used it in incognito mode all weekend. I wonder when this problem will be fixed…

1 Like

I have the same issue. I uploaded a database of companies with columns for name, description, URL of company, category 1, category 2, category 3, category 4.

Category 1-4 are individual columns which indicate product categories they are involved in. Some companies just have 1 category, while some have all 4.

The issue is that when I ask it to list 20 companies in alphabetical order, it only checks the first category column (i.e. Category 1) and ignores the rest.

Does anyone have any tips on how to fix this? I want the GPT to list all companies by checking across all column categories.

1 Like

Why should I pay money for poor service?

1 Like

I continue to se this issue as well, even with a small xslx. Sometimes it works, at other times it doesn’t. Given the file isn’t changing, I think it’s likely traffic / environment stability with ChatGPT for this capability.

1 Like

I’ve tryed lot of stuff, but from this morning nothing seems to work, only a brief analysis and then this…

yesterday was working fine

Yeah. It occurred again. I’ve tested with two different account and it was same. Very frustrating.

2 Likes

Im also having the same problem. It just wont open an excel file now. and It had done a great job earlier.Even the same file that it had analysed so well, it wont open now.

2 Likes

what are we to do? Is there any person who is replying to these bug issues?

1 Like

I’m getting an error for both csv and excel files, but it worked fine yesterday. Today I get:

# Attempting to load the most recently uploaded Excel file
latest_excel_path = '/mnt/data/Copy of Heritage Social Media Calendar.xlsx'

try:
    # Reading the Excel file into a DataFrame
    latest_social_media_calendar_df = pd.read_excel(latest_excel_path)
    # Display the first few rows to check its structure and confirm successful loading
    success_message = "Excel file loaded successfully. Displaying the first few rows:"
    loaded_data = latest_social_media_calendar_df.head()
except Exception as e:
    success_message = f"Error loading Excel file: {e}"
    loaded_data = None

success_message, loaded_data

UPDATE: Exporting the spreadsheet to a PDF worked. It was able to successfully read the PDF file.

3 Likes

This works and it seems to be reading the data now after converting to PDF. Great idea!

1 Like

Same issue, it’s been two month already since the problems with data analysis and interpretation started. Though the direct input of data as a text works somehow, data analysis doesn’t happen at all :C

2 Likes