How to integrate Chatgpt into Excel

How to install the additional component

When downloading an additional component or a macro file from the Internet, Microsoft blocks its execution and shows that the origin of this file is not reliable. It is necessary to follow the following steps to make it work.

1. Go to the folder where the file of theAdditional component downloaded.
2. Click the right mouse buttonon the file and choosePropertyfrom the menu.
3. At the bottom of theGeneral tab, select the control boxUnlockunder the optionSecurity, then clickOK.

Refer to the following steps to install the additional chatgpt component in MS Excel.

1. Open Excel and click on theFile card in the multifunction bar.
2. ClickOptions and then selectAdd-insfrom the menu on the left.
3. In theManagedrop -down menu at the bottom of the screen, selectExcel Add-insand click onGobutton.
4. Click onBrowsebutton and identify the file of the unloaded additional component.
5. Select the additional component file and click onOKbutton.
6. You should see the name of the additional component file in theAdd-Insdialog box. Select the box next to the name of the additional component to activate it.
7. Once the previous steps are finished, a new card calledChat GPTIt should be visible in the Excel working folder.

How to use the Excel Additional Component of Chatgpt

Follow the following steps to use the additional chatgpt component for MS Excel.

1. Open a new or existing working folder
2. Enter the text you want to ask for chatgpt in any cell
3. Click on the tabChat GPT>AI assistant
4. Enter your API key and select model type
5. Select the cell in which you inserted the text in passage 2
6. The output will be generated and will appear within a few seconds.
7. When you want chatgpt to be performed on multiple cells, you can use theAIAssistantfunction. See details in the next section.

Additional component Chatgpt Excel: Functions

The main advantage of the Excel additional component is that it does not depend on a file such as the Macro work folder and can be easily shared between work folders and different users. This additional component has the followingseven functionsthat you can use to get answers from chatgpt and insert them in Excel.

1. AIAssistant(text, [word_count]): generates and provides the output of the search query using chatgpt.
   – text:text you want to search for
   – word_count:optional. Specify the maximum number of words for the output generated by chatgpt.
2. AIAssistant_Chat(text, [reset]): The Converse website like Chatgpt recalls previous conversations.
   – text:text you want to search for
   – reset:optional. Start/reset the chat session.
3. AIAssistant_FillData(rng_existingdata, rng_fill): Fill incomplete data by training chatgpts on existing data.
   – rng_existingdata:Training data interval
   – rng_fill:Specifies the cell that must be compiled.
4. AIAssistant_Extractor(prompt, keyword): Extract the key data from chatgpt. The key data can be the name, place, details of the organization etc.
   – prompt:Specify the cell that contains the text from which you want to extract the key data.
   – keyword:The key word can be the name, place, organization, etc.
5. AIAssistant_Translator(text, language): Translates the text from one language to another.
   – text:Specifies the cell that contains the text you want to translate.
   – tongue:Name of the language. For example Spanish, French, etc.
6. AIAssistant_Explain(cell_formula, [detail]): It helps you to explain the Excel formula that you don't understand and you need support.
   – cell_formula:Cella containing an Excel formula that you want chatgpt you explain to you.
   – detail:optional. The default value is true. Set false if you want a less detailed response.
7. AIAssistant_Insights(rng_data, [prompt]): generates insights on the data from the data set provided.
   – rng_data:specifies the cells containing data (including the header).
   – request:optional. Provide the specific information you want on data.

To type the functions faster, type first=ai, then use the up or down arrow key to select the desired function and finally press theTabkey.

Search with ChatGPT

ThereAIAssistantFunction uses chatgpt to look for information and enter the results in Excel. See the example below.

= AIAA AIMA assistant ("First President of the United States")

If you want to limit the chatgpt response to a maximum of 2 words, specify "2" as a second topic of the function. For example,=AIAssistant("First President of US", 2).

Invoke ChatGPT conversations

By default, when we send API requests to Openai, it does not call the previous conversations. Consider every request bees as a new chat. It means that when he answers your current question, he does not remember your previous question.

To improve the chatgpt ability to remember previous conversations we can use the functionAIAssistant_Chat(text, [reset]). Set the second topicresetforTRUEstart/reset chat.

1. Note:both of these functionsAIAssistant()they generateAIAssistant_Chat()Output for the search query. HoweverAIAssistant_Chat()Also allows Chatgpt to remember your previous conversations, which increases the use of tokens and costs more. It is recommended to set the second topic of the functionresetasTRUEWhen it is not necessary chatgpt to recall previous conversations.

About the data

Follow the following steps to generate insights on the data or find models hidden in your data with this plug-in.

1. Click onGenerate Insightsbutton on the chatgpt tab on the multifunction bar in Excel.
2. In the message dialog box, select the cells containing the data (including the header) and then click on "OK". For example, A1: D101.
3. Wait for the insights generated by the chatgpt fipas.
4. In the message dialog box, select a cell where the output will be saved. For example, F2.
5. Select "yes" or "no" if you want that the output is populated on multiple lines or on a single line.

It is also possible to analyze the data using the functionAIAssistant_Insights(rng_data, [prompt]). The second topic of the function is optional and, by default, extracts key information from the data if nothing is specified in the second topic. See the syntax of the Aiassistant_insights () function below.

= Aiassistant_insights (A1: D101, "generates the 5 main insights")

Translate with ChatGPT

If you are trying to translate text using the Excel plugin, you should try theAIAssistant_Translatorfunction. Use chatgpts to help you with accurate translations. Simply enter the text you want to translate and the name of the language, will use the language skills of Chatgpt to provide you with the translations.

= Aiassistant_translator ("Hello, how are you?", "German")

Extract key information

ThereAIAssistant_Extractorfunction can be used to recover key information such as name, position, etc. from the text. For example, you suppose you have the text "Dave went to New York for studies" in cell B2. You want to extract the name and position from the text. Enter the following formula in Cel C2 and D2 cells.

= Aiassistant_extractor (B2, "Name") = aiassistant_extractor (B2, "location")

Fill in the missing data

ThereAIAssistant_FillDatafunction can be used for different purposes. See some of the real use cases below.

1. Sentiment analysisYou can label positive/negative/neutral feelings on customer feedback data. You just have to provide some labels in the first topic of the function.
2. Classification of industry/sectorYou have the name of a company and you want to discover their industries/sectors.
3. Text pattern extractionThere are text data that contain both characters and numerical values. Using this function it is possible to extract numeric values ​​from the text.

Learn Excel formulas

ThereAIAssistant_ExplainFunction helps you understand any Excel formula. For example, suppose you have a formula in cell B2: = Vlookup (B2, $ b $ 2: $ d $ 5.2, false). If you enter this formula = Aiassistant_explain (B2) in cell C2, will provide an explanation for the search.vert.

Handle non-English letters

Sometimes the non -English letters are not properly displayed in the response from the chatgpt fipas. This problem is related to UTF-8 coding. To solve this problem you can useCleanMsg(ChatGPT_response)the function. Refer to the following example.

= Cleanmsg (Aiassistant ("Write a post on Instagram on 'Good morning' in Spanish")))

If you are satisfied with the additional component above, it is not necessary to switch to the other following methods to integrate chatgpt in Excel. The following methods are only alternatives to the use of the additional component, but are less effective and include manual passages.