Too many survey replies? Categorize and count them with ChatGPT
Upload a de-identified survey spreadsheet and ask ChatGPT to inspect columns, group comments and count replies, retaining row references for checks.
Execution environment and usage
AI / software
ChatGPT
Where to operate
ChatGPT chat with file upload and data analysis.
Getting started
- Attach the de-identified spreadsheet in ChatGPT.
- Ask it to identify columns before entering the analysis request.
Setup and plan requirements
Available file-upload and analysis allowance, plus permission to process the data.
Prompt portability limits
Adapt to a tool that can read spreadsheets and calculate. Text-only chat may not read attachments or run calculations.
Usage limitations
You supply the file; no survey-system connector is implied. Spot-check calculations and classifications.
Environment sources
適用情境 / When to use
Upload a de-identified survey spreadsheet and ask ChatGPT to inspect columns, group comments and count replies, retaining row references for checks. Small or self-selected samples may not represent all customers.
步驟 / Steps
- Remove names, phone numbers and identifying text from open responses.
- Upload the file and check columns, missing values and duplicates first.
- Request counts and row references, then spot-check categories and calculations.
提示詞 / Prompt
First inspect this de-identified survey for columns, missing values and possible duplicate responses. Explain how you identify duplicates; do not delete them without confirmation. Derive themes from the responses without forcing a fixed number. Give response counts, traceable anonymous row references and faithful summaries for each theme. Allow multiple themes per response; state the total valid response count and counting method. Include rare but important comments.
留意事項 / Cautions
- Small or self-selected samples may not represent all customers.
- Do not infer sensitive traits or invent missing responses.