Revolutionize Data Analysis with Kutools AI Aide
---Bring powerful AI directly into Excel for faster, smarter insights

In today’s data-driven world, speed and accuracy matter more than ever. Revolutionize Data Analysis with Kutools AI Aide brings powerful AI capabilities directly into Excel, transforming the way you work with data. Instead of struggling with complex formulas, repetitive steps, or time-consuming analysis, you can simply describe what you need—and let AI do the heavy lifting. From generating formulas and insights to explaining results in plain language, Kutools AI Aide helps you analyze data faster, work smarter, and focus on decisions that truly matter.

What is Kutools AI Aide?

Why Choose Kutools AI Aide Over ChatGPT and Other AI Tools?

How to use Kutools AI Aide in Excel?

Some examples of using Kutools AI Aide

• Example 1: Execute the operation and get the result intelligently
• Example 2: Generate custom formulas
• Example 3: Create User Defined Function or VBA code
• Example 4: Analyze data and generate Charts
• Example 5: Invoke Kutools Functions (300+ handy features)
• Additional common requirements (translation, function parsing...)

Useful tips for Using Kutools AI Aide

Disable Kutools AI Features or Turn Off the Kutools AI Tab

Video: Integrate AI to Excel for Smarter Insights - Kutools AI Aide

What is Kutools AI Aide?

Kutools AI Aide, meticulously crafted by ExtendOffice, is one of 300+ advanced features of Kutools for Excel. It integrates the capabilities of artificial intelligence directly into Microsoft Excel. It acts as a bridge between the cutting-edge AI language models and Excel’s spreadsheet environment, enabling users to perform complex data analysis, generate code, create custom formulas, and much more, using natural language processing.

Why Choose Kutools AI Aide Over ChatGPT and Other AI Tools?

While general AI tools like ChatGPT are powerful, they are not built specifically for Excel workflows. Kutools AI Aide is designed as an Excel-native AI, working directly inside your spreadsheets instead of outside them. This means no copy-pasting data, no context loss, and no switching between tools.

With Kutools AI Aide, you can generate formulas, analyze data, translate text, and get step-by-step explanations right where your data lives. It understands Excel structures such as ranges, columns, headers, and formulas—delivering results that are more accurate, more actionable, and immediately usable. For anyone who relies on Excel daily, Kutools AI Aide turns AI from a generic assistant into a true productivity partner.

How to use Kutools AI Aide in Excel?

Below is a step-by-step guide on setting up and using Kutools AI Aide to enhance your data analysis tasks in Excel:

Step 1: Install Kutools AI Aide

Go to the Download page to download Kutools for Excel, then, run the installation file and follow the prompts to install Kutools for Excel.

Step 2: Activate Kutools AI Aide

1. After installing Kutools for Excel, three new tabs – Kutools, Kutools Plus and Kutools AI are displayed on the ribbon. Then, click Kutools AI > AI Aide, see screenshot:
   
2. A Kutools AI Aide pane is displayed at the right of the Excel file.
3. A Kutools AI Aide pane is displayed at the right of the Excel file.
   • The pane displays several example prompts for reference.
   • At the bottom, there is a chat box where you can type in any question you wish to ask.
   • 

Step 3: Configure the Kutools AI Aide settings

In the Kutools AI Aide pane, click icon to open the Set Kutools AI Options dialog box:

1. From the AI Provider drop-down list, choose one AI Provider such as KutoolsAI, OpenAI (ChatGPT), GoogleAI (Gemini), DeepSeek or other supported providers.
   
2. Copy and paste your API Key into the API Key box. (If you don’t have an API key yet, click Get API Key Now in the corresponding AI provider section and follow the on-screen instructions to create one.)
3. From the Model drop-down list, select a model (such as gpt-5-mini – Recommended).
   
4. Finally, click OK button.
5. Then, a Kutools for Excel prompt box pops out to remind you the API key has been set successfully. And then, click OK button. See screenshot:
   

For more detailed setup instructions, please refer to this article.

Step 4: Use Kutools AI Aide in Excel

After setting the API key, now, you can start interacting with the AI to perform various tasks. For example, here it provides detailed steps on how to insert a blank row after every two rows.

1. In the Chat box, type your requirement into the chat box, and click button or press Enter key to send the question.
   
2. After analyzing, Kutools AI Aide will interpret your request and generate a step-by-step solution automatically.
   
3. Next, you just need to follow the instructions provided by Kutools AI Aide to achieve the desired result.

Some examples of using Kutools AI Aide

Kutools AI Aide offers a wide range of functionalities to enhance your Excel experience, making complex tasks simpler and more efficient. Here's a detailed look at some examples of how you can use Kutools AI Aide:

Example 1: Execute the operation and get the result intelligently

Kutools AI Aide can automate and intelligently execute operations within Excel. For instance, you can ask it to summarize a large dataset, find correlations, or identify trends, and it will process the request and provide you with concise results, saving you the time and effort of manual analysis. For example, I will highlight every other row of the selected range with light blue color.

