How to Integrate ChatGPT into Excel

preview_player
ะŸะพะบะฐะทะฐั‚ัŒ ะพะฟะธัะฐะฝะธะต

๐——๐—˜๐—ฆ๐—–๐—ฅ๐—œ๐—ฃ๐—ง๐—œ๐—ข๐—ก
โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€
In this video, I'll show you how you can integrate ChatGPT, specifically the ChatGPT-3.5 Turbo Model and GPT-4 model, into your Excel spreadsheet. I've written a VBA code for you, which you can use for free! Not only will I walk you through some practical examples, but Iโ€™ll also guide you step-by-step on how to set everything up. By following each step, you'll have ChatGPT functionality in Excel in no time!

๐ŸŒ ๐—Ÿ๐—œ๐—ก๐—ž๐—ฆ:

โญ ๐—ง๐—œ๐— ๐—˜๐—ฆ๐—ง๐—”๐— ๐—ฃ๐—ฆ:
0:00 โ€“ Introduction
1:13 โ€“ How to set things up
5:00 โ€“ Run via Quick Access Toolbar
5:32 โ€“ Run via button
6:00 โ€“ Run via own Excel add-in
6:23 โ€“ Run via MyToolBelt add-in
7:10 โ€“Outro

๐—ง๐—ข๐—ข๐—Ÿ๐—ฆ ๐—”๐—ก๐—— ๐—ฅ๐—˜๐—ฆ๐—ข๐—จ๐—ฅ๐—–๐—˜๐—ฆ
โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€

๐—–๐—ข๐—ก๐—ก๐—˜๐—–๐—ง ๐—ช๐—œ๐—ง๐—› ๐— ๐—˜
โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€โ–€

โ˜• ๐—•๐˜‚๐˜† ๐—บ๐—ฒ ๐—ฎ ๐—ฐ๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฒ?
If you want to support this channel, you can buy me a coffee here:
ะ ะตะบะพะผะตะฝะดะฐั†ะธะธ ะฟะพ ั‚ะตะผะต
ะšะพะผะผะตะฝั‚ะฐั€ะธะธ
ะะฒั‚ะพั€

Thanks Sven, works well. One tip: if the prompt contains the double quotes character (Chr(34)) then it will throw an error

SjorskePT
ะะฒั‚ะพั€

Loved your video, thank you!! Would you please suggest how we can change the code to output the returned completion to the next cell of the input cell, as opposed to the new sheet?

yyvccek
ะะฒั‚ะพั€

So if you have a ChatgGPT Plus subscription, the API keys you can generate do not work unless you pay separately for the API through the billing as shown on his video. @codingIsFun great video, but missed this little detail :(

apinos
ะะฒั‚ะพั€

even with gpt 4 i am getting a 404 invalid_request_error type model_not_found code message the model gep-4 does not exist or you do not have access to it " any ideas as to what i did wrong? new to this stuff but loving the videos-- i subscribed ! thank you for your work!

dylanpugliese
ะะฒั‚ะพั€

Can copilot 365 and other ai tools can all works in ms Excel
Or is it still important to learn deeply ms Excel???

goutamnayak
ะะฒั‚ะพั€

Is it possible to retrieve real-time data with this method? I have tried but it doesnt seems to work ?

eddymeshack
ะะฒั‚ะพั€

Hello, I appreciate what you have done. I can use ChatGPT in Excel, but only once if I try to generate text once again the error appears: That name is already taken. Try a different one. Error number 1004

abracadabra
ะะฒั‚ะพั€

Is it possible to use the GPT4 turbo ?

zoqttvw
ะะฒั‚ะพั€

After doing full process then its showing error message comes : the chatgpt 4 does not exist or you do not hve access to it

amitrama
ะะฒั‚ะพั€

Mine does not work. I get an error saying "An error occurred: Programmatic access to Visual Basic Project is not trusted. Error number: 1004. Line number: 40

smelx
ะะฒั‚ะพั€

mine dossent work even tho i got chat gpt4

ernsholt
ะะฒั‚ะพั€

Error message - The model Da Vinci - 003 has been deprecated

nikdandekar