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
Google Tests Remy AI Agent for Gemini as Focus Shifts to User Control
According to Business Insider, Google is testing Remy, a new AI personal agent for Gemini. This tool aims to execute tasks on behalf of users, streamlining both professional workflows and daily routines.Currently, Remy is undergoing testing in an int
Ollie bets privacy focus to win AI assistant race
To be genuinely helpful, an AI assistant must understand its user deeply. Ollie, a personal assistant designed for daily life, operates on the premise that this doesn’t require surrendering your data or compromising your privacy.While certain enterpr
How AI LIVE: London Will Explore AI & Industrial Automation
The summit will convene C-suite executives from around the globe to address pressing challenges in global industries, ranging from AI-driven disruption to economic volatility.AI LIVE: The London Summit will gather over 2,000 international leaders und
Related Special Topic Recommendations
writing
Best AI Outline Generators for Long-Form SEO Articles
2026 Latest Best Top-Rated AI Outline Generators for Long-Form SEO Articles, meticulously curated by XIX.AI. These powerful tools offer game-changing assistance in creating high-quality content quickly, boosting writing efficiency significantly. Get a free vs paid comparison along with real-world tests and detailed rankings to help you find the must-try option that suits your needs. Explore now to unlock your AI edge.
8 tools
xix.ai
Education and Learning
AI Study Tools for Homework and Exam Prep
2026 Latest Best AI Study Tools for Homework and Exam Prep! XIX.AI curates a top-rated list of powerful, game-changing tools that help students boost productivity, streamline homework completion, and ace exams through real-world tests. Get a free vs paid comparison, detailed rankings, and must-try options to unlock your AI edge. Explore now!
10 tools
xix.ai
Music composition
AI Vocal Demo Tools for Songwriters, Hooks, Toplines, and Multilingual Draft Sessions
2026 Latest Best AI Vocal Demo Tools for Songwriters, Hook Creators, and Multi-Language Content Teams! XIX.AI has curated a top-rated list of powerful game-changing tools that go through rigorous real-world tests. You’ll find detailed free vs paid comparison data, comprehensive rankings, and must-try options to help you boost writing efficiency and unlock your creative potential. Explore now to discover your perfect tool for all your content needs!
9 tools
xix.ai
Business
Best AI Competitive Research Tools for Small Businesses
2026 Latest Best Top-rated AI Competitive Research Tools for Small Businesses! XIX.AI has curated a highly powerful game-changing collection, updated weekly with rigorous real-world tests and detailed rankings. You can find a comprehensive free vs paid comparison to help you identify the must-try tools that boost your productivity and give you a competitive edge. Explore now to discover your perfect tool!
9 tools
xix.ai
Image editing
Photoshop AI Retouch Tools for Ecommerce Apparel, Skin Cleanup, and Color Consistency
2026 Latest Best Photoshop AI retouch tools for ecommerce apparel, skin cleanup, and color consistency! This top-rated curated list features powerful game-changing solutions that help you boost writing efficiency, streamline content creation, and achieve perfect visual results effortlessly. Each tool has undergone real-world tests through weekly updated rankings, complete with free vs paid comparison details. Backed by XIX.AI, it’s the must-try guide for anyone aiming to unlock your AI edge. Explore now!
10 tools
xix.ai
Prompt
Best AI Prompt Libraries for ChatGPT Workflows
2026 Latest Best Top-Rated AI Prompt Libraries for optimizing all types of ChatGPT workflows. XIX.AI has curated a powerful, game-changing collection that goes through rigorous real-world tests to ensure top performance. You can find detailed free vs paid comparisons and expert rankings to help you choose the must-try tools that boost your productivity and unlock your AI edge. Explore now!
11 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.
Google Tests Remy AI Agent for Gemini as Focus Shifts to User Control
According to Business Insider, Google is testing Remy, a new AI personal agent for Gemini. This tool aims to execute tasks on behalf of users, streamlining both professional workflows and daily routines.Currently, Remy is undergoing testing in an int
Ollie bets privacy focus to win AI assistant race
To be genuinely helpful, an AI assistant must understand its user deeply. Ollie, a personal assistant designed for daily life, operates on the premise that this doesn’t require surrendering your data or compromising your privacy.While certain enterpr
How AI LIVE: London Will Explore AI & Industrial Automation
The summit will convene C-suite executives from around the globe to address pressing challenges in global industries, ranging from AI-driven disruption to economic volatility.AI LIVE: The London Summit will gather over 2,000 international leaders und
2026 Latest Best Top-Rated AI Outline Generators for Long-Form SEO Articles, meticulously curated by XIX.AI. These powerful tools offer game-changing assistance in creating high-quality content quickly, boosting writing efficiency significantly. Get a free vs paid comparison along with real-world tests and detailed rankings to help you find the must-try option that suits your needs. Explore now to unlock your AI edge.
8 tools
xix.ai
2026 Latest Best AI Study Tools for Homework and Exam Prep! XIX.AI curates a top-rated list of powerful, game-changing tools that help students boost productivity, streamline homework completion, and ace exams through real-world tests. Get a free vs paid comparison, detailed rankings, and must-try options to unlock your AI edge. Explore now!
10 tools
xix.ai
2026 Latest Best AI Vocal Demo Tools for Songwriters, Hook Creators, and Multi-Language Content Teams! XIX.AI has curated a top-rated list of powerful game-changing tools that go through rigorous real-world tests. You’ll find detailed free vs paid comparison data, comprehensive rankings, and must-try options to help you boost writing efficiency and unlock your creative potential. Explore now to discover your perfect tool for all your content needs!
9 tools
xix.ai
2026 Latest Best Top-rated AI Competitive Research Tools for Small Businesses! XIX.AI has curated a highly powerful game-changing collection, updated weekly with rigorous real-world tests and detailed rankings. You can find a comprehensive free vs paid comparison to help you identify the must-try tools that boost your productivity and give you a competitive edge. Explore now to discover your perfect tool!
9 tools
xix.ai
2026 Latest Best Photoshop AI retouch tools for ecommerce apparel, skin cleanup, and color consistency! This top-rated curated list features powerful game-changing solutions that help you boost writing efficiency, streamline content creation, and achieve perfect visual results effortlessly. Each tool has undergone real-world tests through weekly updated rankings, complete with free vs paid comparison details. Backed by XIX.AI, it’s the must-try guide for anyone aiming to unlock your AI edge. Explore now!
10 tools
xix.ai
2026 Latest Best Top-Rated AI Prompt Libraries for optimizing all types of ChatGPT workflows. XIX.AI has curated a powerful, game-changing collection that goes through rigorous real-world tests to ensure top performance. You can find detailed free vs paid comparisons and expert rankings to help you choose the must-try tools that boost your productivity and unlock your AI edge. Explore now!
11 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. 🤔
