In this post we will talk about how to use Excel Add-in for ChatGPT. This Excel add-in includes several functions for you to use ChatGPT seamlessly in MS Excel. Combining ChatGPT and Excel will improve your productivity and help you to make faster and smarter data driven decisions. This add-in is 100% free and can run on any version of MS Excel and does not even require Microsoft Office 365 license to use it.
Click on the Download button below to download the ChatGPT plugin.
How to install Add-in
First thing you need to do is to make the add-in file trusted so that Microsoft does not block them from running. This security warning is not specific to this add-in. This is something you need to do with the every excel add-in you download from internet. Refer the steps below
Right-click the add-in file and select Properties. Select Unblock checkbox under security option and then click OK
Follow the steps below to install and activate add-in
- Open Excel and click on the
File
tab. - Click on
Options
and then selectAdd-ins
from the left-hand menu. - In the
Manage
drop-down menu at the bottom of the screen, selectExcel Add-ins
and click on theGo
button. - Click on the
Browse
button and select the add-in file that you downloaded. Click on theOK
button. - Check the box next to
ChatGPT
add-in to activate it.
AI Search Engine
There are two ways to search with ChatGPT in Excel. One is through add-in button and the other through Excel function.
If you don't have API key of ChatGPT, you need to create your account here platform.openai.com. Next step is to generate API key and copy it for use it in the add-in. If you want to know more about the pricing, please visit OpenAI's pricing page. To set up your billing, click on the billing section in your account settings. After that, click the "Start payment plan" button to complete your payment.
Click on AIAssistant
button in ChatGPT tab and select cell where your prompt(question) is entered. For example you have text "Capital city of Spain" in cell B2. You need to select cell B2 in the input box. It will ask for API Key if you use it for the first time. Make sure you have API Key of ChatGPT generated before this.
For the similar functionality, you can also AIAssistant( )
function. The benefit of using the function is that you can run it for several prompts by dragging the function down
AIAssistant(text, [word_count])
- text : Text you want to search in ChatGPT
- word_count :Optional. Specify the desired number of words for the output generated by ChatGPT
Multi-turn conversations (like chat)
To enable multi-turn conversations in the plug-in, follow these instructions - Guide: Activate Chat
Fill Missing Data
The function AIAssistant_FillData( )
uses existing data to train ChatGPT and fill incomplete data.
AIAssistant_FillData(rng_existingdata, rng_fill)
- rng_existingdata : Range of existing data
- rng_fill : Specify the range of data that needs to be filled in
Extract Key Data
By using the AIAssistant_Extractor( )
function, important information such as name, location, organizational details, and more can be extracted from ChatGPT.
AIAssistant_Extractor(prompt, keyword)
- prompt : Text from which you want to extract key data
- keyword : keyword can be name, place, organisation, number etc.
Master Excel Formulas
The AIAssistant_Explain( )
function helps you to learn any excel formula.
AIAssistant_Explain(cell_formula, [detail])
- cell_formula : Specify the cell that contains excel formula which you need to learn
- detail :Optional. Default value is TRUE. Set FALSE if you want less verbose response
Insight Generation
The AIAssistant_Insights( )
function helps you to generate insights from data. The plugin acts like an analyst and will analyze data for you. To read more about this, check out this link - Automated Data Analysis in Excel with ChatGPT
AIAssistant_Insights(rng_data, [prompt])
- rng_data : Specify the cells that contains data which you want to analyze.
- prompt : Optional. Specify the information which you want to know about the data.
Translate Text
The AIAssistant_Translator( )
function helps you to translate any text. It's like embedding the functionality of Google Translate in Excel.
AIAssistant_Translator(text, language)
- text : Specify the cell that contains text which you need to translate.
- language :Specify the cell that contains language name.
Working with Images
- The latest ChatGPT model can handle image as an input. To use it in Excel, you can use the function -
=AIAssistant_Image("Explain this image","C:\Downloads\myimage.png")
- To create an image using ChatGPT in Excel, you can use the function -
=createImage("monk in orange dress", "1024x1024")
- To fix non-english letters in the plug-in, refer to this Guide: Fix Encoding Issue
-
You can update your API key by clicking on
Update Key
button. Similarly, you can check your existing API key by clicking onCheck Key
button. -
You can improve the quality of the response of ChatGPT by changing the
temperature
parameter by clicking on theFine Tune Response
button. The value of this parameter lies between 0 and 2. Higher values like 1.5 will generate the output more randomly, while lower values like 0.5 generate more focused output.
It is stored in your system only in the registry.
To learn more about the VBA code behind this add-in, you can follow this tutorial -
ChatGPT in Excel
ChatGPT Plugin for MS Word
ChatGPT Plugin for MS PowerPoint.
Hi dear expert! Although I have chatgpt subscription why I am recivingg this message? "You exceeded your current quota, please check your plan and billing details. For more information on this error, read the docs: https://platform.openai.com/docs/guides/error-codes/api-errors." Many thanks in advance
ReplyDeleteContact support team of OpenAI for the same - https://help.openai.com/en/
DeleteJust to be clear, the credits for the OpenAI API are different from the ChatGPT Plus subscription. I hope you are not mixing them up. Thanks!
DeleteMany many thanks 😂 I mixed up...... You really help the "world" to move forward
DeleteHi Deepanshou,
DeleteIt's me again. Although the add-in works perfectly, it doesn't load automatically when I start Excel. I have to reload it every time I open the program. Additionally, when I launch Excel, I receive a message saying that the add-in has been moved, renamed, or deleted.
Could you please advise me on how to resolve this issue?
Thank you!
It's because you have not installed and activated it properly. Follow the steps shown in the article.
DeleteBy message saying that the add-in has been moved, renamed, or deleted means the addin has been moved from the original folder from where you installed it first time.. After you start launch excel, go to File -> Options -> Add-Ins -> Manage: Excel Add-Ins "Go...". Now you click on the Add-Ins that's causing the error and when Excel asks you to remove the missing / not found Add-In you click on keep it! Thus it gets saved and you can close Excel. Then reinstall it
DeleteYou are right! I have it again in the initial download folder....
DeleteMany thanks 🙏🙏🙏
Glad it works for you. Cheers!
Delete