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.
Download Excel Add-in for ChatGPT
Click on the Download button below depending on the operating system of your computer.
For WindowsFor Mac OS
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
Filetab. - Click on
Optionsand then selectAdd-insfrom the left-hand menu. - In the
Managedrop-down menu at the bottom of the screen, selectExcel Add-insand click on theGobutton. - Click on the
Browsebutton and select the add-in file that you downloaded. Click on theOKbutton. - Check the box next to
ChatGPTadd-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.
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
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
Other Features of Add-In
You can update your API key by clicking on Update Key button. Similarly you can check your existing API key by clicking on Check Key button.
You can change quality of response of ChatGPT by changing temperature parameter by clicking on Fine Tune Response button. The value of this parameter lies between 0 and 2. Higher values like 1.5 will generate the output more random, while lower values like 0.5 generate more focused output.
Where is the API key stored in this add-in?
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
Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and Human Resource.
Post a Comment