Improvements to data analysis in ChatGPT

Today, we’re starting to roll out enhancements to data analysis:

• Upload the latest file versions directly from Google Drive and Microsoft OneDrive

• Interact with tables and charts in a new expandable view

• Customize and download charts for presentations and documents

Data analysis improvements will be available in our new flagship model, GPT-4o, for ChatGPT Plus, Team, and Enterprise users over the coming weeks.

These improvements build on ChatGPT’s ability to understand datasets and complete tasks in natural language. To start, upload one or more data files, and ChatGPT will analyze your data by writing and running Python code on your behalf. It can handle a range of data tasks, like merging and cleaning large datasets, creating charts, and uncovering insights. This makes it easier for beginners to perform in-depth analyses and saves experts time on routine data-cleaning tasks.

Instead of downloading files to your desktop and then uploading them to ChatGPT, you can now add various file types directly from your Google Drive or Microsoft OneDrive. This allows ChatGPT to understand your Google Sheets, Docs, Slides, and Microsoft Excel, Word, and PowerPoint files more quickly. 

When you add a dataset, ChatGPT will create an interactive table that you can expand to a full-screen view so you can follow along as it updates during your analysis. Click on specific areas to ask follow-up questions, or choose from one of ChatGPT's suggested prompts to go deeper into your analysis.

For example, you can ask ChatGPT to combine spreadsheets of monthly expenses and create a pivot table categorized by expense type.

You can now customize and interact with bar, line, pie, and scatter plot charts in the conversation. Hover over chart elements, ask additional questions, or select colors. When ready, download to use in presentations or documents. 

For example, you can select a Google Sheet with your company's latest user data directly from Google Drive and ask ChatGPT to create a chart showing retention rates by cohort.

These new interactive features cover many chart types. ChatGPT will generate a static version for charts that aren't supported.

As with any feature in ChatGPT, trust and data privacy are at the core of OpenAI’s mission. We don’t train on data from ChatGPT Team and Enterprise customers, and ChatGPT Plus users can opt out of training through their Data Controls(opens in a new window). Learn more about our privacy and security policies, including SAML SSO, compliance, and data encryption for ChatGPT Enterprise.