AI news
May 17, 2024

ChatGPT Can Now Generate Interactive Charts and Tables

You can now connect Google Drive and Microsoft OneDrive to upload files.

Jim Clyde Monge
by 
Jim Clyde Monge

Less than a week after announcing GPT-4o, OpenAI has unveiled another cool feature. This new capability not only allows direct file uploads from Google Drive and Microsoft OneDrive but also enables users to work with interactive charts and tables.

To be clear, file support isn’t new in ChatGPT. However, the ability to add files directly from other sources is new. This eliminates the need to download files to a user’s desktop before uploading them to ChatGPT.

How to Link Google Drive and Microsoft OneDrive

First, you must be a ChatGPT Plus, Team, or Enterprise user to access this new feature. Here’s how you can connect your drives:

Click on the upload button beside the chat field. A pop-up window will appear with options to connect to Google Drive or Microsoft OneDrive.

Image from OpenAI ChatGPT GPT-4o interactive charts and tables
Image from OpenAI

Log in with your Google or Microsoft account and grant access to ChatGPT. Remember, you are allowing this third-party service to access your files, meaning it can read, edit, create, and delete them.

Image from OpenAI ChatGPT GPT-4o interactive charts and tables. Google drive access
Image from OpenAI

Once you’ve given ChatGPT access, you can begin uploading files directly.

Upload Files Directly to ChatGPT

Select the file you want to turn into charts or tables.

Image from OpenAI ChatGPT GPT-4o interactive charts and tables
Image from OpenAI

ChatGPT currently supports these file types:

  • Google Sheets
  • Google Docs
  • Google Slides
  • Microsoft Excel
  • Microsoft Word
  • Microsoft PowerPoint

Once the file is uploaded, you’ll see a little preview of the document.

Image from OpenAI ChatGPT GPT-4o interactive charts and tables
Image from OpenAI

ChatGPT will analyze the data and provide a summary. Look for the label that says “Now interactive!” — this means you can interact directly with the file.

Interacting with tables in ChatGPT

Click on the expand icon on the uploaded file to preview it in a larger panel. On the right side, you can chat with the AI to filter, edit, or modify the file.

For example, you can ask the AI to create a filter and show a breakdown of specific data by category. How cool is that?

Image from OpenAI ChatGPT GPT-4o interactive charts and tables
Image from OpenAI

This ability to manipulate data using natural language is groundbreaking. What’s even more impressive is that ChatGPT can now generate charts.

Generating Charts

Simply instruct the AI to create a graph like in the example below:

Image from OpenAI ChatGPT GPT-4o interactive charts and tables
Image from OpenAI

Aside from line charts, you can also customize and interact with bar, pie, and scatter plot charts. You can customize these charts directly within ChatGPT.

Image from OpenAI ChatGPT GPT-4o interactive charts and tables
Image from OpenAI

Once you’re satisfied, you can download them for use in presentations or documents. Think about how much time this automation can save!

Naturally, there are concerns regarding the privacy and security of this new feature. How does OpenAI handle your data? Will it be used to train their model?

Here’s what OpenAI has to say:

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.

Final Thoughts

So, is this the end of data analysts? Perhaps not.

In fact, this new capability can be a great tool for data analysts, providing quick and easy data analysis. The integration with Google Drive and Microsoft OneDrive allows for seamless access to your files, making the process even more efficient.

Now, can we get the ability to add git repos, please?

Interestingly, OpenAI’s close competitor, Google, has announced a similar feature for Gemini at Google I/O 2024. This feature will be rolling out in the next few months, so a real-world comparison isn’t possible just yet.