1. Select the data range that you want to analyze or manipulate with Kutools AI Aide. In the chat box, please type the following text:
   
   “Highlight every other row of the selected range with light blue color”
   
   
2. Then, click the Send button or press Enter key. After the analysis, click the Execute button to proceed. Kutools AI Aide will process your request using AI and deliver the results directly in Excel. Refer to the demo below:
   

Example 2: Generate custom formulas

Creating custom formulas can be a tedious task, especially for complex calculations. With Kutools AI Aide, you can generate these formulas effortlessly. By simply describing the desired calculation, Kutools AI Aide will generate the appropriate Excel formula for you, ready to be used in your worksheet.
For example, I want to calculate the payment per month based on the annual interest rate, total loan amount, and loan term in the table.

1. In the chat box, please clarify your question as the following text shown:
   
   “Cell B1 contains the annual interest rate, cell B2 the loan term, and cell B3 the total loan amount. Please help me create a formula to calculate the payment amount per month:”
   
   
2. Then, click the Send button or press the Enter key. After the analysis is complete, click Copy to copy the generated formula and paste it into the cell where you want to display the monthly payment. (Alternatively, click Apply to insert the formula directly into a blank cell.)
   

Example 3: Create User Defined Function or VBA code

In this example, you’ll learn how to use AI to create a User Defined Function (UDF) or generate VBA code to automate calculations and tasks in Excel. Instead of writing code from scratch, you simply describe what you want to achieve, and the AI will generate ready-to-use VBA code along with explanations. This approach helps both beginners and advanced users save time, reduce errors, and better understand how the code works.
For example, here, I will count cells with red font by using a User Defined Function.

1. In the chat box, please clarify your question as the following text shown:
   
   “Please create a user defined function to count the number of cells with red font in range A1:E10:”
2. Then, click the Send button or press Enter key. Following the analysis, Kutools AI Aide will interpret your request and generate the corresponding VBA code for the UDF, providing detailed steps for its implementation.
   
3. Next, you just need to follow the instructions provided by Kutools AI Aide to achieve the desired result.

Example 4: Analyze data and generate Charts

Kutools AI Aide takes data analysis to the next level by not only analyzing datasets but also generating comprehensive charts. This dual functionality provides a visual representation of data, making it easier to interpret and present findings effectively.
For example, I want to analyze the data range and generate a corresponding chart.

1. 1. Select the data range you want to analyze and create a chart. And then input the analysis request as following text shown:
   
   “Analyze the selected data and create a chart:”
2. 2. Then, click the Send button or press Enter key. After the analysis, click the Execute button to proceed. Kutools AI Aide will process the data based on your request, perform the analysis, and automatically create a chart, see the demo below:
   

Example 5: Invoke Kutools Functions (300+ handy features)

Kutools for Excel includes over 300 handy features, and with Kutools AI Aide, users can easily access and utilize these functions. This integration allows for more dynamic and intelligent use of Kutools’ extensive toolkit, enhancing the overall functionality of Excel. If Kutools can fulfill your requirements, the AI assistant will accurately activate the relevant function to assist you in accomplishing your objectives.
For example, if you need to encrypt specific cells, Kutools AI Aide will suggest the Encrypt Cells function, leveraging the existing capabilities within Kutools.

1. Select the data range you want to encrypt. And then input the following text shown:
   
   “Encrypt the selected cells:”
2. Then, click the Send button or press Enter key. The Kutools AI Aide analyzes your request and identifies the corresponding Kutools function that fulfills your need. Then, click the Execute button to invoke that feature. See the demo below:
   

Additional common requirements (Such as translation, function parsing)

Kutools AI Aide also caters to common needs such as translation and function parsing, among others. This makes it a versatile tool that adapts to various user requirements, facilitating a more efficient and comprehensive use of Excel.

1. In the chat box, please input the translation command followed by the content you wish to translate.
   
   “Please translate the following content into French:(your content)”
2. Then, click the Send button or press Enter key. Kutools AI Aide will translate the text into French as you need. See the demo below:
   
3. Then, you can copy and paste the translated text to anywhere you need.

Useful Tips for Using Kutools AI Aide

Disable Kutools AI Features or Turn Off the Kutools AI Tab

Kutools AI is designed to enhance productivity by bringing powerful AI capabilities directly into Excel. However, there may be situations where you prefer to temporarily disable AI features or hide the Kutools AI tab—for example, to reduce interface clutter, improve performance, comply with organizational policies, or avoid accidental use.

Turn off or turn on the Kutools AI Tab

Clicking the Close This Tab option will close the Kutools AI tab, and it won't appear in future. In this case, to activate the Kutools AI Aide feature, please click Kutools > AI Aide > Show Kutools AI Tab, see screenshot:

---

Disable or enable Kutools AI Features

This section explains how to turn Kutools AI features on or off, giving you full control over when AI is available and how it’s used in your Excel environment.

Go to the Kutools tab on the ribbon, click AI Aide > Disable All AI Features of Kutools.

Tip: To re-enable it, please go to Kutools > Help > Settings Center, and check Enable AI Features of Kutools option. See screenshot: