![GPT for Work (GPT for Sheets, Docs, Excel Word)](/img/default-banner.jpg)
- 48
- 977 674
GPT for Work (GPT for Sheets, Docs, Excel Word)
United States
Registrace 21. 05. 2021
Like ChatGPT? Imagine having it in Google Sheets, Google Docs, Microsoft Word and Microsoft Excel! 🤠
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: gptforwork.com/install-msft
👉 Install for Google: gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡Website: gptforwork.com
🛟Help: gptforwork.com/help
This channel is brought to you by Talarian: talarian.io
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: gptforwork.com/install-msft
👉 Install for Google: gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡Website: gptforwork.com
🛟Help: gptforwork.com/help
This channel is brought to you by Talarian: talarian.io
How to use ChatGPT into Microsoft Word: a beginner’s guide (101)
Like ChatGPT? Now, use it in Word too! Discover how to use the GPT for Excel Word add-in and unleash the power of OpenAI's artificial intelligence with its latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo directly into Microsoft Word! 👇
Get the GPT for Excel Word add-in: gptforwork.com/install-msft
Chat with your Word documents and edit them by inserting chat responses directly inside the documents. You can also track these changes effortlessly using Microsoft Word's Track Changes feature.
The add-in enables you to:
- translate all or parts of your documents
- quickly create new relevant content
- ask questions to quickly understand what a document is about
- spot key information in a document
and much more !
⌚️ TIMESTAMPS
00:00 Introduction
00:26 Summarize a document
00:57 Extract information from a document
01:39 Translate content
02:08 Track changes made in the document when inserting chat responses
03:23 Clear chat
03:40 Switch OpenAI’s models
03:57 How to buy a pack
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Word add-in: czcams.com/play/PLI1hJP_Ps2kP0ORvlHVpUV5XFyNTJYP4r.html
📥 Find out more about how to use GPT for word : gptforwork.com/help/gpt-for-word
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback, we'll be happy to answer: support.gptforwork.com/hc/en-us/requests/new
------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: gptforwork.com/install-msft
👉 Install for Google: gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡 More resources and examples on our website: gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: www.youtube.com/@gpt4work
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : yamm.com/
🔥 AWESOME TABLE : awesome-table.com/
🤖 FORM PUBLISHER : form-publisher.com/
Get the GPT for Excel Word add-in: gptforwork.com/install-msft
Chat with your Word documents and edit them by inserting chat responses directly inside the documents. You can also track these changes effortlessly using Microsoft Word's Track Changes feature.
The add-in enables you to:
- translate all or parts of your documents
- quickly create new relevant content
- ask questions to quickly understand what a document is about
- spot key information in a document
and much more !
⌚️ TIMESTAMPS
00:00 Introduction
00:26 Summarize a document
00:57 Extract information from a document
01:39 Translate content
02:08 Track changes made in the document when inserting chat responses
03:23 Clear chat
03:40 Switch OpenAI’s models
03:57 How to buy a pack
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Word add-in: czcams.com/play/PLI1hJP_Ps2kP0ORvlHVpUV5XFyNTJYP4r.html
📥 Find out more about how to use GPT for word : gptforwork.com/help/gpt-for-word
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback, we'll be happy to answer: support.gptforwork.com/hc/en-us/requests/new
------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: gptforwork.com/install-msft
👉 Install for Google: gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡 More resources and examples on our website: gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: www.youtube.com/@gpt4work
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : yamm.com/
🔥 AWESOME TABLE : awesome-table.com/
🤖 FORM PUBLISHER : form-publisher.com/
zhlédnutí: 91 290
Video
GPT for Excel: a beginner's guide (101)
zhlédnutí 90KPřed 6 měsíci
Like ChatGPT? Now, use it in Excel too! Discover how to use the GPT for Excel Word add-in and unleash the power of OpenAI's artificial intelligence with its latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo directly into Microsoft Excel! 👇 Get the GPT for Excel Word add-in: gptforwork.com/install-msft This add-in enables simple custom functions to help you achieve all sort of tasks suc...
Insert options in GPT for Docs
zhlédnutí 2,8KPřed rokem
In this video, find out what the different insertion options available in GPT for Docs are. Simply decide where your output should be generated in your Google Docs and easily manage all the insert settings directly from the sidebar. There’s more: GPT for Docs has a highlight feature to make your output stand out from the rest of your text. You can also choose whether to insert your prompt in yo...
Use document context with ChatGPT in Google Docs
zhlédnutí 4,3KPřed rokem
Feeding your prompt with the right context is very important to generate specific and accurate content with ChatGPT. In this video, we explain to you how to use the GPT for Docs sidebar to use your document or portions of your documents as context to generate more writing with ChatGPT in Google Docs. ⌚️TIMESTAMPS 00:00 Use the whole document as context 1:16 Use a selection as context to expand ...
Comparing Google Translate and ChatGPT for Hindi to English
zhlédnutí 10KPřed rokem
In this video, we compare Google Translate and ChatGPT through a compelling example of an English/Hindi translation. Unlike Google Translate, with ChatGPT you can customize your prompts and provide some context to get more accurate results. Make sure your translations are consistently spot-on by using ChatGPT and GPT for Sheets and Docs 😉 ⌚️TIMESTAMPS 00:00 Introduction 00:27 Translate indian n...
Split your text with GPT for Sheets
zhlédnutí 5KPřed rokem
Our new function GPT_SPLIT enables you to semantically split text and get one item per cell. Use GPT_SPLIT to return outputs listed vertically and GPT_HSPLIT if you prefer to get the outputs listed horizontally. You can split your text into: - sections - paragraphs - sentences - punctuations and even letters! ⌚️TIMESTAMPS 00:00 Vertically split your text into paragraphs 01:39 Horizontally split...
Translate text with a custom dictionary and GPT_TRANSLATE
zhlédnutí 2,7KPřed rokem
Do you need to translate text but want to avoid literal translations for specific terms or words? Introducing the refined GPT_TRANSLATE function, which allows you to effortlessly translate text using your own customized dictionary. This is super useful when translating: - generic words into very specific terms (such as brand names) - common source-language abbreviations or terms that have no st...
How to use ChatGPT into Google Docs: a beginner's guide (101)
zhlédnutí 16KPřed rokem
Like ChatGPT? Use it in Google Docs! The possibilities of ChatGPT are almost endless. Discover how to use the GPT for Docs add-on and unleash the power of OpenAI GPT-3 and GPT-4 artificial intelligence directly into Google Docs - no need to mess with apps script! 👇 Get the GPT for Sheets and Docs add-on: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 Our custom sideba...
Introducing the GPT for Sheets sidebar!
zhlédnutí 6KPřed rokem
We just released the GPT for Sheets sidebar! A brand-new interface that will help you be even more efficient when using ChatGPT in Google Sheets. In this video, we show you the latest features we developed including: a list of all our functions to easily spot which GPT function best suits your needs a Google Sheets assistant for you to quickly understand and generate Google Sheets formulas a ce...
Create an interactive FAQ with GPT for Sheets
zhlédnutí 3,1KPřed rokem
Create your own interactive FAQ in Google Sheets! In this video, we explain step-by-step how to build an interactive FAQ with GPT for Sheets. Now, you can ask your questions directly in your spreadsheet and let ChatGPT answer them! Function in this video Syntax =GPT_MAP(search_keys, range, [confidence], [stats], [top_k]) ⌚️ TIMESTAMPS 00:00 See how it works (example) 01:21 Step 1: Identify rel...
Bulk write and send unique emails with ChatGPT and YAMM
zhlédnutí 6KPřed rokem
Discover how to write and send unique personalized emails in bulk thanks to GPT for Sheets and YAMM. ⌚️TIMESTAMPS 00:00 Draft your first email body 02:28 Get different emails for each recipient 04:50 Write email subject lines 06:14 Create a Gmail email draft 7:46 Run YAMM and send your emails 09:00 Track your emails status ▶️ PLAYLIST: Discover all the functionalities of the GPT for Sheets and ...
Autofill your ranges based on examples with ChatGPT in Sheets!
zhlédnutí 11KPřed rokem
Sometimes describing what you want in a prompt can be tricky! With the GPT_FILL function of GPT for Sheets, just write a few example rows to show what you expect, and ChatGPT will fill the rest of your list rows according to the defined pattern. In this video, we present two use cases but you can use GPT_FILL() in Google Sheets to: - clean up your lists - extract entities - classify content and...
How to control the execution of your GPT for Sheets functions
zhlédnutí 6KPřed rokem
How to control the execution of your GPT for Sheets functions
Creating Tables of Data in Seconds with ChatGPT
zhlédnutí 19KPřed rokem
Creating Tables of Data in Seconds with ChatGPT
Let’s compare ChatGPT and GPT-3 models with GPT for Sheets
zhlédnutí 2,8KPřed rokem
Let’s compare ChatGPT and GPT-3 models with GPT for Sheets
Format your data in Sheets automagically with ChatGPT
zhlédnutí 7KPřed rokem
Format your data in Sheets automagically with ChatGPT
Create lists of data in Sheets with ChatGPT
zhlédnutí 16KPřed rokem
Create lists of data in Sheets with ChatGPT
How to map two columns of values in Google Sheets with ChatGPT
zhlédnutí 31KPřed rokem
How to map two columns of values in Google Sheets with ChatGPT
Polish your content with ChatGPT in Google Sheets
zhlédnutí 7KPřed rokem
Polish your content with ChatGPT in Google Sheets
Classify data in Google Sheets with ChatGPT
zhlédnutí 22KPřed rokem
Classify data in Google Sheets with ChatGPT
How to summarize text with ChatGPT in Google Sheets
zhlédnutí 12KPřed rokem
How to summarize text with ChatGPT in Google Sheets
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
zhlédnutí 19KPřed rokem
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
zhlédnutí 13KPřed rokem
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
Make ChatGPT tag your data in Google Sheets with GPT_TAG
zhlédnutí 11KPřed rokem
Make ChatGPT tag your data in Google Sheets with GPT_TAG
How to easily call ChatGPT in Google Sheets
zhlédnutí 28KPřed rokem
How to easily call ChatGPT in Google Sheets
Generate tables of data in Google Sheets with ChatGPT
zhlédnutí 23KPřed rokem
Generate tables of data in Google Sheets with ChatGPT
ChatGPT in Sheets: how to use OpenAI temperature parameter
zhlédnutí 7KPřed rokem
ChatGPT in Sheets: how to use OpenAI temperature parameter
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter
zhlédnutí 12KPřed rokem
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter
hey stan i have an issue i used gpt fill but the function didnot fill the other remaining rows it only fills one row i tried several ways use dragging the way down but it gives error whats the problem plz guide me thankyu
wow...this is amazing.
Wow
so you need a pay openai account for using this?
not any more. it was needed at the launch of the product and through 2023
@@gptforwork Thanks a Lot!!!
🎉🎉🎉🎉🎉❤❤❤❤😂
How can you personalize the email with the name of the person?
you can include the name in the prompt with a reference to the cell or column
@@gptforwork Thank you Stan, very useful. One last question, can GPT for Work can browse the internet?
Yes, in Sheets / Excel, via GPT_WEB or the "Search the web" Bulk tool, which use the perplexity.ai API under the hood
is there a limit to the amount of times i can use this with ms word
you're only limited by what you pay for.
非常感谢您的分享,您把您的智慧充分发挥出来,充分帮助到了那些需要的人,我作为一个英文不好的中国人,无法顺畅的使用这个工具,感觉错过了一个宝藏。还是感谢您的分享。
thank you for your feedback! we will try to make it easier for Chinese speakers to use our product in 2025 (translating the UI and our video tutorials)
Add glossary support to customize translation , add Claude sonnet 3.5 models.
roger that! sonnet 3.5 is coming soon to Word, and then we will add the glossary.
ok
nice
And height
okay
I have a MS 365 personal license, when I click "sign in with Microsoft', it brings up a sign in window in the left, i input the correct details, it then closes the sign in window and nothing happens (still showing the 'Welcome to GPT for Word' window to the right) - Any ideas / help would be appreciated!
Microsoft had a big outage last week, could you please try again?
Use the example of a ready-made table to show why you are showing an empty table, creating it in front of us?
thanks for the feedback!
I like the addin a lot. Can I also use default prompts in word? I usually only want it to correct a selection of word text and I do not want to retype my prompt ("correct this") again and again. Thank you!
thanks for the feedback, makes a lot of sense. we'll work on that soon!
Nothing fancy, but thanks, you saved some of my brain cells, so now I don't have to invent all this :)
sure, happy to help!
wow thankyou
Welcome 😊
Hi, I've installed the extension, my =GPT formula is working on 50% of the rows. Where it is not working it is saying #Error and states Error: Empty balance. Go to: Extensions > GPT for Sheets™ and Docs™ > Billing. (line 8204). I have looked to try and renew the API key, however the API key is not listed in the extension menu. Any help will be greatly received.
I am using GPT 4 and the sidebar says that no API key needed, which i now realise is why I don't have it in the menu.
I have $20 credits in the OpenAI account.
hello, you need to buy a pack from us. We need to make some money too!
*A VERY IMPORTANT and USEFUL FACT I'd like to point out:* What else needs to be mentioned about this add-in, and what makes it exceptionally good, is that most other ChatGPT-based programs, add-ins, or add-ons that use an API key tend to forget the previous context. In most cases, every API key query is a separate instruction that connects with the ChatGPT servers, where ChatGPT itself handles only that one request, regardless of the previous request(s). However, here I see that even when using an API key, it maintains the previous context. At least for 5-6 prompts, it’s guaranteed. This is a significant and outstanding feature (whether intentionally designed or accidentally discovered) that should be highlighted in any advertisement! For shorter texts, it does an excellent job even with an API key, maintaining context for up to 5-6 sentences. Even if I process sentences individually, it consistently keeps track of the context up to 5-6 sentences. Personally, I use a mix of both methods-uploaded credits for longer texts, as it handles extensive context, and API keys for shorter ones. This way, this add-in strikes a balance and offers a win-win solution for everyone. In summary, I don't know if you personally created it or just made the reviews about it, but either way, thank you to the developer for this sensational MS Word add-in! this is excellent and highly versatile, especially considering related context, depending on the length of the text to be processed! Just an exceptional return on investment!
hello
hi
how to get the editing tabs that next to share tab at upper right .
please contact our support
한국어
안녕하세요!
How many lines can it do?
with our bulk tools, up to 200k rows in a single run works well. It will take ~10 hours.
hello! can i use this without chat gpt and create my own questions and answers?
yes you can!
Is there a way to do this in the sidebar? This is the one thing I think this is missing is the ability to chat with a sheet
not yet, but soon
The answer that visible is short.
not sure I understand?
This was great
thanks!
Can this help me make macros to automate my workflow?
hello, not at the moment.
Is there a way to extract data from a PDF?
Hi, just recently we have added integration with OpenAI assistants, so you could upload your PDF to an OpenAI assistant and then use it to extract data. If this doesn't work for you, we'd be interested in hearing more detail (how do your PDF look like, what data do you want to extract, etc) about your use-case so we can improve the product for you. Please contact our support!
Great video, quick and efficient, thanks!
Glad it was helpful!
This amazing!, but ... can i also use this AI for excel formulas?
想的美
you can use GPT for Excel to write/edit/translate/analyse text in Excel, but not yet for formulas
Thanks for the tutorial it was very intuitive, however I believe you might need to update your video as some of the features you mentioned aren't available on the new installments.
Hello, yes indeed, the product has improved a lot, I need to make new videos, they will come soon :)
Will I be charged if I install in extension?
No, only if you purchase a pack. There is no hidden charges!
Estimado, donde puedo ver estos tutoriales en español???
Lo siento, aún no tenemos tutoriales en español.
Not sure what your "Chinese" translation actually stated. Chinese is not a language. The major languages spoken in China is Mandarin and Cantonese. Was your translation to mandarin or cantonese? If you don't know, how do you know it serves the interest of your target group?
As a Cantonese native speaker, I can tell that although Cantonese also has its own writing system, we normally don't use it in formal situation. What you can see is the "written Chinese", defaulted to simplified Chinese, which is used in China, Malaysia, Singapore, etc.. If you target group is from Hong Kong or Tai Wan, you gotta ask it to translate to Traditional Chinese. Hope it helps.
Hello, sorry if my example was poorly chosen and thank you for teaching me. I'll be more careful next time. You can of course input Mandarin or Cantonese instead of "Chinese".
This is annoyingly the best tutorial ever...!
why annoyingly? :)
In the past few months, I've used this plugin to process over 20 million tokens. It's truly an incredibly efficient tool, and words cannot express my gratitude.
Thank you so much ♥
you're welcome!
Thanks for this video, but I would like to know if this extension for Google Document is free or paid. or if it has a limited-time free trial.
hello, it is paid
Hi , can you demonstrate an example of a table with two columns with numbers and I want a third column with GPT analysis about the relations between the 2 numbers in each raw
hello, sure this can now be done by using an OpenAI assistant (we've recently integrated with them). Will make a video of it soon. Would you have an example of numbers you'd like to analyse?
Mw vle tandem kreyol
I can't speak Creol!
Is this GPT 4 ?
you can use GPT-4 if you choose it yes
What are the data privacy assurances ?
Hello, this is addressed in our FAQ: gptforwork.com/help/faq/questions-word
portugues
it works in portugues
WHICH RECORDER U R USING ?
loom.com in this case
if we rephrase using the gpt like you showed in the video, could it be detected by Turnitin or any AI detector?
It likely depends on the input and instructions you give.
im already paying for chatgpt I dont want pay for it twice
chatgpt is made by openai, we're a different company.
Hello, just a sincere suggestion for possible future videos. Please don't zoom in to explain specific functions. That actually hinders more than it helps. It's much easier to follow all the modifications with the screen full. It would make sense if the video were smaller than 1080p, but it's up to 4k. Despite the criticism, thank you for your video.
thanks for the feedback. I will turn off the automated zooming, I think I agree with you