ChatGPT Prompt for Analyzing a Survey
Survey analysis is a crucial step for transforming raw data into actionable insights. Whether you collected responses via Google Forms, Typeform, or any other tool, ChatGPT can help you identify trends, segment respondents, and draw relevant conclusions in minutes. Where an analyst would spend hours cross-referencing variables and writing a report, AI significantly speeds up the process while maintaining methodological rigor. This prompt is designed to guide ChatGPT through a structured analysis of your survey results: synthesis of quantitative data, interpretation of open-ended responses, identification of significant correlations, and formulation of concrete recommendations. It works equally well for a customer satisfaction survey, a market study, or an internal questionnaire. The proposed approach combines descriptive statistical analysis and thematic qualitative analysis, offering you a complete and nuanced view of your results without requiring advanced data science skills.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a data analyst specialized in quantitative and qualitative studies. I will provide you with the results of a survey. Analyze them following this methodology:
-
Overview: Number of respondents, completion rate, collection period, and general demographic profile.
-
Quantitative analysis: For each closed-ended question, calculate response percentages, identify the central tendency and notable values. Present results in summary tables.
-
Qualitative analysis: For open-ended questions, group responses by recurring themes, quantify the frequency of each theme, and quote 2-3 representative verbatims per theme.
-
Cross-tabulations and correlations: Identify significant links between variables (e.g., satisfaction by age, usage by profile). Report only relevant correlations.
-
Points of attention: List weak signals, surprising results, or inconsistencies in the data.
-
Recommendations: Formulate 5 actionable recommendations ranked by priority, each justified by the data.
Adapt your level of detail to the sample size. Be factual and clearly distinguish facts from interpretations.
Here are the survey data:
[PASTE YOUR DATA HERE]
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
This prompt is effective because it imposes a structured six-step analysis methodology, preventing ChatGPT from producing a superficial summary. Assigning the role of a data analyst activates the model's statistical knowledge, while the explicit distinction between facts and interpretations reduces hallucinations. The request for verbatims and tables forces an output grounded in actual data rather than generalizations.
Use Cases
Variants
Expected Output
You will get a comprehensive analysis report with percentage tables for each question, a thematic mapping of open-ended responses illustrated with direct quotes, and a list of correlations between variables. The report concludes with prioritized recommendations directly actionable by your team.
Frequently Asked Questions
What format should I provide my survey data in to ChatGPT?
The most effective format is a CSV table or a copy-paste from a spreadsheet, with column headers matching the questions and each row representing a respondent. If your survey is too large, export a statistical summary from your tool (Google Forms, Typeform, SurveyMonkey) with percentages per question. For open-ended responses, a simple list is enough. Avoid screenshots: ChatGPT analyzes raw text far better than images of charts.
Can ChatGPT analyze a survey with hundreds of responses?
ChatGPT can efficiently process survey data, but its context window has a limit. For fewer than 200 responses, paste the raw data directly. Beyond that, two approaches: either export aggregated statistics (percentages, averages) from your survey tool, or break the analysis down by question blocks. For very large volumes, provide pre-calculated cross-tabulations and open-ended responses separately. The key is that ChatGPT has access to the key figures to produce a reliable analysis.
Are the survey analyses produced by ChatGPT reliable?
ChatGPT excels at qualitative synthesis, thematic grouping, and formulating recommendations, but it doesn't replace statistical software for complex calculations. It can make arithmetic errors on large datasets. Best practice is to verify the key percentages it states, cross-reference its conclusions with your field knowledge, and use it as an analysis accelerator rather than a single source of truth. For advanced statistical tests (chi-squared, regressions), prefer a dedicated tool like Excel, R, or Python.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
Be the first to comment on this prompt.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Midjourney Prompt for Analyzing User Feedback
Midjourney, though primarily known as an image generation tool, offers fascinating possibilities for turning user feedback analysis into striking, actionable visuals. By creating graphical representations of qualitative data—stylized word clouds, emotional mappings, sentiment infographics, or visual dashboards—you can make often abstract feedback tangible. This visual approach makes it easier to communicate insights to product, design, and management teams, who absorb a synthetic image far better than a spreadsheet of verbatim comments. Whether you want to illustrate a UX report, create a mood board reflecting user sentiment, or produce visuals for a survey results presentation, Midjourney lets you give shape to textual data. The following prompts will guide you in generating visualizations that capture the essence of user feedback: visual empathy maps, satisfaction diagrams, metaphorical representations of pain points, and emotional journeys. The goal is to turn every piece of feedback into a visual asset that instantly speaks to all project stakeholders.
Statistical Power Analysis
Planning a statistical experiment
Advanced Correlation Analysis
Understanding relationships between variables
DALL-E Prompt for Analyzing Customer Reviews
DALL-E, OpenAI's image generation tool, offers a unique visual approach to representing and communicating customer review analysis results. Rather than being limited to classic tables and charts, DALL-E allows you to create impactful visuals—infographics, illustrated sentiment clouds, or metaphorical representations—that make customer insights immediately understandable to all teams. By transforming textual data into evocative images, you facilitate decision-making and stakeholder buy-in. Whether you want to illustrate sentiment distribution, dramatize recurring pain points, or create presentation materials based on the voice of the customer, DALL-E becomes a strategic ally. This approach is particularly effective for customer experience reports, executive committee presentations, or product improvement workshops where visual impact outweighs raw numbers. Learn how to formulate your prompts to obtain faithful and actionable visualizations of your customer review data.