How to use CHAT GPT in Excel: plugin

In this article, we will discuss how to use the Excel add-in for ChatGPT.

The Excel add-in we propose includes various functions to use ChatGPT seamlessly in MS Excel. The combination of ChatGPT and Excel will improve your productivity and help you make faster, smarter data-driven decisions.

This add-in is 100% free and can run on any version of MS Excel and does not even require a Microsoft Office 365 license to use it.

Download the ChatGPT Excel Add-in

Click the button below to download the ChatGPT plugin.

DOWNLOAD ADD-IN

How to Install The Add-in

The first thing you need to do is trust the add-in file so Microsoft doesn’t prevent it from running. This security warning is not specific to this add-in. This is something you need to do with every Excel add-in that you download from the internet. Refer to the steps below

Right-click on the add-in file and select Properties. Select the checkbox Unblock under the Security option and then click OK

Follow the steps below to install and activate the add-in

1. Open Excel and click on the Filetab.
2. Click on Options and then select Add-ins from the left menu.
3. In the Manage dropdown menu at the bottom of the screen, select Excel Add-ins and click on the Go button.
4. Click on the Browse button and select the downloaded add-in file. Click on the OK button.
5. Check the box next to the ChatGPTadd-in to activate it.

AI Search Engine

There are two ways to search with ChatGPT in Excel. One is via the add-in button and the other is via the Excel function.

If you don’t have ChatGPT API key , you must create your account here platform.openai.com. The next step is to generate the API key and copy it to use in the add-in.

AI Assistant

Click the AIAssistantbutton in the ChatGPT tab and select the cell where the prompt (question) is entered. For example, you have the text “Capital of Spain” in cell B2. You need to select cell B2 in the input box. It will ask for the API key if you use it for the first time. Make sure you have the ChatGPT API key generated before this.

For similar functionality, you can also AIAssistant( )function. The advantage of using the function is that you can run it for multiple prompts by dragging the function down.

AIAssistant(text, [word_count])

1. text : text you want to search in ChatGPT
2. word_count : optional. Specify the desired word count for the output generated by ChatGPT

Fill missing data

The AIAssistant_FillData( )function uses existing data to train ChatGPT and fill incomplete data.

AIAssistant_FillData(rng_existingdata, rng_fill)

1. rng_existingdata : Range of existing data
2. rng_fill : specify the range of data that needs to be filled

Extract key data

Using the AIAssistant_Extractor( )function, you can extract important information such as names, locations, organizational details, and more from ChatGPT.

AIAssistant_Extractor(prompt, keyword)

1. prompt : text from which you want to extract key data
2. keyword : the keyword can be a name, place, organization, number etc.

Master Excel Formulas

The AIAssistant_Explain( ) function helps you learn any Excel formula.

AIAssistant_Explain(cell_formula, [detail])

1. cell_formula : specify the cell containing the Excel formula you need to learn
2. detail : Optional. Defaults to TRUE. Set to FALSE if you want a less verbose response

Generating Insight

The AIAssistant_Insights( ) function helps you generate insights from data. The plugin acts as an analyst and will analyze the data for you.

AIAssistant_Insights(rng_data, [prompt])

1. rng_data : specify the cells containing the data you want to analyze.
2. prompt : optional. Specify the information you want to know about the data.

Translate Text

The AIAssistant_Translator( ) function helps you translate any text. It’s like embedding Google Translate functionality into Excel.

AIAssistant_Translator(text, language)

1. text : specify the cell containing the text you need to translate.
2. language : specify the cell containing the language name.

Other Add-in Features

• You can update your API key by clicking the Update Keybutton. Similarly, you can check your existing API key by clicking the Check Keybutton.
• You can improve the quality of ChatGPT’s response by modifying the temperatureparameter by clicking the Fine Tune Responsebutton. The value of this parameter is between 0 and 2. Higher values like 1.5 will generate output more randomly, while lower values like 0.5 will generate more focused output.

Where is the API key stored in this addon?

It is stored in your system only in the registry.

Pubblicato in Artificial Intelligence, Excel, Guides & Tutorials