Use ChatGPT with spreadsheets

Make ChatGPT your spreadsheet assistant. Ask questions instead of writing formulas to explore and understand your data—and get help building templates, cleaning data, visualizing trends, and working smarter in Excel or Google Sheets.

Upload a spreadsheet to ChatGPT

Interface showing a spreadsheet file named “social_analytics.xlsx” with a user prompt below it reading “Find the key trends in this data,” on a soft pink and blue gradient background.

A Notion page summarizing what’s driving the best ROI in a spreadsheet called marketing_performance.xlsx. The user asks for help identifying what’s behind top ROI. The response includes a “Channel Performance Overview” section, explaining that channels are ranked by average ROI, showing efficiency and conversion value. It highlights that top performers generate high revenue per dollar spent, CPA and CPC reveal cost efficiency, and underperformers have low or negative ROI due to poor returns or high spend. A follow-up prompt asks if month-over-month trends or campaign-level breakdowns should be included next.

Chat with any spreadsheet and get answers, instantly

Turn questions into insights

Upload your data and start asking questions—ChatGPT helps uncover trends, spot errors, and summarize what matters in seconds.

Write and fix formulas

ChatGPT helps you learn and fix formulas as you go, turning confusing syntax into simple, clear instructions.

Generate useful templates

Simply describe what you need—like a budget tracker—and ChatGPT will help generate the layout, format, and formulas.

How it works

A dropdown menu interface is shown with a cursor hovering over the “Add photos & files” option, which is highlighted in gray. The menu also includes options for Agent mode, Use connectors, Deep research, Create image, and More. The background features a soft gradient blend of orange, pink, and blue tones, giving the interface a clean and visually appealing appearance.

An interface screenshot shows a user uploading a spreadsheet titled Q3_Product_Sales_Report.xlsx. The file tile includes a green spreadsheet icon, the file name, and a close button. Below it, the user has typed a prompt into the input bar that reads “Summarize the key insights from this data.” A microphone icon and an upward arrow button appear to the right of the prompt box, indicating it is ready to send. The background is a soft pastel gradient blending pink, purple, and blue.

A visual summary displays key sales insights organized into three sections. The “Overall Sales Performance” section reports total revenue of $253,735, an average revenue per transaction of $5,075, and a total of 50 transactions. The “Regional Insights” section highlights the East region as the top performer, contributing the highest revenue, while other regions (North, South, West) show less engagement or efficiency. The “Product Performance” section identifies Webcam as the best-selling product, with notable contributions from Wireless Headphones and Laptop Stands, suggesting strong sales from higher-margin or high-volume items.

Click the ‘+’ and select ‘Add photos & files’ and choose the spreadsheet you want to discuss. Plus and Pro customers can connect to Google Drive and Microsoft Teams to pull in existing files. Learn more⁠.

More ways to chat with spreadsheets

Summarize the key insights from this spreadsheet—what’s driving growth and where are the outliers?

Compare performance across regions and explain which areas are underperforming and why.

Write a formula that calculates the percentage change in revenue month over month.

This SUMIFS formula isn’t working—can you fix it and explain what went wrong?

Explain what this formula does, step by step, and suggest a simpler way to write it.

Create a budget tracker that automatically totals expenses by category and highlights overspending.

Build a project tracker with columns for status, owner, due date, and progress percentage.

Design a personal finance tracker that visualizes monthly spending and savings goals.

Turn this data into a bar chart showing revenue by product line, and summarize the main trend.

Pull in my latest sales CSV and generate a summary tab showing week-over-week changes.