OpenAI Improves ChatGPT, Allowing It to Import Files from Google Drive and Microsoft OneDrive

IBL News | New York

OpenAI updated its signature ChatGPT to import files—including tables and charts—directly from Google Drive and Microsoft OneDrive and its apps, such as Google Sheets, Docs, Slides, and Microsoft Excel, Word, and PowerPoint.

This capability, which understands datasets for analysis improvements, will be available in OpenAI’s new flagship model, GPT-4o, over the coming weeks for ChatGPT Plus, Team, and Enterprise users.

To perform these in-depth analyses, users start by uploading one or more data files directly from Drive and OneDrive, and ChatGPT will analyze their data by writing and running Python code on their behalf. It can handle various 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 conducts data exploration of customer data allocated to massive datasets. For example, it can combine spreadsheets of monthly expenses and create a pivot table categorized by expense type. Or they can select a Google Sheet with their company’s latest user data directly from Google Drive and ask ChatGPT to create a chart showing retention rates by cohort.

Users can customize and interact with bar, line, pie, and scatter plot charts in the conversation. They can also hover over chart elements, ask additional questions, or select colors. When ready, they can download the chart for presentations or documents.

In addition, ChatGPT suggests prompts to go deeper into the analysis.

ChatGPT Charts Blog Summary v3