OpenAI in Excel!
AI Summary
- Discovered a Power Query function to connect to OpenAI via API on a subreddit.
- Andre shared the code on GitHub; link will be in the video description.
- Code implemented in Power Query with an interface to input questions and get responses from OpenAI.
- Example usage:
- Asked for the top five countries by size and received an answer.
- Requested VBA code to unhide all sheets in an Excel workbook.
- Sought Python code for the 100th digit of pi; received a plausible response.
- Inquired about an Excel formula to sum values with date conditions; got a correct sumifs function.
- Checked for Power Query code to list dates for the last two years; received a functional response.
- To use the function:
- Create an account on openai.com and obtain an API key.
- Enter the API key in the provided Power Query file.
- If an error occurs on first use:
- Go to Data > Get Data > Launch Power Query Editor.
- Resolve any issues indicated by warning signs on queries.
- Edit credentials or define privacy levels if prompted.
- Encourages trying out the function and provides support instructions.
- Invites viewers to like and subscribe for similar content.