I have an Excel file containing more than 1,000 book titles. I need ChatGPT to find short information about each book and fill in the table with:
- The author.
- A very brief description (2-3 sentences about “what the book is about”).
If I give ChatGPT a task and input a single book title in the chat, it provides the correct response. However, when I upload the entire file, it only processes the first 8 entries and returns the file without filling in the rest, despite additional instructions.
Questions:
- How can I make ChatGPT complete this task?
- How should I write the prompt to ensure it processes the entire list?
- Would it be better to configure the workflow to avoid sending the file directly, perhaps by having ChatGPT fill the file via an API on Google Drive or another cloud platform?
This way, I can automate the process more effectively.
!?
I had the same issue, and this may or may not work for you as it does not always work for me, but add your Excel file to a Google sheet and make the Google public -shareable to anyone with the link. If it does not work, go back and make it private again. As I said, it is very hit or miss; good luck; the other option is to try a smaller batch at one time, try 25, then 50 … I did that as well and it worked on occasion.
1 Like
Maybe API, something like:
2 Likes
I just uploaded a .csv – you can save your Excel file as a .csv with over 10,000 book titles and other information. I asked ChatGPT (GPT-4o) to: `“Extract all of the book titles from this file and write a short description of each” It did it very quickly and created a new .csv file for downloading.
This is what the response looked like
I am not sure where the problem is. I am paid user, but I am not sure that makes a difference, You didn’t mention which model you used. I selected GPT-4o. I also used a .csv file instead of a Excel format file.
1 Like
To address the issues and streamline the process, you may need to breakdown the file. A custom GPT with detailed instructions and Actions, or a project that all of the “smaller chunks” added as Project files may help.
- Why ChatGPT Processes Only the First Few Entries
- This likely happens due to system constraints, such as time or token limits for a single interaction.
- Processing over 1,000 book titles requires breaking the task into manageable chunks.
- How to Make ChatGPT Complete the Task
- Break the Task into Chunks: Divide the list into smaller segments (e.g., batches of 100-200 rows) and process each batch separately. After each batch, append the results into the original file.
- Provide Clear Formatting: Use a specific prompt format so the tool knows how to parse and fill the file.
- Use Iterative Prompts: Repeatedly load and process chunks until all rows are completed.
1 Like