Most spreadsheets already hold the answer you need. The hard part is finding the time to dig it out.
ChatGPT can read an uploaded spreadsheet, run the calculations in Python and return tables and charts you can check. Think of it as a fast junior analyst: always available and quick, but still in need of supervision.
Where to find data analysis in ChatGPT
There is no special mode to switch on. In any chat, select + and add your file, or drag it into the window. Where your admin allows it, you can also attach a file from a connected app, such as Google Drive, OneDrive or SharePoint.
ChatGPT then shows your data as an interactive table you can scroll, expand and download.
What your plan includes
- Every plan: file uploads and data analysis work on Free and paid plans. Paid plans come with higher upload limits.
- File types: Excel (.xls and .xlsx), CSV and TSV files work best. PDFs, JSON and text files are supported too.
- Connected apps: attaching files from Google Drive, OneDrive or SharePoint depends on your plan and your admin settings.
- Business and Enterprise: OpenAI does not train its models on your workspace data by default, and admins decide which apps people can connect.
When ChatGPT data analysis earns its place
There are four situations where it pays off quickly:
- A dataset you did not build, such as a CRM export or survey results, that you need to understand fast.
- A leadership update that needs a few clear charts and the numbers behind them.
- A messy export to clean up, which ChatGPT can reshape and return as a downloadable file.
- Several files to combine, such as two exports that share a customer or product column.
How to analyze a spreadsheet with ChatGPT, step by step
The examples below use a public job market dataset with roles, salaries, skills and locations. The same four prompts work on any dataset, from a sales export to survey results.
Step 1: Bring in your data. Upload the file or attach it from a connected app. Clean data gives better answers: put descriptive headers in the first row, keep one record per row and avoid merged cells or several tables on one sheet.
Step 2: Check how ChatGPT reads it. Before you ask for any insight, confirm that it understands the columns:
List every column and explain what each appears to represent. List five random samples of the data for each column.
If a column is misread, correct it now, before it shapes every answer that follows.
Step 3: Ask what the data can answer. Let ChatGPT propose the questions instead of guessing them yourself:
What are the five most interesting questions this dataset is sufficient to answer?
Add a lens if it helps, such as a hiring manager, an operations lead or a market researcher.
Step 4: Drill into one question, with your own definitions. Pick the question that matters for your decision:
Which skills appear most frequently across high-paying positions? Count a position as high-paying when [its maximum salary is in the top 25 percent].
Without a definition, ChatGPT makes its own assumption. Always state what counts as high, low or relevant, so the analysis follows your logic.
Step 5: Create a chart. Ask for a visual in the same chat, or ask which chart type would tell the story most clearly:
Create a chart showing the top skills associated with high-paying roles.
Bar, line, pie and scatter charts can switch to an interactive view. Select Switch to interactive chart to explore it, or expand and download it.
Step 6: Check the work. When ChatGPT uses Python, you can open the code it ran. Ask it to explain its method and spot-check two or three numbers against your file before you share anything.
A CODO prompt to start with
Once you trust how the AI reads your data, use this prompt, built with our CODO framework, to turn the analysis into findings your audience needs. Replace the bracketed parts. Your own definitions matter most, because the AI otherwise picks its own.
Character: You are a senior data analyst who specializes in [sales data] and knows how to frame findings for [a leadership team]. Objective: I am the [Head of Sales] at [company] in [industry]. Analyze the [attached / open] dataset, surface the three most important patterns and flag anything concerning, so [my leadership team] can decide [where to focus next quarter]. Do: - Before you analyze, list each column, what it appears to represent and any data quality issues you notice. - Use my definitions: [a high-value customer has annual revenue above $50,000]. - Lead with the "so what", not the method. - Show the calculation or the cells behind every number you report. - Suggest one chart that would make the main finding clear. Don't: - Don't change or delete my original data. Put any new analysis in a separate sheet or file. - Don't present estimates or assumptions as facts. Label them. Output: Three key findings of one paragraph each, followed by a 3 to 5 sentence summary for [my leadership team] that I can paste into an email or slide.
Want to take it further? These how-to articles build on the same skills:
- Turn a spreadsheet into an interactive project dashboard with ChatGPT Sites: share your analysis as a page your team can explore.
- Write a custom report from your data using ChatGPT connectors: bring data from your connected apps into a written report.
What will your IT and legal teams ask?
- Where does the data go? Uploaded files are processed on OpenAI's servers, and retention follows your plan and any workspace retention policy.
- Is our data used for training? Not on Business and Enterprise plans by default. On individual plans, you can turn this off in your data controls.
- Can the analysis reach the internet? No. The Python environment that runs the analysis cannot make outside web requests.
- Can it see files I cannot? No. Connected apps follow the permissions you already have, and admins control which apps are available.
ChatGPT data analysis or another tool?
ChatGPT is a strong choice for quick exploration of a file you can upload, especially if it is already your main AI assistant.
If you would rather stay inside your spreadsheet, ChatGPT for Excel and ChatGPT for Google Sheets bring the same assistant into your workbook. Claude builds interactive charts you can explore and download. On Google Workspace or Microsoft 365, Gemini in Google Sheets and Copilot in Excel work on your live file. Our overview of AI for data analysis compares all eight options.
Key takeaways
- Upload a clean file with clear headers and one record per row.
- Check how ChatGPT reads your data before you ask for insights.
- Let it propose the questions, then drill into the one that matters.
- State your own definitions, or it will choose its own.
- Spot-check the numbers before you share the results.
