July 2026 marked the premiere of Grok for Excel – a plugin from xAI that promises to revolutionize data work in Excel. Can artificial intelligence really analyze data, write formulas, and create scenarios better than a human? We check what the new tool can do and how it compares to the competition.
The launch of Grok for Excel in July 2026 is another step in integrating artificial intelligence into everyday office tools. The plugin from xAI, a company founded by Elon Musk in 2023, has an ambitious goal: to make advanced data analysis accessible to every Excel user – without the need for knowledge of complex formulas or VBA. Does this mean the end of traditional spreadsheet work? Let's take a look at what Grok for Excel can do and what opportunities it opens up for users.
What is Grok for Excel?
Grok for Excel is a Microsoft Excel plugin that uses the Grok-2 AI model developed by xAI. The tool integrates with both the online and desktop versions of Excel, enabling interaction with data using natural language. Instead of manually writing formulas, the user can simply ask a question, e.g., "Show me products whose sales dropped by more than 10% compared to the previous quarter," and Grok will automatically generate the appropriate formula and present the results.
In practice, this means that even people without experience in data analysis can use advanced Excel features. The tool not only generates formulas but also analyzes data, detects trends, creates charts, and allows for simulating scenarios – all based on simple text prompts.
Key features of Grok for Excel
Matt Wolfe's video, published on July 17, 2026, presents the new tool's capabilities in detail. Here are the most important ones:
1. Generating formulas using natural language
One of the most impressive features is the ability to generate formulas based on natural language descriptions. For example, instead of manually typing a formula to calculate gross margin, a user can type: "Calculate the gross margin for each product in the sheet," and Grok will automatically create the correct formula. This significantly speeds up work and eliminates the risk of errors.
Wolfe's video also showed how Grok handles more complex queries, e.g., "Find all products whose sales in Q2 2026 were lower than in Q1 2026." The tool not only generates the formula but also presents the results in a clear way, e.g., by highlighting the relevant cells.
2. Data analysis and trend detection
Grok for Excel is not limited to generating formulas – it can also analyze data and detect patterns within it. A user can ask a question like "Why did sales drop in May 2026?", and the tool will analyze the available data and present possible causes, such as seasonality, price changes, or supply issues.
The tool also automatically creates charts based on user questions. For example, the question "Show the sales trend in 2026" results in the generation of a line chart with data for individual months. This is particularly useful for people who don't have time to create visualizations manually.
3. Scenarios and simulations
One of the most innovative features of Grok for Excel is the ability to create scenarios and simulations. A user can ask a question like "What happens if the product price increases by 5%?", and the tool will automatically modify the data and present the results. This allows for quick testing of different variants without the need for manual changes.
The video showed an example where a user asks: "How will profit change if we reduce production costs by 10%?". Grok not only calculates the new profit but also presents the results in the form of a table and a chart, which facilitates business decision-making.
4. Integration with external data
Grok for Excel also enables the import of data from other sources, such as SQL databases or APIs. This allows users to analyze data from various systems directly in Excel, without the need for manual copying or exporting files. This is particularly useful for companies that use many tools for data management.
Grok for Excel vs. Microsoft Copilot: Who wins?
Microsoft Copilot, available as part of the Microsoft 365 subscription, has long offered similar features, such as formula generation or data analysis. However, according to Matt Wolfe, Grok for Excel has several advantages over the competition:
- More advanced data analysis: Grok handles trend detection and scenario creation better, while Copilot focuses mainly on basic operations.
- Better natural language processing: Grok can interpret more complex queries, e.g., regarding time series analysis or predictions.
- Faster performance: In tests conducted by Wolfe, Grok generated formulas in real-time, while Copilot sometimes required longer wait times.
However, Copilot has its strengths, such as deeper integration with the Microsoft ecosystem (e.g., Power BI or Teams) and support for multiple languages. Furthermore, Copilot is available as part of the Microsoft 365 subscription, which may be more beneficial for companies already using this suite.
It is also worth mentioning the Duet AI for Google Sheets tool, which offers similar features but is only available within Google Workspace. Grok for Excel, however, has the advantage of integration with the desktop version of Excel, which may be crucial for many users.
Availability and requirements
Grok for Excel was officially presented on July 15, 2026, and is currently (as of July 21, 2026) available in beta for selected users. The full release is planned for August 2026, when the tool will be available to all Microsoft 365 Enterprise and Business subscribers.
Technical requirements
To use Grok for Excel, you need:
- A Microsoft 365 subscription (Excel Online or desktop).
- Operating system: Windows 10/11 or macOS 12+.
- Minimum hardware requirements: 8 GB RAM, Intel i5 or AMD Ryzen 5 processor.
Pricing
xAI offers three subscription plans:
- Free: 50 queries/month.
- Pro: 500 queries/month (9.99 USD/month).
- Enterprise: unlimited queries (price determined individually).
It is worth noting that the free version has limited capabilities, which may be a problem for users needing more frequent analysis. However, for small businesses or individual users, the Pro plan may prove sufficient.
Practical applications
Grok for Excel can find applications in many fields, from business to science. Here are a few examples of how this tool can be used:
1. Business and finance
- Sales analysis: A user can quickly check which products generate the highest margin, which have a downward trend, or what factors influence sales results.
- Revenue forecasting: The tool allows for creating scenarios, e.g., "How will revenue change if we increase the marketing budget by 20%?".
- Cost optimization: Grok can help identify areas where costs can be reduced, e.g., by analyzing expenses for individual categories.
2. Marketing
- Advertising campaign analysis: A user can check which campaigns brought the best results and why.
- Customer segmentation: The tool allows for identifying groups of customers with similar characteristics, which facilitates offer personalization.
- Customer behavior prediction: Grok can help predict which customers are most at risk of churning.
3. Science and research
- Experimental data analysis: Scientists can use Grok to quickly process research results and detect correlations between variables.
- Statistics: The tool can help in calculating averages, standard deviations, or testing hypotheses.
- Data visualization: Grok automatically creates charts, which makes it easier to present research results.
Limitations and challenges
Despite its impressive capabilities, Grok for Excel is not without flaws. Here are the most important limitations pointed out by Matt Wolfe in his video and industry reviewers:
1. Errors in formula generation
In the beta version, the tool sometimes generates incorrect formulas, e.g., with wrong cell references. Users must therefore manually check the results, which can be cumbersome, especially with complex analyses.
2. Slow performance with large datasets
Grok for Excel can run slowly with sheets containing over 100,000 rows. This limitation may be a problem for companies that operate on very large datasets.
3. Lack of support for languages other than English
Currently, the tool only works in English. Support for other languages is planned for the first quarter of 2027. This may be a serious barrier for users from countries where English is not widely spoken.
4. Microsoft 365 subscription required
Grok for Excel requires a Microsoft 365 subscription, which means an additional cost for individual users or small businesses that do not yet use this suite.
The future of Grok for Excel
xAI announces further development of the tool. Plans include:
- Support for other languages (Q1 2027).
- Integration with Power BI and Azure Data Lake (Q4 2026), which will allow for even more advanced data analysis.
- Automatic creation of VBA macros (2027), which will facilitate the automation of repetitive tasks.
There is also speculation in the market that Microsoft might be interested in acquiring xAI. If that were to happen, Grok for Excel could be more deeply integrated into the Microsoft ecosystem, which would further increase its functionality.
Regardless of future changes, Grok for Excel already seems to be a breakthrough tool for everyone who works with data in Excel on a daily basis. Will it replace data analysts? Probably not – at least for now. However, it will certainly make work easier for many people who until now had to rely on manual calculations or complex formulas.
Summary: Is it worth trying Grok for Excel?
Grok for Excel is a tool that can significantly speed up and simplify working with data in Excel. Its biggest advantages are:
- Generating formulas using natural language.
- Advanced data analysis and trend detection.
- The ability to create scenarios and simulations.
- Integration with external data.
However, before trying it out, it is worth considering the limitations, such as errors in formula generation, slow performance with large datasets, or the lack of support for languages other than English. Nevertheless, for many users, Grok for Excel may prove to be an invaluable tool that will save time and increase work efficiency.
If you are curious about how artificial intelligence is changing other fields, check out our previous posts, e.g., How is artificial intelligence changing science in 2026? or GPT-Live: How OpenAI is revolutionizing real-time AI interaction.
Comments