Skip to main content

May 16, 2024

Improvements to data analysis in ChatGPT

Interact with tables and charts and add files directly from Google Drive and Microsoft OneDrive.

ChatGPT Charts Blog Summary v3

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.

How data analysis works in ChatGPT

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.

“ChatGPT is part of my toolkit for analyzing customer data, which has become too large and complex for Excel. It helps me sift through massive datasets, allowing me to conduct more data exploration on my own and reduce the time it takes to reach valuable insights."
David Vaughn, VP, The Carlyle Group

Add files directly from Google Drive and Microsoft OneDrive

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. 

Work on tables in real-time

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.

"ChatGPT walks me through data analysis and helps me better understand insights. It makes my job more fulfilling, helps me learn, and frees up my time to focus on more strategic parts of my job."
Lauren Nowak, Marketing Manager, Afterpay

Customize presentation-ready charts

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.

Comprehensive security and privacy

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.