Skip to main content
ChatGPT enhancing Excel and Google Sheets by dynamically updating sales formulas and generating insightful summaries for data

Editorial illustration for ChatGPT in Excel and Google Sheets updates formulas and summarizes sales

LLMs & Generative AI

ChatGPT in Excel and Google Sheets updates formulas and...

By AI Daily Post Edited by
• Updated: • 2 min read

ChatGPT can now generate entire spreadsheet structures inside Excel and Google Sheets from a single sentence. A user can type a command like "Turn this sales dataset into a spreadsheet with one raw data tab and one summary tab," and the tool will produce the tabs and add formulas for calculations like total revenue. This feature, currently live, was detailed in a guide from Analytics Vidhya.

Sample Prompt: “Turn this sales dataset into a spreadsheet with one raw data tab and one summary tab.” ChatGPT can add basic formulas to calculate total revenue, monthly sales, and product-wise sales.

The integration moves the work from writing specific formulas to describing an intended result. It means a user asking for a sales summary no longer needs to know how to build a PivotTable or write a SUMIFS function. The spreadsheet itself handles that translation.

Related Reading

Browse all OpenAI news →
Study reveals ChatGPT’s "nerdy" tweak enhances goblin-themed metaphors in AI-generated responses, illustrated by a futuristic LLMs & Generative AI

ChatGPT's 'Nerdy' tweak rewards goblin metaphors in answers, study finds

• 3 min read
A hand holds a Gemini 3 Pro phone showing a sleek, magazine-style Google UI with images and text in a bright office. LLMs & Generative AI

Google tests visual 'magazine-style' UI for Gemini 3 Pro users

• 3 min read
AI engineers in a modern office discussing rising operational costs while analyzing efficiency strategies on digital screens, LLMs & Generative AI

AI Engineers Face Rising Costs, Need New Strategies for Efficiency

• 3 min read
Professional tech office with diverse professionals collaborating at modern workstations Related Topic

OpenAI hires 630 ex-Meta staff as ChatGPT memory may turn data into ads

Business & Startups

• 3 min read
Sen. Elizabeth Warren stands at a Senate press podium, holding an OpenAI letter, urging Trump admin to expand AI credit. Related Topic

Sen. Warren urges Trump admin to expand AI credit after OpenAI letter

Business & Startups

• 3 min read
WPP enhances AI model components using AlphaEvolve, achieving a 10% accuracy boost in advanced machine learning processes for From Archives

WPP refines AI model components, gains 10% accuracy with AlphaEvolve

• 3 min read
Advanced AI neural networks merging into a unified brain-like structure representing converging reasoning models improving re From Archives

Major reasoning models converge on a shared “brain” as they better model reality

• 3 min read
OpenAI and PwC collaboration showcasing AI integration in CFO finance functions, highlighting agentic AI adoption for smarter From Archives

OpenAI, PwC Team Up to Embed Agentic AI in CFO Finance Functions

Business & Startups

• 3 min read
OpenAI leadership team discusses internal "goblin" narrative during company-wide acknowledgment meeting, highlighting transpa From Archives

OpenAI acknowledges company‑wide “goblin” narrative reaching top leadership

Open Source

• 3 min read

Common Questions Answered

How does ChatGPT generate spreadsheet structures in Excel and Google Sheets?

ChatGPT can now create entire spreadsheet structures from a single sentence command, such as 'Turn this sales dataset into a spreadsheet with one raw data tab and one summary tab.' The tool automatically produces the requested tabs and adds formulas for calculations like total revenue, eliminating the need for manual formula writing.

What is the key advantage of using ChatGPT to create spreadsheets instead of writing formulas manually?

The integration shifts the workflow from writing specific formulas to simply describing an intended result. Users no longer need to know how to build PivotTables or write complex functions like SUMIFS, as the spreadsheet automatically handles that translation based on the natural language description provided.

Can ChatGPT create sales summaries without requiring users to know PivotTable functions?

Yes, users can ask ChatGPT to create a sales summary without needing to understand PivotTable or SUMIFS functions. The spreadsheet tool handles the technical translation automatically, making data analysis accessible to users regardless of their spreadsheet expertise.

What types of calculations can ChatGPT add to spreadsheets automatically?

ChatGPT can add various calculations to spreadsheets, including formulas for computing total revenue and other summary metrics. The tool intelligently determines which formulas are needed based on the user's natural language request and the structure of the data provided.

Further Reading

PRESENTED BY NO CODE MBA

Ship an AI product this weekend — no engineers required.

Structured, in-depth lessons on the exact no-code tools — not scattered tutorials.

  • The exact platforms, taught in depth
  • Build real, working projects
  • Our honest review + a reader discount
Read the review →

Latest News

1

OpenAI's Miles Wang in Talks for USD 2B AI Drug Discovery Startup

2

Mistral Vibe for Code Leads in Multi-Agent Programming Benchmark

3

OpenAI's First Hardware Device Is a Movable, Screenless Speaker

4

PrismML's Bonsai 27B Runs Qwen3.6 on Laptops With 1-bit and Ternary Builds

5

OpenAI Targets 2027 for First Major Hardware: A ChatGPT Speaker

6

Publishers sue Google over unauthorized AI book training

7

Anthropic's Claude for Teachers Vows Not to Train on Student Data

8

DeepSeek Seeks More Capital Weeks After USD 7B Funding Round

9

Anthropic's New AI Ad Campaign Draws Criticism for 'Creepy' Tactics

10

DeepMind CEO proposes independent AI regulator as White House advisor voices skepticism

Most recent articles

LIVE03:21OpenAI's Miles Wang in Talks for USD 2B AI Drug Discovery Startup