You ran a customer survey. Good. You even included an open-ended question like “What could we improve?” Great.
Now you’ve got 300 free-text responses sitting in a spreadsheet, and nobody has time to read them. That survey just became expensive digital confetti.
This is the most common place small businesses waste survey effort — not in *getting* responses, but in actually *doing something* with them. Especially the open-ended ones, where customers tell you exactly what’s wrong in their own words.
Reading and categorizing hundreds of text responses by hand can easily take a full workday of tedious spreadsheet tagging. Most small business owners just… don’t.
Artificial intelligence (AI) fixes this in about five minutes.
The Copy-Paste Workflow That Replaces a Weekend of Reading
Here’s the simplest version. No special software required.
**Step 1:** Export your survey responses to a spreadsheet or text file. Just the open-ended answers.
**Step 2:** Copy them into ChatGPT or Claude. Both offer paid subscriptions — check [openai.com/chatgpt/pricing](https://openai.com/chatgpt/pricing) and [anthropic.com](https://anthropic.com) for current rates, as pricing can shift.
**Step 3:** Use this prompt: *”Categorize these survey responses by theme and sentiment, rank by frequency.”*
That’s it. You’ll get back grouped themes showing what customers mentioned most, whether the sentiment was positive or negative, and roughly how often each issue came up.
One quick heads-up: AI can sometimes miscategorize responses, especially sarcastic or ambiguous ones. Give the output a quick scan to make sure the groupings make sense before you act on them.
A restaurant owner asking “What could we improve?” might get back something like: wait times mentioned frequently with mostly negative sentiment, menu variety mentioned with mixed feelings, staff friendliness mentioned often and overwhelmingly positive.
Instead of a day of reading, you’ve got a clear picture in minutes.
Take It One Step Further
Once you’ve got your themes, paste the same data back in with this follow-up prompt: *”Based on these responses, identify the top 3 issues, estimate their severity based on frequency and sentiment, and recommend one specific action for each.”*
Now you have a prioritized action list you can work from *today*. No analyst, no consulting firm.
What About AI Survey Builders?
Tools like SurveyMonkey and Typeform now offer AI features that generate survey questions from a plain-English description of what you want to learn. Both offer paid individual plans — check [surveymonkey.com/pricing](https://surveymonkey.com/pricing) and [typeform.com/pricing](https://typeform.com/pricing) for current rates, since both platforms have restructured their pricing multiple times in recent years.
They’re handy for eliminating the blank-page problem when you’re designing a survey. But honestly, the bigger win is on the analysis side. Creating questions is a one-time task. Making sense of hundreds of answers is where your time actually disappears.
A Quick Note on What We Don’t Know
Vendor marketing pages throw around claims like “save 10 hours per week,” but we couldn’t find independent studies backing up specific numbers for small businesses. The time savings are real based on the workflow — copying 300 responses and getting categorized results back in minutes versus reading them manually — but we’re not going to cite made-up statistics to sound impressive.
Your Takeaway
If you’ve got survey responses collecting dust because nobody has time to read them, open ChatGPT or Claude and paste them in with that categorization prompt. Five minutes, the cost of a paid AI subscription, and you’ll finally know what your customers have been trying to tell you.
*Disclosure: As of publication, Excubitor AI has no affiliate or sponsorship relationships with OpenAI, Anthropic, SurveyMonkey, or Typeform. We recommend tools based on what works, not what pays us. If that ever changes, we’ll tell you.*
That’s the kind of answer worth acting on — and the kind of advice we think you deserve getting straight.