This module allows you to use OpenAI's powerful artificial intelligence models within Excel. You can generate text, analyze data, classify, and more with just a few clicks.

To install this module, you need to have Excel 2016 or later and an OpenAI account (I have used Azure OpenAI). Follow these steps to try it out:

1. Create a new Excel file

2. Save the file as a macro enabled workbook (doesn't work with OneDrive folders)

3. Go to Options and enable the developer ribbon

4. Go to the developer ribbon and click on Visual Basic or click Alt+F11

5. Open the Tools menu and click on References

6. Check the Microsoft Scripting Runtime reference and click ok

7. Open the https://raw.githubusercontent.com/VBA-tools/VBA-JSON/master/JsonConverter.bas and save the file as JsonConverter.bas to the same folder

8. Open the https://raw.githubusercontent.com/vieiraae/Excel-with-OpenAI/main/OpenAIModule.bas and save the file as OpenAIModule.bas to the same folder

9. Open the https://raw.githubusercontent.com/vieiraae/Excel-with-OpenAI/main/OpenAIModule.json and save the file as OpenAIModule.json to the same folder

10. Open the OpenAIModule.json file and add your AZURE_OPENAI_ENDPOINT and AZURE_OPENAI_KEY. Confirm the deployment name that you used for the davinci model.

11. Go to the File menu and click on Import File and choose the JsonConverter.bas module. Repeat the step for the OpenAIModule.bas.

12. After importing the modules you should see both modules in the VBAProject content and you can now delete the *.bas files from the folder.

13. Now you can close the Visual Basic editor and return to the Excel window.

14. Select a cell and type a formula starting with "=GPT". It should display the list of functions available in the OpenAI module that was just imported.

15. To troubleshoot and debug, check the immediate window from the Visual Basic editor. It will show the invocations done against the Azure OpenAI API.

This OpenAI module provides several functions that you can use in your worksheets. Each function takes a set of parameters that specify the input data, and OpenAI parametrization. The following table summarizes the available functions and their parameters.

These functions pretend to explore the possibilities with this integration with OpenAI. Change the functions or add your owns to adapt the code to your needs.

Here are some examples of how to use the OpenAI module in Excel.

In this example, we use the GPT_COMPLETION function to generate a product description based on a product name.

The result is:

In this example, we use the GPT_GENERATE_INSIGHTS function to analyze some sales data using natural language queries.

We can ask questions like:

• What is the average sales per month? =GPT_GENERATE_INSIGHTS(A7, A1:B6)
• Which month had the highest sales? =GPT_GENERATE_INSIGHTS(A8, A1:B6)
• How much did the sales increase from Jan to May? =GPT_GENERATE_INSIGHTS(A9, A1:B6)

The results are:

This module is an experimental project and not an official product of OpenAI or Microsoft. It is provided as-is, without any warranty or support. Use it at your own risk.

Please note that using Excel with macros enabled could represent a security vulnerability. Be careful when opening files from unknown sources or downloading add-ins from untrusted websites. Always scan your files with antivirus software before opening them.

Also, be mindful of the ethical and social implications of using artificial intelligence. Do not use this module for malicious or harmful purposes. Respect the privacy and dignity of others. Do not generate or distribute false or misleading information. Do not infringe on the intellectual property rights of others. Do not violate the terms and conditions of OpenAI or Microsoft.