HomeMicrosoft Excel's Copilot AI Now Automates Spreadsheet Data Entry
Microsoft Excel is experimenting with a new AI-powered function that automatically populates spreadsheet cells, mirroring a feature Google Sheets launched in June. Using the "COPILOT" function followed by a natural language prompt—and optionally specifying reference cells—the AI can categorize data, create summaries, build tables, and perform other tasks.
For instance, if you have a column containing feedback about a coffee machine, the COPILOT function can quickly classify it using AI. You would apply this formula: "=COPILOT("Classify this feedback", D4:D18)," making sure to adjust the cell references according to your Excel sheet. Microsoft Excel will then display AI-generated classifications in each specified cell.
The COPILOT function can quickly classify feedback. GIF: MicrosoftMicrosoft provides the following examples:
- Generate text: =COPILOT("Create a description for this product based on its specs", B2:B8)
- Summarize text: =COPILOT("Summarize this feedback", A2:A20)
The COPILOT function, powered by OpenAI’s GPT-4.1-mini AI model, succeeds the LABS.GENERATIVEAI function that Microsoft began testing in 2023.
Microsoft explains that the new AI function can be combined with existing Excel functions, such as IF, SWITCH, LAMBDA, or WRAPROWS. The company also assures users that data processed through the COPILOT function is "never" used for AI training, stating that "input remains confidential and is used solely to generate your requested output."
The COPILOT function has a few limitations: it cannot access information outside the spreadsheet, and usage is capped at 100 function calls per 10 minutes. Microsoft also cautions against relying on it for numerical calculations or in "high-stakes scenarios" involving legal, regulatory, or compliance issues, as COPILOT "can produce incorrect responses."
It is currently rolling out to Beta Channel users on Windows and Mac with a Microsoft 365 Copilot license. Microsoft intends to enhance the feature by upgrading its underlying model and possibly adding web access support.
Related article
Stripe to Acquire OpenRouter as AI Model Routing Gains Momentum
Stripe has agreed to acquire OpenRouter, an AI model-routing platform that gives developers access to hundreds of models through a single interface. The deal adds model selection and routing to Stripe’s existing work around AI usage and token-based b
Google AI Overviews Gain Ground in Search Results
According to Similarweb’s 2026 Generative AI Landscape report, Google’s AI-generated summaries appeared in 43% of US searches, a significant rise from 15% recorded a year prior.While AI Overviews present generated summaries within standard search res
Sequoia-backed Empirik raises $21M to forecast outages before they strike
Before joining Sequoia Capital in 2020 as chief digital and information officer, Avon Puri spent over a decade running infrastructure at Rubrik and VMware. Three years ago, as large language models began showing their true potential, Puri, alongside
Related Special Topic Recommendations
Design & Art
Top AI Illustration Tools: Create Editorial Scenes and Cover Art Faster
2026 Latest Top-rated AI Illustration Tools: Our curated list features the best powerfully designed tools for creating stunning editorial scenes and eye-catching cover art quickly. Each option has gone through rigorous real-world tests, offering a free vs paid comparison to help you find the perfect match for your workflow. Try these must-try solutions today to unlock your AI edge and boost your creative productivity. Explore now at XIX.AI.
10 tools
xix.ai
Education and Learning
Top AI Tutors for Exam Prep: Practice Math, Science, and English
2026 Latest Top-Rated Best AI Tutors for Exam Prep are here on XIX.AI! Our curated list features powerful game-changing tools that offer free vs paid comparison, real-world tests, and weekly updated rankings. They help boost your writing efficiency, simplify complex topic learning, and unlock your academic potential. Explore now to Discover your perfect exam prep tool and Start creating today to Unlock your AI edge!
10 tools
xix.ai
Finance
AI Budget Planning Tools for Personal Money Management
2026 Latest Best Top-Rated AI Budget Planning Tools for Personal Money Management are here on XIX.AI! This curated collection features powerful, game-changing solutions that help you conduct real-world tests, understand spending habits, and create personalized plans to boost productivity. Enjoy a free vs paid comparison along with detailed rankings. Must-try tools designed to simplify money management and unlock your AI edge. Explore now!
11 tools
xix.ai
Health & Wellness
AI Sleep Tracking Assistants: Improve Recovery with Better Bedtime Habits
2026 Latest Best Top-Rated AI Sleep Tracking Assistants curated for ultimate recovery. This fully updated weekly guide features powerful tools that deliver real-world tests, free vs paid comparison, and detailed rankings to help you find the must-try solution that boosts sleep quality and supports better bedtime habits. Explore now at XIX.AI to Unlock your AI edge.
10 tools
xix.ai
Data Analysis
AI SQL Copilots for Product and Revenue Analytics
2026 Latest Best Top-Rated AI SQL Copilots for Product and Revenue Analytics! XIX.AI has curated a powerful, game-changing collection of must-try tools that undergo real-world tests through weekly updated rankings. These tools help users boost productivity significantly by accelerating data analysis, streamlining complex queries, and generating accurate insights to drive smarter business decisions. Explore now to Discover your perfect tool for unlocking your AI edge!
14 tools
xix.ai
Education and Learning
Best AI Homework Helpers That Teach: Learn Concepts, Not Just Answers
2026 Latest Best Top-Rated AI Homework Helpers That Teach Core Concepts Not Just Answers Powerful Tools for Students Must-Try Curated List Weekly Updated Free vs Paid Comparison Real-World Tests Accurate Rankings to Help You Unlock Your Full Learning Potential Explore now to Discover your perfect tool for smarter studying.
10 tools
xix.ai
Comments (1)
0/500
![PaulMartínez]()
Also Excel bekommt jetzt auch KI-Hilfe für Tabellen? Interessant, aber ich frage mich, wie zuverlässig das wirklich ist. Bei komplexen Daten würde ich wahrscheinlich trotzdem lieber selbst nachrechnen, bevor ich mich blind auf die KI verlasse. Die Funktion klingt praktisch für Routineaufgaben, aber der Teufel steckt oft im Detail. Mal sehen, wie sich das in der Praxis bewährt. 🤔
Microsoft Excel is experimenting with a new AI-powered function that automatically populates spreadsheet cells, mirroring a feature Google Sheets launched in June. Using the "COPILOT" function followed by a natural language prompt—and optionally specifying reference cells—the AI can categorize data, create summaries, build tables, and perform other tasks.
For instance, if you have a column containing feedback about a coffee machine, the COPILOT function can quickly classify it using AI. You would apply this formula: "=COPILOT("Classify this feedback", D4:D18)," making sure to adjust the cell references according to your Excel sheet. Microsoft Excel will then display AI-generated classifications in each specified cell.
Microsoft provides the following examples:
- Generate text: =COPILOT("Create a description for this product based on its specs", B2:B8)
- Summarize text: =COPILOT("Summarize this feedback", A2:A20)
The COPILOT function, powered by OpenAI’s GPT-4.1-mini AI model, succeeds the LABS.GENERATIVEAI function that Microsoft began testing in 2023.
Microsoft explains that the new AI function can be combined with existing Excel functions, such as IF, SWITCH, LAMBDA, or WRAPROWS. The company also assures users that data processed through the COPILOT function is "never" used for AI training, stating that "input remains confidential and is used solely to generate your requested output."
The COPILOT function has a few limitations: it cannot access information outside the spreadsheet, and usage is capped at 100 function calls per 10 minutes. Microsoft also cautions against relying on it for numerical calculations or in "high-stakes scenarios" involving legal, regulatory, or compliance issues, as COPILOT "can produce incorrect responses."
It is currently rolling out to Beta Channel users on Windows and Mac with a Microsoft 365 Copilot license. Microsoft intends to enhance the feature by upgrading its underlying model and possibly adding web access support.
Stripe to Acquire OpenRouter as AI Model Routing Gains Momentum
Stripe has agreed to acquire OpenRouter, an AI model-routing platform that gives developers access to hundreds of models through a single interface. The deal adds model selection and routing to Stripe’s existing work around AI usage and token-based b
Google AI Overviews Gain Ground in Search Results
According to Similarweb’s 2026 Generative AI Landscape report, Google’s AI-generated summaries appeared in 43% of US searches, a significant rise from 15% recorded a year prior.While AI Overviews present generated summaries within standard search res
Sequoia-backed Empirik raises $21M to forecast outages before they strike
Before joining Sequoia Capital in 2020 as chief digital and information officer, Avon Puri spent over a decade running infrastructure at Rubrik and VMware. Three years ago, as large language models began showing their true potential, Puri, alongside
2026 Latest Top-rated AI Illustration Tools: Our curated list features the best powerfully designed tools for creating stunning editorial scenes and eye-catching cover art quickly. Each option has gone through rigorous real-world tests, offering a free vs paid comparison to help you find the perfect match for your workflow. Try these must-try solutions today to unlock your AI edge and boost your creative productivity. Explore now at XIX.AI.
10 tools
xix.ai
2026 Latest Top-Rated Best AI Tutors for Exam Prep are here on XIX.AI! Our curated list features powerful game-changing tools that offer free vs paid comparison, real-world tests, and weekly updated rankings. They help boost your writing efficiency, simplify complex topic learning, and unlock your academic potential. Explore now to Discover your perfect exam prep tool and Start creating today to Unlock your AI edge!
10 tools
xix.ai
2026 Latest Best Top-Rated AI Budget Planning Tools for Personal Money Management are here on XIX.AI! This curated collection features powerful, game-changing solutions that help you conduct real-world tests, understand spending habits, and create personalized plans to boost productivity. Enjoy a free vs paid comparison along with detailed rankings. Must-try tools designed to simplify money management and unlock your AI edge. Explore now!
11 tools
xix.ai
2026 Latest Best Top-Rated AI Sleep Tracking Assistants curated for ultimate recovery. This fully updated weekly guide features powerful tools that deliver real-world tests, free vs paid comparison, and detailed rankings to help you find the must-try solution that boosts sleep quality and supports better bedtime habits. Explore now at XIX.AI to Unlock your AI edge.
10 tools
xix.ai
2026 Latest Best Top-Rated AI SQL Copilots for Product and Revenue Analytics! XIX.AI has curated a powerful, game-changing collection of must-try tools that undergo real-world tests through weekly updated rankings. These tools help users boost productivity significantly by accelerating data analysis, streamlining complex queries, and generating accurate insights to drive smarter business decisions. Explore now to Discover your perfect tool for unlocking your AI edge!
14 tools
xix.ai
2026 Latest Best Top-Rated AI Homework Helpers That Teach Core Concepts Not Just Answers Powerful Tools for Students Must-Try Curated List Weekly Updated Free vs Paid Comparison Real-World Tests Accurate Rankings to Help You Unlock Your Full Learning Potential Explore now to Discover your perfect tool for smarter studying.
10 tools
xix.ai
Also Excel bekommt jetzt auch KI-Hilfe für Tabellen? Interessant, aber ich frage mich, wie zuverlässig das wirklich ist. Bei komplexen Daten würde ich wahrscheinlich trotzdem lieber selbst nachrechnen, bevor ich mich blind auf die KI verlasse. Die Funktion klingt praktisch für Routineaufgaben, aber der Teufel steckt oft im Detail. Mal sehen, wie sich das in der Praxis bewährt. 🤔
