Questions for Excel
How do I install the GPT in Excel add-in?
Install from Microsoft AppSource:
- Go to the installation page.
- Click Get it now.
- Follow the steps until the end.
Learn more: Install GPT in Excel
How can I use ChatGPT from Excel?
After you’ve installed the GPT in Excel add-in:
- Create a new Excel workbook.
- Enter a GPT function in a cell.
=GPT("Say hi")
Where can I find the list of available GPT functions?
The list along with full documentation and video tutorials is available in our reference page.
Which GPT models can I use?
In Excel, the only model available for now is ChatGPT gpt-3.5-turbo.
Which natural languages can I use?
OpenAI’s GPT models work in many languages, but deliver best results in English. All we can say is try it. It is usually better to prompt in the language you want the response to be. In any case, avoid mixing languages in a prompt.
Who are these extensions made by?
These extensions are made by Talarian. Talarian is a profitable company established in 2015, specialized in Google add-ons and Microsoft add-ins. There are around 40 people working at Talarian.
Talarian is ISO27001 certified.
What permissions are required by the Microsoft add-in?
The add-in requires the following permissions:
- View your basic profile
- Maintain access to data you have given it access to
| Permission | Reason |
|---|---|
| View your basic profile | Allows the add-in to see your basic profile (name, image, user name). |
| Maintain access to data you have given it access to | Allows the add-in to see and update the data you gave it access to, even when you are not currently using it. This does not give the app any additional permissions. |
What do you do with the data in my documents?
- We log the prompt parameter strictly for product improvement purposes.
- We don't log the value parameter.
- The full set of parameters is sent to the OpenAI API to get the response.
- The rest of your workbook data is never read nor stored on our servers.
More details in our Privacy Policy and DPA.
What is a credit?
A credit is the unit of account for billing of executions. Every execution costs credits. Credits are purchased by pack. Each pack expires after 90 days. You need to purchase credits to use GPT in Excel.
What is an execution?
An execution is a call of a GPT function (full list here) from an Excel cell. Each execution consumes between 1 and 8 credits. The amount of credits consumed depends on the size in tokens of the input and output. A refresh consumes credits unless the execution is cached. Errors do not consume credits.
What is a token?
Inputs and outputs are measured in tokens. Tokens can be seen as groups of characters. In English, on average, 1 word = 1.3 tokens In other languages, usually 1 word = 2+ tokens You can get the exact token size of a text from the OpenAI tokenizer. See our Token guide for more info.
How much does an execution cost?
An execution consumes minimum 1 credit, which allows for up to 500 tokens (~375 words in English) of input and output, which should be enough for most tasks. If the input + output is larger, the execution can consume up to 8 credits:
| Credits | Max tokens | Max words |
|---|---|---|
| 1 | 500 | ~375 |
| 2 | 1000 | ~750 |
| 3 | 1500 | ~1125 |
| 4 | 2000 | ~1500 |
| 5 | 2500 | ~1875 |
| 6 | 3000 | ~2250 |
| 7 | 3500 | ~2625 |
| 8 | 4000 | ~3000 |
- In English: 1 word ≈ 1.3 tokens
- In Spanish: 1 word ≈ 2 tokens
- In French: 1 word ≈ 2 tokens
How does credit expiration work?
Each pack of credit expires 90 days after their purchase date. It means that credits purchased on June 1st, 2023 will expire on August 30th, 2023. You can buy another credit pack at any time. Credits are consumed in the order of purchase.
Is there a free plan?
You have 100 free credits to try GPT in Excel for free. After consuming your free credits, you must purchase a credit pack to continue using the add-in.
Can I get a refund?
We do not offer refunds. We encourage you to carefully consider how many credits you need before purchasing.
How do I get support?
We recommend checking our troubleshooting errors page.
If it doesn’t help, please let us know by submitting a support request so we can assist you further.