This is a simple example of how to use the OpenAI (ChatGPT) API from Microsoft Excel without any macros, but by using Power Query. The M-code script can also be used in Microsoft Power BI.
Please ★ Star on the top of this page if you like this and want to motivate me to publish more.
Instruction can be found in the sheet: