P

ChatGPT Prompt to Analyze a Survey

Survey analysis is a crucial step to transform raw data into actionable insights. Whether you've collected responses via Google Forms, Typeform, or any other tool, ChatGPT can help you identify trends, segment respondents, and extract 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: quantitative data synthesis, 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.

The prompt

ChatGPT

You are a data analyst specialized in quantitative and qualitative studies. I will provide you with survey results. Analyze them following this methodology:

  1. Overview: Number of respondents, completion rate, collection period, and general demographic profile.

  2. Quantitative analysis: For each closed question, calculate response percentages, identify the central tendency and notable values. Present results in summary tables.

  3. Qualitative analysis: For open-ended questions, group responses into recurring themes, quantify the frequency of each theme, and cite 2-3 representative verbatims per theme.

  4. Cross-tabulations and correlations: Identify significant links between variables (e.g., satisfaction by age, usage by profile). Report only relevant correlations.

  5. Points of attention: List weak signals, surprising results, or inconsistencies in the data.

  6. 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 is 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 it works

This prompt is effective because it imposes a structured analysis methodology in six steps, 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 a restitution grounded in real data rather than generalities.

Expected result

You will obtain 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.

Variants by level

FAQ

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 corresponding to 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 plain text much better than images of charts.
Can ChatGPT analyze a survey with hundreds of responses?
ChatGPT can process survey data effectively, 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 into blocks of questions. For very large volumes, provide pre-calculated cross-tabulations and open-ended responses separately. The key is for ChatGPT to have access to the critical numbers to produce a reliable analysis.
Are survey analyses produced by ChatGPT reliable?
ChatGPT excels at qualitative synthesis, thematic grouping, and formulating recommendations, but it does not 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-check its conclusions with your field knowledge, and use it as an analysis accelerator rather than the sole source of truth. For advanced statistical tests (chi-square, regressions), prefer a dedicated tool like Excel, R, or Python.

Related prompts

ChatGPT Prompt to Create a SurveyChatGPT Prompt to Analyze DataChatGPT Prompt to Write a ReportChatGPT Prompt to Create a Satisfaction Questionnaire

How to use this prompt

  1. Copy the prompt with the button above.
  2. Paste it into ChatGPT, Claude or your favorite AI assistant.
  3. Replace the bracketed variables with your details, then refine the result.

About Prompt Guide

Prompt Guide is a free library of 2500+ ready-to-use prompts for ChatGPT, Claude and other AIs, with guides to learn prompting and tools to build and optimize your own prompts.

Prompt libraryLearn promptingPrompt builderPrompt optimizer

Already have a prompt?

Paste it into the Optimizer, AI improves it in 5 seconds: role, context, format. Free, no signup.

Open the Optimizer

More prompts to explore

Claude AI Prompts: Complete Guide to Mastering Claude (Anthropic)

Master Claude (Anthropic) with optimized prompts, advanced techniques and concrete examples. Complete free guide for beginners and experts.

Claude AI Prompts: Complete Guide to Mastering Claude (Anthropic)

Master Claude (Anthropic) with optimized prompts, advanced techniques, and concrete examples. Free complete guide for beginners and experts.

Claude Prompt for Contract Analysis

Contract analysis is a complex task that requires careful reading, a solid legal understanding, and the ability to quickly identify critical clauses.

Claude Prompt for Writing Product Sheets

Writing product sheets is a strategic exercise that combines commercial persuasion, SEO optimization, and technical precision. Each sheet must convince a potential buyer in seconds while meeting search engine requirements.

Claude Prompt to Create a Pitch Deck

Creating a compelling pitch deck is a strategic exercise that can determine the success of a fundraising, partnership, or product launch. Claude excels at structuring complex arguments and synthesizing business information into impactful messages.

Claude Prompt to Create a Presentation

Creating a compelling presentation requires much more than lining up bullet points on slides. You need to structure a narrative, prioritize information, adapt the tone to the audience, and produce visually thoughtful content. Claude excels at this task because it can simultaneously act as a communication strategist, a copywriter, and a content designer. By providing it with a well-crafted prompt, you get a complete presentation with a coherent narrative structure, catchy titles, speaker notes, and visual suggestions. Whether you're preparing an investor pitch, internal training, a conference, or a simple team meeting, Claude adjusts the level of detail, vocabulary, and format to your context. The major advantage is time savings: instead of starting from a blank page, you begin with a solid foundation that you refine according to your needs. Claude can also generate content in various usable formats — structured Markdown, a detailed slide-by-slide plan, or even HTML code for tools like Reveal.js. This approach transforms presentation creation from a time-consuming chore into an assisted creative process where you focus on the message rather than formatting.

Go further

How to prompt ChatGPT

The complete guide: techniques, examples and best practices.

Free prompt library

2500+ prompts sorted by category, one-click copy.

Get new prompts every week

Join our newsletter.