Analyze Excel Data with ChatGPT
21 steps
Initiate Chat Session
Visit "ChatGPT"https://chatgpt.com/
Click "New chat"
Click button
Upload Feedback Data
Select "Add photos & files Upload from computer"
Desktop app screenshot
Click button
Select "Add photos & files Upload from computer"
Configure Analysis Prompt
Click "Work on anything"input field
Type
"
You are a senior product operations analyst. Analyze the attached TaskPilot customer feedback spreadsheet.
Please:
Group semantically similar feedback into clear issue themes.
Count how many feedback records belong to each theme.
Identify the affected customer segments and user roles.
Separate bugs, security risks, usability problems, and feature requests.
Assign each theme a priority of High, Medium, or Low based on:
Frequency
Severity
Customer impact
Churn or security risk
Importance to enterprise customers
Do not invent information that is not present in the spreadsheet.
Please provide:
A five-bullet executive summary
A table sorted by priority and frequency
Columns for: Theme, Feedback Count, Representative Feedback IDs, Affected Users, Business Impact, Recommended Action, Priority, and Reasoning
The five most important product improvements to work on next
Keep the analysis concise, practical, and in English.
"
Click button
Current screen screenshot
Current screen screenshot
Current screen screenshot
Current screen screenshot
Execute and Review Results
Click "Success metric"
Type
"
Based on the five highest-priority issues, create a practical 30-day product improvement plan.
For each initiative, include:
* Specific action
* Suggested owner role
* Estimated effort: Small, Medium, or Large
* Expected customer impact
* Success metric
* Recommended delivery order
Present the result as a clear weekly action plan.
"
Click button
Current screen screenshot
Click here
Click here
Current screen screenshot
