Release notes

Check out our latest GPT for Work updates:

Feb 23, 2024 - GPT for Sheets

Improvement

We've improved the reliability of GPT for Sheets executions when the context is very large.

Feb 22, 2024 - GPT for Excel

Announcement

You can now buy $599 and $999 packs to support your high consumption. These packs allow for around 799 and 1332 million input or output tokens with gpt-3.5-turbo, respectively. Like all packs now, they are valid for a full year.

Feb 20, 2024 - GPT for Excel and Sheets

Announcement

OpenAI has upgraded the model under gpt-3.5-turbo to gpt-3.5-turbo-0125.

This model offers:

  • Higher accuracy at responding in requested formats
  • Lower pricing
  • Larger context window

Feb 20, 2024 - GPT for Excel

Announcements

We have just launched two new Bulk tools in GPT for Excel, that allow you to:

  • Classify the content of a column into predefined categories. For example, classify your user feedback into relevant categories for your Support team.
  • Extract relevant information from a column. For example, extract email addresses from text, regardless of their original format.

To access these and more tools, click on Bulk tools in GPT for Excel sidebar.

Feb 15, 2024 - GPT for Word

Bug fixes

We solved an issue that prevented the selection of long AI responses for copying, replacing, or inserting text in your document.

Feb 15, 2024 - GPT for Work

Improvement

Packs bought from now on expire one year after their purchase date. Note that packs bought before this update still expire after 90 days.

Feb 14, 2024 - GPT for Work

Announcement

A new free extraction tool, capable of processing up to three texts simultaneously, each up to 200 characters, is now freely accessible on the GPT for Work website.

Feb 14, 2024 - GPT for Excel

Improvement

With the Custom Bulk tool, you can now preview your prompts before running them.

Feb 12, 2024 - GPT for Work

Bug fix

The Copy button in the Translate tool now copies the translated text as expected.

Feb 8, 2024 - GPT for Excel

Improvement

The count of active functions now also includes paused functions. Previously, they were included as errors.

Feb 7, 2024 - GPT for Sheets

Announcement

You can now buy $599 and $999 packs to support your high consumption. These packs allow for around 66 and 110 million input or output words with gpt-3.5-turbo in GPT for Sheets.

Feb 6, 2024 - GPT for Work

Announcement

A new classification tool is available for free on the GPT for Work website. You can classify texts up to 200 characters into up to 3 predefined categories.

Feb 6, 2024 - GPT for Excel

Improvement

We are currently improving the onboarding process for GPT for Excel. An introductory video is now available to help all new users get started.

Feb 4, 2024 - GPT for Word

Bug fix

If your API key is valid, clicking the I've fixed the problem, retry button in the OpenAI API key not working error message will now effectively recognize and validate it, enabling access to GPT for Word.

Feb 2, 2024 - GPT for Excel

Announcement

We have just launched the Translate tool in GPT for Excel.

This tool allows you to translate an entire column and specify the destination column for the results. For instance, you can translate a whole column containing multiple languages in column A into a single, common language in column B. You can also customize your translations adding Translation instructions, and use the Translation glossary to guide the AI in the process.

To access it, simply click on the Bulk tools tab in GPT for Excel sidebar.

Feb 2, 2024 - GPT for Sheets

Improvements

  • If a payment succeeds but there's a delay in the pack creation due to our billing service timing out with Stripe, you can now use a Refresh button to create the pack.
  • If you experience issues with the payment process due to network connection problems, a troubleshooting message will appear, providing instructions to assist you in resolving the issue.

Feb 2, 2024 - GPT for Word

Improvement

You can now Copy part of the AI response or Insert it into your Word document.

Jan 31, 2024 - GPT for Work

Announcement

A new translation tool is available for free on the GPT for Work website. You can translate up to 200 characters, customize your translations using the Glossary of special words, and add Custom instructions to guide the AI in the process.

Jan 31, 2024 - GPT for Sheets and Excel

Announcement

This release expands the range of OpenAI models accessible in GPT for Sheets, with and without an API key:

  • gpt-4-turbo-preview (gpt-4-turbo)
  • gpt-4-0125-preview

Improvement

  • We've updated the model switcher with the latest, most stable and used models. See our model comparator.
  • We clarified in the Settings section that Safe mode is only for gpt-4, gpt-4-turbo and GPT_WEB.

Jan 31, 2024 - GPT for Excel and Sheets

Improvement

You can now access the Cost calculator from the Token counter section of the GPT for Sheets and GPT for Excel sidebar.

When you click on the Cost calculator button, the input tokens value is auto-filled into the Usage cost calculator, allowing you to see the cost implications based on the model selected.

Jan 30, 2024 - GPT for Word

Announcement

You can now set Custom instructions to guide the AI with specific preferences and roles. These custom instructions are active until you choose to Reset to default. You can access this feature from the Settings icon.

Improvement

The size of chat history sent to OpenAI is limited to a maximum of 4,000 tokens. OpenAI responses now take 2-3 seconds, no matter the actual size of the history. This new limit significantly reduces your costs.

Jan 30, 2024 - GPT for Excel

Improvement

Now, even with an empty balance, you can use the GPT for Excel sidebar to count the number of tokens in your cells, explore the list of functions, or view examples.

Jan 29, 2024 - GPT for Word

Bug fix

We've fixed an issue where sending chat messages was causing errors. This issue, caused by a minor update in the OpenAI API, affected responses from GPT-4, GPT-4-turbo, and GPT-3.5-turbo-16k.

Jan 26, 2024 - GPT for Sheets

Announcement

To prevent further spending in any of your spreadsheets, you can now turn spending off. Auto-refreshes can still happen and cause data loss but will no longer incur costs. Replace formulas or use safe mode to avoid data loss.

Jan 26, 2024 - GPT for Docs

Bug fix

This release fixes an error that incorrectly stated the document or selection was too long to process with some models like GPT-4. Now, you can process longer documents or selections up to the full model capacity.

Jan 23, 2024 - GPT for Excel and Sheets

Improvement

The Usage cost calculator in our GPT for Excel and GPT for Sheets documentation now lets you compare pricing for two models and/or different languages. Click Add another model to compare to display two calculators side by side for easy comparison.

Jan 22, 2024 - GPT for Excel and Sheets

Improvement

The model switcher now includes a price range indicator, showing the costs of different models at a glance. For detailed pricing, hover over the dollar signs.

Jan 22, 2024 - GPT for Sheets

Improvements

  • The inline documentation for functions using specific models now includes the model name and the pricing details. This makes it easier for you to anticipate the costs of GPT_WEB, GPT_MATCH, and GPT_VISION function executions.
  • The Run button tooltip now clearly shows that exiting Pause will retrigger all formulas in #PAUSED! status. This helps you understand the cost implications before you click Run.

Jan 19, 2024 - GPT for Word

Bug fix

We've resolved an issue that led to timeouts for large requests, including your chat message, document selection, and chat history. You can now use the full capacity of models such as GPT-4 turbo, which allows 128K tokens.

Jan 19, 2024 - GPT for Excel

Improvements

The Custom prompt tool is now easier to use:

  • Tooltips now offer more details
  • Column references in the prompt field are highlighted for fast identification
  • The prompt field requires at least one column reference, reminding you to indicate the column your prompt applies to
  • The Run all button now displays the number of prompts that will be run

Jan 19, 2024 - GPT for Sheets

Improvement

Safe mode is now available with GPT_WEB, allowing you to reduce timeouts and saving responses in the formula's last parameter. This prevents data loss and avoids extra costs during automatic Sheets refreshes.

Jan 19, 2024 - GPT for Work

Improvement

We've updated the Model pricing comparator on the GPT for Work website. You can now toggle the switches to display the overall cost of function executions in GPT for Sheets and GPT for Excel, with or without your API key.

Jan 18, 2024 - GPT for Sheets

Improvement

In this update, we've added a warning message for expired or revoked safe mode authorization. Just click Re-authorize safe mode to renew access.

Jan 17, 2024 - GPT for Sheets

Improvement

Now, when facing issues with your OpenAI API key, a more detailed error message accompanies the Continue without an API key button.

Jan 17, 2024 - GPT for Word

Improvement

Multi-line chat messages now disappear upon submission, making the AI response easier and faster to see.

Jan 16, 2024 - GPT for Sheets

Bug fix

We've addressed the Request too large error in safe mode, which previously occurred when a prompt combining multiple cells exceeded 50,000 characters.

Jan 15, 2024 - GPT for Sheets

Improvements

  • The Pricing screen now provides clearer information. You can now easily determine the word capacity of a pack based on model choice and the language of your inputs and outputs.
  • The model switcher now displays tooltips for each model, indicating costs based on the model selected and the size of input and output tokens.

Jan 15, 2024 - GPT for Sheets

Announcement

The new GPT_WEB function enables you to search the web to provide up-to-date information. It should be used whenever you ask questions about events, facts, people, companies for which freshness and accuracy is important. It is built on perplexity.ai's online models.

Jan 12, 2024 - GPT for Excel

Announcement

The new GPT_WEB function enables you to search the web to provide up-to-date information. It should be used whenever you ask questions about events, facts, people, companies for which freshness and accuracy is important.

It is built on perplexity.ai's online model.

Improvement

The Pricing screen now provides clearer information. You can now easily determine the word capacity of a pack based on model choice and the language of your inputs and outputs.

Jan 11, 2024 - GPT for Excel

Announcement

We have just launched the first tool for GPT for Excel.

This tool allows you to apply any prompt to an entire column and specify the destination column for the results, without writing a single formula. For instance, you can easily shorten product names from column A and have the results appear in column B.

To access it, simply click on the Tools tab in GPT for Excel sidebar. Watch this tutorial to get started.

Jan 11, 2024 - GPT for Work

Announcement

You can now visualize how a specific piece of text is split into tokens and the overall count of words, characters and tokens, according to a specific model. Access this new tokenizer on our website.

Jan 8, 2024 - GPT for Word

Improvement

GPT for Word now supports the gpt-3.5-turbo-16k model from OpenAI. This model lets you use context windows up to 16,000 tokens.

Jan 8, 2024 - GPT for Excel

Improvement

With this release, you can add your OpenAI organization ID in the GPT for Excel sidebar. If you are part of multiple organizations, it ensures that you get billed on the correct account.

Jan 3, 2024 - GPT for Sheets

Improvement

We've fixed an issue that prevented GPT functions from executing in spreadsheets with Japanese, Danish, Chinese, or Korean language settings when GPT-4 safe mode was enabled.

Dec 28, 2023 - GPT for Sheets

Bug fix

We've resolved an issue that was blocking the execution of multiple functions within a single cell when the safe mode option was not enabled.

Dec 27, 2023 - GPT for Sheets

Bug fix

We now default to the Europe/Dublin time zone for date formatting when the system can't retrieve your spreadsheet's time zone, which eliminates errors.

Dec 26, 2023 - GPT for Excel

Bug fix

We've resolved an issue that was preventing users with Japanese characters in their Microsoft account name from proceeding beyond the Sign in with Microsoft screen.

Dec 22, 2023 - GPT for Excel

Improvement

Your OpenAI API key may be valid but not working for different reasons, for example if you are out of OpenAI credits. In this case you will now see a dedicated screen that will help you solve the issue and then retry your API key.

Dec 22, 2023 - GPT for Sheets

Improvement

Setting Max tokens to Auto is now only possible when an OpenAI chat model, such as gpt-3.5-turbo or gpt-4, is selected. Auto being specifically designed for OpenAI chat models, this prevents unnecessary selection with other models.

Bug fix

You can now regenerate formula results or retry errors when a single column or row is selected.

Dec 21, 2023 - GPT for Sheets

Bug fix

In this release, we've fixed an issue where you couldn't clear your OpenAI API key when prompted to do so.

Dec 20, 2023 - GPT for Docs

Bug fix

Previously, if you had really long prompts, the favorite prompt button ⭐ would disappear from Prompt history. Now, no matter how long the prompt is, the favorite prompt button remains visible.

Dec 20, 2023 - GPT for Sheets

Improvement

The Extension menu for GPT for Sheets now includes a new item: Retry errors. This provides a shortcut to open the sidebar, allowing you to manage errors and retry from there when you’re done fixing.

Bug fix

We've fixed an issue where loading indicators were spinning for too long. Now, the loading indicators stop spinning upon action completion, whether it be counting formulas, replacing formulas with their results or regenerating results.

Dec 20, 2023 - GPT for Excel

Announcements

  • The new GPT_VISION function can analyze images and answer questions about them. You can use this function to generate product descriptions or captions for your images.
  • The redesigned sidebar in GPT for Excel now places the most useful buttons at the top, making them easier to access. You can now replace formulas with values, retry errors and pause executions in one click. You can also regenerate your results directly from the Settings screen after tweaking the parameters.

Bug fix

The authentication error in the GPT for Excel sidebar confirmation window has been resolved. Clicking Sign in with Microsoft now triggers a smooth sign-in process through silent authentication.

Dec 18, 2023 - GPT for Sheets

Bug fix

We've fixed an issue where GPT functions couldn't execute past column AZ when using GPT-4 safe mode.

Dec 15, 2023 - GPT for Sheets

Announcement

GPT-4 safe mode is now available for all users, offering reduced timeouts and preventing loss of data and unexpected costs. It's a great option if you are using GPT-4 or GPT-4-turbo models.

Dec 15, 2023 - GPT for Excel

Announcement

This release expands the range of OpenAI models available from GPT for Excel:

  • gpt-4 and gpt-4-turbo models are now available without an API key.
  • The following models are now supported with an API key:
    • gpt-3.5-turbo-0301
    • gpt-3.5-turbo-0613
    • gpt-3.5-turbo-16k
    • gpt-4-0314
    • gpt-4-0613
    • gpt-4-32k
    • gpt-4-32k-0314
    • gpt-4-32k-0613

Note: gpt-4-32k models are displayed only if you have access through your OpenAI key.

Dec 14, 2023 - GPT for Excel

Bug fix

GPT for Excel now allows restarting the Microsoft sign-in process if you close the sign-in window, preventing endless loading.

Dec 14, 2023 - GPT for Word

Announcement

gpt-4, and gpt-4-turbo (gpt-4-1106-preview) models are now also supported, alongside the gpt-3.5-turbo model (gpt-3.5-turbo-0613). You can switch between models from the model dropdown switcher.

Dec 13, 2023 - GPT for Sheets

Bug fixes

We've resolved the following issues, which could affect spreadsheets using non-English language settings:

  • Clicking the Retry Errors button now triggers instant spinning, which eliminates the risk of multiple clicks.
  • Retrying errors previously disrupted some loading functions. Now, these functions operate smoothly.
  • The count of active functions accurately reflects both successful and loading functions.

Dec 11, 2023 - GPT for Excel

Announcement

Azure gpt-4 and Azure gpt-4-turbo and Azure gpt-3.5-turbo models are now supported by GPT for Excel without an API key. Learn more about Azure AI.

Improvement

The model switcher dropdown that now clearly shows which models need an API key and which do not.

Dec 11, 2023 - GPT for Sheets

Improvements

  • This release includes specific instructions for addressing NAME errors in spreadsheets. Learn more.
  • We've updated the system to refresh function counts before executing retries, ensuring the displayed numbers are always accurate and consistent. Also, the counter label is updated from "successful" to "active" for clarity.

Dec 6, 2023 - GPT for Sheets

Improvements

  • The maximum number of requests per minute (RPM) in GPT-4 safe mode has doubled, increasing from 60 to 120.
  • If you hit OpenAI token per day limit (TPD), an error message informs you about the number of remaining tokens for the day. This helps you manage your usage more effectively.

Bug fixes

  • The issue with the Replace formulas dropdown not responding to trackpads or long presses has been resolved.
  • In this release, we've corrected the token counter for the gpt-3.5-turbo-1106 model. Previously, it was showing an incorrect model limit.

Dec 6, 2023 - GPT for Excel

Announcement

  • The GPT_MATCH function is now available in GPT for Excel. It enables you to match the values of two columns by similarity. You can use it to match different spellings or even categories that are semantically related. This function uses the text-ada-002-embeddings model which is extremely fast and very cheap.

Dec 5, 2023 - GPT for Docs

Bug fix

The value for Max input tokens now accurately reflects the full 128K token context window capacity of gpt-4-turbo (gpt-4-1106-preview).

Dec 5, 2023 - GPT for Sheets

Improvement

The performance of GPT-4 safe mode has been improved, now delivering up to 60 requests per minute (RPM).

Bug fix

GPT functions are no longer stuck on “GPT Loading” during parallel executions across multiple spreadsheets when GPT-4 safe mode is enabled.

Dec 5, 2023 - GPT for Excel

Announcement

We've introduced the Tokens counter in the GPT for Excel sidebar. With this tool, you can get the number of tokens and input cost of the selected cell or range for the current model.

Improvement

If you hit OpenAI token per day limit (TPD), an error message informs you about the number of remaining tokens for the day. This helps you manage your usage more effectively.

Dec 4, 2023 - GPT for Sheets

Announcements

  • The redesigned sidebar in GPT for Sheets now places the most useful buttons at the top, making them easier to access. You can now replace formulas with values, retry errors and pause executions in one click. You can also regenerate your results directly from the Settings screen after tweaking the parameters.

Dec 1, 2023 - GPT for Sheets

Improvement

With this update, enabling GPT-4 safe mode automatically sets, by default, the Max tokens settings to Auto to make optimal use of your Tokens per minute quota. You can still specify a Fixed value for the Max tokens if needed.

Nov 30, 2023 - GPT for Work

Improvement

The GPT for Work extensions now display a clearer error message with instructions if a problem occurs with an OpenAI payment.

Nov 30, 2023 - GPT for Sheets and Word

Improvement

With this release, you can add your OpenAI organization ID in the GPT for Sheets and GPT for Word sidebars. If you are part of multiple organizations, it ensures that you get billed on the correct account.

Nov 29, 2023 - GPT for Sheets

Bug fix

We resolved an issue with GPT_VISION not functioning when GPT-4 Safe mode was enabled and Max tokens setting was set to Auto.

Nov 29, 2023 - GPT for Excel

Bug fix

This update ensures that if GPT functions get stuck in a #BUSY state, the GPT add-in sidebar now automatically opens, which resolves the issue.

Nov 24, 2023 - GPT for Excel

Announcement

OpenAI models GPT-4 and GPT-4 Turbo are now supported in GPT for Excel. Set up your own OpenAI API key in GPT for Excel to access these models and benefit from their broader general knowledge and advanced reasoning capabilities.

Improvement

GPT formula caching now ignores sidebar settings. If the formula is unchanged, results are consistently retrieved from the cache.

Nov 23, 2023 - GPT for Sheets

Improvements

  • Executions can now reschedule for a longer period of time. Previously, token expiration caused execution to fail after one hour.
  • The maximum number of requests per minute allowed when using GPT-4 safe mode has been increased from 30 to 60.
  • Truncated formula results are now prefixed with a message to help you identify the issue and fix it by modifying the value of the Max tokens setting.

Nov 21, 2023 - GPT for Excel

Bug fix

We have fixed an error message that was displayed when hitting the tokens per minute rate limit. Previously, the message displayed the wrong model. This fix will help you better understand which model is causing the rate limit issue and allow you to take appropriate action.

Nov 21, 2023 - GPT for Excel Word

Announcement

We are excited to announce that we have renamed the add-in previously known as ChatGPT for Excel Word to GPT for Excel Word. This change was made to ensure consistency with our other extensions.

You can now find it in Microsoft AppSource under the name GPT for Excel Word.

Nov 17th, 2023 - GPT for Word

Bug fix

In this release, we fixed an issue where the number of tokens for selected content was incorrectly estimated. It should have been zero, but was showing as equal to the number of tokens in your message. This was happening when the selection and the message were both large. Please note that this was only an estimation error and did not affect the actual cost of token usage.

Nov 16th, 2023 - GPT for Sheets

Announcements

  • The new GPT_VISION function can analyze images and answer questions about them. You can use this function to generate product descriptions or captions for your images.
  • gpt-3.5-turbo-instruct is now available in the GPT for Sheets add-on. This model is specially designed to generate outputs that closely align with your instructions, ensuring more precise and relevant results.

Bug fix

When using GPT_EXTRACT, the output will no longer be split into multiple cells when the reference is a single cell.

Nov 16th, 2023 - GPT for Sheets and Docs

Bug fix

Fine-tuned versions of the following models are now supported:

  • gpt-3.5-turbo
  • babbage-002
  • davinci-002

Nov 15th, 2023 - GPT for Sheets

Announcement

We are happy to announce that the Azure gpt-3.5-turbo model is now available, presenting a fast and efficient alternative to OpenAI's version. Also, you might prefer Azure OpenAI terms of service. Learn more about Azure AI.

💡
  • This feature is in the process of being rolled out and is not yet available for all users.
  • The model provides faster response times compared to the OpenAI gpt-3.5-turbo, though it comes at a higher cost.
  • Using your own Azure API key to lower expenses is not yet possible.
  • Nov 14th, 2023 - GPT for Word

    Improvement

    As part of our enhancements for MacOS compatibility, we've improved the copying and pasting from the sidebar chat to accurately preserve line breaks.

    Bug fix

    This update resolves an issue where the first few characters of the responses were occasionally missing.

    Nov 13th, 2023 - GPT for Sheets

    Announcement

    We've introduced a Tokens counter in the GPT for Sheets sidebar. With this tool, you can get the number of tokens and the associated cost based on your current model by selecting one or more cells.

    💡
  • This feature is in the process of being rolled out and is not yet available for all users.
  • This tool is not yet available for the newly supported models.
  • Improvement

    Your OpenAI API key may be valid but not working for different reasons, for example if you are out of OpenAI credits. In this case you will now see a dedicated screen that will help you solve the issue and then retry your API key.

    Nov 10th, 2023 - GPT for Sheets and Docs

    Announcement

    The latest OpenAI model, GPT-4 Turbo, along with the updated version of GPT-3.5 Turbo (gpt-3.5-turbo-1106), are now accessible in GPT for Sheets and GPT for Docs.

    • GPT-4 Turbo is OpenAI’s latest generation model. It’s more capable, has an updated knowledge cutoff of April 2023 and introduces a 128k context window (the equivalent of 300 pages of text in a single prompt). The model is also 3X cheaper for input tokens and 2X cheaper for output tokens compared to the original GPT-4 model. The maximum number of output tokens for this model is 4096.
    • Updated version of GPT-3.5 Turbo now supports a 16K context window by default and improved instruction following. GPT-3.5 Turbo models are faster than GPT-4 and GPT-4 Turbo and return up to 4096 output tokens.

    Nov 10th, 2023 - GPT for Sheets

    Improvement

    We've resolved an issue with the Auto-replace formulas option. Previously, it did not appear disabled when GPT-4 safe mode was turned off. Now, the option correctly reflects the status of GPT-4 safe mode, which reduces confusion.

    Bug fix

    The issue with GPT-4 safe mode activation not consistently saving with your spreadsheet has been resolved. This ensures your settings remain consistent across your work.

    Nov 8th, 2023 - ChatGPT for Word

    Improvement

    ChatGPT for Word now informs you when OpenAI servers are overloaded.

    Nov 8th, 2023 - GPT for Work

    Announcement

    The latest OpenAI model GPT-4 Turbo (128k) is already available in our comparison tools:

    We have also added gpt-3.5-turbo-1106 (updated version of GPT-3.5 Turbo) to the response time tracker and updated all pricing information to reflect the latest announcements.

    Nov 8th, 2023 - ChatGPT for Excel

    Announcements

    • The pricing for ChatGPT for Excel has changed. The price for 1 execution will now depend on its input and output size measured in tokens:
      • Small executions will be cheaper
      • Large executions will be more expensive
    • Save 50% by setting up your own OpenAI API key!

        If you use your own OpenAI API key in ChatGPT for Excel, we will now bill you the same amount as OpenAI bills you. For example:

      • You spend $10 on OpenAI
      • We bill you $10
      • Your total cost is $20

    Nov 6th, 2023 - GPT for Sheets

    Improvement

    In this release, the value of Max tokens can be set automatically for you, when you are using a GPT-4 model with the GPT-4 safe mode enabled. With the Auto option, Max tokens is automatically set according to the number of tokens in your input:

    Max tokens = model token limit - input tokens

    This allows you to benefit from the full token limit of GPT-4 without setting the value of Max tokens manually.

    November 2nd, 2023 - ChatGPT for Word

    Improvement

    When launching ChatGPT for Word for the first time, you are now presented with a welcome screen and a video tutorial:

    November 2nd, 2023 - GPT for Sheets

    Improvement

    GPT for Sheets now detects and ignores formulas that reference cells with errors also when GPT-4 safe mode is enabled. This means you won't face any unexpected delays or extra costs, as these issues are now identified upfront.

    October 30th, 2023 - GPT for Sheets and Docs

    Improvements

    In this release, we've made the following changes:

    • GPT for Sheets settings are now saved at spreadsheet level. This means that you can configure distinct settings for each spreadsheet. When you open a new spreadsheet, it automatically uses your most recently changed settings. But, any changes you make to the settings after that will only apply to that specific spreadsheet.
    • Executing a function with an Anthropic model without an API key now displays a clear error message with instructions.

    October 27th, 2023 - GPT for Sheets

    Improvement

    The maximum value for Max tokens is now set 200 tokens below the model token limit. For example, gpt-3.5-turbo has a capacity of 4096 tokens, so you can only set Max tokens up to 3896. This provides room for your input and prevents hitting the max token limit due to an excessively high Max tokens setting.

    October 25th, 2023 - GPT for Sheets

    Bug fix

    The Generate formula and Explain formula result fields no longer have a content overflow issue. You can now use the scroll bar to view long answers.

    October 24th, 2023 - GPT for Sheets

    Improvement

    We improved the performance of GPT functions, reducing the risk of "Exceeded maximum execution time" errors.

    October 23rd, 2023 - GPT for Work

    Announcement

    We have added an LLM comparator on our website. This tool allows you to compare the most popular Generative AI LLM APIs based on tokens limit, price, rate limits, latency, language, and training data cutoff.

    Improvement

    Error messages for Max tokens now display the maximum value for this setting in your current setup. These messages also recommend a different model if you need a higher model limit. This update makes it easier for you to locate and adjust the setting.

    October 19th, 2023 - ChatGPT for Word

    Improvement

    The new release saves chat history in your Word document. This means you can now retrieve your chat history even after reloading or closing the add-in or your Word document.

    October 19th, 2023 - ChatGPT for Excel

    Improvement

    In this release, we've made the following changes:

    • Credits are now instantly displayed after purchasing a pack. There is no need to reload the add-in.
    • The VAT ID field is now validated. Invalid input is spotted, making it easier for you to identify and correct errors.

    October 17th, 2023 - GPT for Sheets and Docs

    Improvement

    This release includes clearer messages for all OpenAI errors, making it easier for you to troubleshoot any issue you encounter.

    October 10th, 2023 - GPT for Sheets

    Improvement

    Now, if the add-on encounters a rate limit error during API key validation, the system won't display an "Invalid API key" message. This change ensures that you only see this message if there's an actual authentication error.

    October 9th, 2023 - GPT for Sheets

    Announcement

    GPT for Sheets launched in January, and quickly became a time-saving tool for early users. We've enhanced it significantly and are now moving to a paid model.

    If you use your own OpenAI API key in GPT for Sheets, we will now bill you the same amount as OpenAI bills you.

    For example:

    • You spend $10 on OpenAI
    • We bill you $10
    • Your total cost is $20

    In the coming weeks, you can expect major improvements:

    • Much fewer timeouts and auto-refresh problems
    • Auto-replace formulas and other big UX improvements

    Note that this transition to a paid model is being rolled out progressively.

    September 30th, 2023 - GPT in Excel

    Announcement

    We've renamed GPT in Excel to ChatGPT for Excel Word. You can now find it in Microsoft AppSource under the name ChatGPT for Excel Word. After installation, the add-in unlocks the power of ChatGPT in Microsoft Word as well.

    September 30th, 2023 - ChatGPT for Word

    Announcement

    We are thrilled to announce that we released a new product: ChatGPT for Word is now available for all Microsoft users! 🎉

    Free to use while in beta, you need to set your OpenAI API key and will pay the API cost directly to OpenAI.

    With ChatGPT for Word, you can significantly enhance your Microsoft Word experience. Not only does it allow you to write, edit, and translate with greater efficiency, but it also leverages the content of your Word document for in-context results.

    Features:

    • Chat with the chatbot within the add-in
    • Copy responses, insert them into your document, or replace some document content with them in a click
    • Select content in your document to use it as context for the next response

    Using ChatGPT for Word will save you a lot of time by allowing you to:

    • Work on pieces of a long document
    • Structure your prompts in Word
    • Avoid constant copy/pasting in ChatGPT
    • Save ChatGPT answers in Microsoft Word for easier retrieval
    • Benefit from all the Microsoft Word editor tools, including real-time co-edition and change tracking

    September 21st, 2023 - GPT for Sheets

    Bug fix

    We've resolved a problem with the cache not functioning properly when switched off, then on again.

    September 20th, 2023 - GPT for Sheets

    Bug fix

    We've fixed an issue where the display of the creativity preset levels was delayed or incorrect.

    September 18th, 2023 - GPT for Sheets

    Bug fix

    In this release, we solved the following issues:

    • GPT_EXTRACT formulas now result in empty cells when nothing is extracted, instead of showing #REF errors.
    • You'll see a nicer error message if you attempt to enable GPT functions on a spreadsheet you did not create.

    September 14th, 2023 - GPT in Excel

    Bug fix

    We have fixed a bug that could cause the add-in sidebar to crash when you were editing cells while GPT in Excel executed tasks.

    September 14th, 2023 - GPT for Sheets

    Announcement

    We've introduced new model settings:

    • Custom instructions: Set specific preferences and roles for the model.
    • Top P: Control creativity by limiting the model to the most likely words or phrases with values like 0.1 for more focused results.
    • Frequency and Presence penalties: Reduce repetition with these OpenAI-specific settings.

    September 14th, 2023 - GPT for Sheets and Docs

    Improvement

    The current model is now always included in the model status dropdown list at the top of the sidebar.

    Bug fix

    This release fixes an issue where the absence of the Anthropic version could lead to errors with Claude models.

    September 12th, 2023 - GPT for Sheets

    Improvement

    We've modified GPT formula cache behavior to improve consistency and reduce unnecessary recalculations:

    • When caching is enabled in your spreadsheet, formula refresh is now restricted to error cases.
    • Caching is now formula-centric, and ignores sidebar settings. If the formula is unchanged, results are consistently retrieved from the cache.
    💡
    Please note that when using a value from the cache, the formula result might therefore not reflect your latest sidebar settings.

    September 6th, 2023 - GPT for Docs

    Improvement

    This release includes the following improvements:

    • Model settings are now saved within the add-on, ensuring they are available when you reopen your document or use the add-on in a different document.
    • We have renamed and improved the ability to attach custom instructions to prompts. Previously called Set behavior and configured per prompt, this feature is now named Custom instructions and can be found in the Model settings section. With this update, custom instructions are set at the model level and are now saved within the add-on along all other model settings.
    • The Model list now shows only the models that are available to your currently set API keys.
    • When you select a Claude model, the default value for Max response tokens is now set to 10000. This change is designed to maximize the benefits of Anthropic models' larger token capacity when transitioning from a model with a smaller capacity.
    • text-ada-001, text-babbage-001 and text-curie-001 models, which will soon be retired by OpenAI, are demoted in GPT for Docs.

    September 6th, 2023 - GPT for Sheets/GPT in Excel

    Announcement

    We have published a new template containing a comprehensive set of examples for major use cases. These examples are bundled into a spreadsheet that you can copy for Google Sheet

    and into a downloadable workbook for Excel. Experience hands-on learning by copying and pasting the GPT formulas!

    August 31st, 2023 - GPT in Excel

    Improvements

    We have added the following functions to GPT in Excel:

    • GPT_SPLIT: Splits text semantically, e.g. by section, paragraph, customer. This function outputs all splits vertically in a column.
    • GPT_HSPLIT: Splits text semantically, e.g. by section, paragraph, customer. This function outputs all splits horizontally in a row.
    • GPT_EDIT: Applies edit instructions to the given text. The default task is to fix grammar and spelling.

    We have also removed GPT_CONVERT from the list of available functions, because it was a duplicate of GPT_FORMAT. GPT_CONVERT remains usable by manually typing the function.

    Bug fix

    GPT_TAG and GPT_CLASSIFY now preserve the letter case of the tags and categories provided as input.

    August 22nd, 2023 - GPT for Sheets

    Improvement

    We have removed duplicates and unused functions from the list of available functions:

    • GPT_MAP: was identical to GPT_MATCH
    • GPT_CONVERT: was identical to GPT_FORMAT
    • GPT_CODE: was removed due to very low usage

    GPT_MAP and GPT_CONVERT remain usable by manually typing the functions.

    August 21st, 2023 - GPT for Sheets

    Bug fix

    This release restores compatibility for formulas containing the deprecated max_tokens parameter. These old formulas now execute successfully, however any value specified for  max_tokens will be ignored.

    To configure this parameter, it is now recommended to use the sidebar setting Max response size.

    August 18th, 2023 - GPT for Sheets

    Bug fix

    GPT_TAG no longer returns an error if the tag list is not specified through the optional tags parameter. If the parameter is left blank, relevant tags are automatically suggested.

    August 18th, 2023 - GPT for Sheets and Docs

    Bug fix

    The model list now shows only the models that are available to your currently set API keys.

    August 7th, 2023 - GPT for Sheets

    Bug fix

    GPT for Sheets now takes into account locale settings for all countries in sidebar examples.

    August 7th, 2023 - GPT for Docs

    Improvement

    [insert] tags now work in documents containing tables with rows having varying column counts.

    August 4th, 2023 - GPT for Docs

    Announcement

    Claude models are now available in GPT for Docs!

    Enter an Anthropic key in the GPT for Docs add-on and start using claude-instant-1 and claude-2 to benefit from:

    • Up to 100k tokens
    • Performance on par with OpenAI models
    • Affordable pricing: nearly 5 times cheaper than the 32K-context version of GPT-4

    Price for 1 million tokens:

    Claude 2
    GPT-4 32k
    Prompt
    $11.02
    $60
    Completion
    $32.68
    $120

    Improvements

    You can now request a response in table format by specifying it in the prompt.

    We have also significantly improved response insertion, including in the following situations:

    • Inline
    • Inside tables
    • Inside lists
    • At the end of a document
    • After a text selection, even in a table

    August 2nd, 2023 - GPT in Excel

    Bug fix

    We fixed a bug where editing a formula would block all GPT executions.

    August 1st, 2023 - GPT in Excel

    Improvement

    When launching GPT in Excel for the first time, you are now presented with a set of examples to help you understand what you can do with it.

    Click on Try this example, to import the full example into a cell and see it in action!

    Bug fix

    In this version, the GPT formula controls options now works reliably even on a large number of selected cells.

    July 28th, 2023 - GPT for Sheets

    Improvement

    All the examples in the GPT functions list now automatically adjust the separator to your spreadsheet’s locale settings.

    July 27th, 2023 - GPT in Excel

    Bug fix

    We have fixed a bug that prevented use of GPT functions when a workbook containing GPT formulas was shared.

    July 26th, 2023 - GPT in Excel

    Announcement

    We're excited to share that our free trial now offers 300 credits, allowing you to perform 300 free executions in GPT in Excel.

    July 25th, 2023 - GPT in Excel

    Bug fix

    GPT_TAG and GPT_CLASSIFY will not hallucinate tags or categories anymore. They will return results from the provided list of categories or tags, if any.

    July 25th, 2023 - GPT for Sheets

    Improvements

    This release comes with the following improvements:

    • text-ada-001, text-babbage-001 and text-curie-001 models, which will soon be retired by OpenAI, are demoted in GPT for Sheets. You can still find them at the bottom of the Model menu.
    • Longer responses allowed for Anthropic models: up to 100k tokens, around 75000 words (English)

    July 18th, 2023 - GPT in Excel

    Announcement

    We just lowered our prices: you can now buy 5x more credits for the same price as before!

    July 18th, 2023 - GPT for Sheets

    Improvement

    GPT_EXTRACT now outputs to a single cell when the value for the parameter to_extract is a single cell or a string

    July 14th, 2023 - GPT for Sheets

    Improvement

    The model list now only displays the models that are available to your API keys.

    July 14th, 2023 - GPT for Docs

    Bug fix

    We have fixed an issue that prevented GPT for Docs from properly saving API keys.

    July 13th, 2023 - GPT in Excel

    Announcement

    We just released more ways to configure settings and control your GPT formulas::

    Discover these features, along with usage tips, in the brand new version of GPT in Excel sidebar!

    July 12th, 2023 - GPT for Sheets

    Announcement

    You can now use Claude models from Anthropic in GPT for Sheets!

    Simply enter an Anthropic key in the GPT for Sheets add-on and start using claude-instant-1 or claude-2 to benefit from:

    • Up to 100k tokens
    • Performance on par with OpenAI models
    • Affordable pricing: nearly 5 times cheaper than the 32K-context version of GPT-4

    Price for 1 million tokens:

    Claude 2
    GPT-4 32k
    Prompt
    $11.02
    $60
    Completion
    $32.68
    $120

    Bug fixes

    • The formula replacement tool now displays the number of formulas replaced in near real time, updating the count every 7 seconds during processing.
    • If GPT_EXTRACT cannot find the value to extract, it will return blank instead of a REF error.

    June 29th, 2023 - GPT in Excel

    Improvement

    This update includes new formula examples on GPT in Excel home page and a refreshed design.

    Big fix

    GPT_CLASSIFY doesn’t hallucinate categories anymore and only returns results from the provided list of categories. If no category matches your input text, the function returns #N/A.

    June 28th, 2023 - GPT in Excel

    Improvement

    The execution rate limit has been reduced from 10 per second to 3 per second. This prevents reaching OpenAI rate limits and avoids errors.

    June 27th, 2023 - GPT in Excel

    Announcement

    The following functions were added to the GPT in Excel function family:

    • GPT_CLASSIFY classifies a given text into a single category.
    • GPT_CONVERT converts from one format to another. For instance json to table, or xml to json.
    • GPT_EXTRACT extracts data (like email addresses or company names) from a text.
    • GPT_FILL magically fills or cleans a range from a few examples.
    • GPT_FORMAT formats dates, currencies, addresses, names, etc. Fixes capitalization. And so much more.
    • GPT_SUMMARIZE summarizes text according to a given format (three sentences by default).
    • GPT_TABLE is like GPT, but outputs the results in a table. Very practical when the output is a table.
    • GPT_TAG applies user-defined tags to text or automatically suggests relevant tags if none are specified.
    • GPT_TRANSLATE translates text from one language into another. Works better if you specify the source language.

    June 21st, 2023 - GPT for Docs

    Improvement

    Dutch and Italian are now available as prompt languages.

    June 21st, 2023 - GPT for Work

    Improvements

    With the latest update of our GPT for Work website, our pricing calculator and LLM response time tracker benefit from a redesigned user interface and integrate additional models.

    June 20th, 2023 - GPT in Excel

    Announcement

    We have simplified the pricing for GPT in Excel. Now, 1 credit = 1 execution. This is a change from the previous system where 1 to 8 credits could be used per execution.

    June 19th, 2023 - GPT for Sheets

    Improvement

    You can no longer input out-of-range values in Creativity and Max tokens fields.

    June 16th, 2023 - GPT in Excel

    Bug fixes

    This release resolves an issue with the cache not functioning when the sidebar is closed. Now, the cache operates effectively regardless of the sidebar status.

    June 15th, 2023 - GPT in Excel

    Improvements

    This version includes the following improvements:

    • Gpt-3.5-turbo-0613: GPT in Excel now operates with this newly released model from OpenAI.
    • Reduced latency due to improved performance of the Microsoft authenticator.
    • Clearer display of your remaining credits.

    June 15th, 2023 - GPT for Sheets and Docs

    Improvement

    GPT for Sheets and Docs now supports the gpt-3.5-turbo-16k model from OpenAI. This lets you use context windows up to 16,000 tokens, a big step up from the previous limit of 4,096 tokens.

    June 12th, 2023 - GPT in Excel

    Announcement

    We are excited to announce that our GPT in Excel add-in is transitioning to a paid model, effective immediately. You don't need to create and set up your own OpenAI API key anymore. Instead, buy credit packs that last 90 days. Each execution of GPT functions then costs credits.

    More functions are also coming soon, stay tuned!

    June 12th, 2023 - GPT for Sheets and Docs

    Improvement

    gpt-3.5-turbo is now the default model in GPT for Sheets and Docs.

    The response time of gpt-3.5-turbo has significantly decreased which makes it a better trade-off between reliability, quality, and cost than text-davinci-003.

    June 1st, 2023 - GPT for Sheets

    Improvement

    The Replace GPT formulas with result feature now handles large sheets with 50,000 cells or more to replace.

    May 18th, 2023 - GPT for Sheets

    Improvement

    The latest version of the GPT for Sheets add-on brought several improvements:

    • Error messages are more specific and provide clearer guidance

    Bug fix

    The Replace GPT formulas with results feature now disregards cells containing GPT formulas that are in error, loading, or paused states. This ensures that only valid formulas are processed.

    May 12th, 2023 - GPT for Sheets

    Improvement

    GPT_MAP can only handle a maximum of 1300 rows due to Google's limitations. To aid in this, we've included a clear error message. If you encounter this message, you can resolve the issue by executing GPT_MAP in smaller batches to stay within the limit.

    May 12th, 2023 - GPT for Docs

    Announcement

    We've added the gpt-4-0314 model to our GPT for Docs extension!

    May 10th, 2023 - GPT for Sheets

    Improvements

    In this new version of GPT for Sheets:

    • We now only retrieve spreadsheet information when the GPT formulas controls section is open. This reduces unnecessary data usage.

    Bug fix

    We've updated the URL for sidebar assets in GPT for Sheets to fix blank sidebar issues.

    May 3rd, 2023 - GPT for Sheets

    Improvement

    We just launched a new version of the GPT for Sheets add-on that brings back the Set API key option in the Extensions menu.

    April 27th, 2023 - GPT for Sheets and Docs

    Improvement

    OpenAI has reduced the RPM (Requests Per Minute) limit for free trial users from 20 to 3. This change could lead to errors. We have identified this specific error and updated the error message to recommend an upgrade.

    April 19th, 2023 - GPT for Sheets

    Improvements

    The sidebar now opens automatically when you install the add-on.

    April 12th, 2023 - GPT for Sheets

    Announcement

    • We have added the following functions to GPT for Sheets:
      • GPT_SPLIT: Splits text semantically, e.g. by section, paragraph, customer. This function outputs all splits vertically in a column.
      • GPT_HSPLIT: Splits text semantically, e.g. by section, paragraph, customer. This function outputs all splits horizontally in a row.

    Improvements

    • You can now choose a model directly from the Selected Model Status list, enabling you to view the current response times of the models to guide your choice.
    • To ensure optimal performance, we've updated the default model for new users to text-davinci-003, following observed latency issues with the gpt-3.5-turbo model.
    • We've released a new version of the following functions:
      • GPT_TRANSLATE: we've introduced an [instructions] parameter for you to provide specific guidelines for your translations.
      • GPT_TAG and GPT_CLASSIFY: We also added an [example] parameter for you to provide a table of examples with two columns: the first column should contain the inputs and the second column should contain the outputs.

    April 12th, 2023 - GPT for Docs

    Improvements

    With this release, you can now:

    • Mark a prompt as favorite to save it permanently, ensuring it remains accessible even after you close the document or the add-on.
    • Select the language in which you write your prompts and custom instructions to optimize the model's response.

    Bug fix

    We solved an issue that was causing quotes to appear in the output.

    March 29th, 2023 - GPT for Work

    Announcement

    A new page is now available on the GPT for Work website allowing you to track OpenAI and Azure OpenAI APIs response times.

    March 29th, 2023 - GPT for Sheets

    Bug fix

    The GPT_FILL function now neatly displays the output in a single cell when provided with a single-cell input.

    March 15th, 2023 - GPT for Sheets

    Announcement

    We are pleased to announce that GPT for Sheets now supports GPT-4, just 24 hours after OpenAI's official release of this model. Enjoy the latest advancements in AI within your Google Sheets environment!

    Improvement

    The GPT_MAP function now includes the top_k parameter. This parameter lets you specify the number of matching values to return per search key. By default, it returns only the best match.

    March 13th, 2023 - GPT for Sheets

    Announcement

    We've introduced a new template showcasing how to use GPT functions in Google Sheets. This includes basic copywriting, data categorization, email address extraction, and more within your Google spreadsheet. Open the template and click Use template to duplicate it and test the GPT functions.

    March 11th, 2023 - Lots of improvements

    • GPT_TABLE and GPT_EXTRACT now work better with table headers
    • GPT_CLASSIFY can now use the text-embedding-ada-002 model for classification, which will prevent GPT from inventing unwanted categories. To use it, simply specify the model in the function parameter
    • GPT_TAG has a new top_k parameter which allows you to control the maximum number of tags to be returned
    • Quotation marks are better handled so that they are not trimmed when they’re wanted
    • Errors of authorization linked to multiple account should be better handled

    March 6th, 2023 - Small improvements

    We’ve made improvements to GPT_FILL, GPT_TABLE and GPT_EXTRACT

    March 2nd, 2023 - ChatGPT turbo, baby!

    OpenAI released the new chatgpt gpt-3.5-turbo model last night, and it is now the default model in in all functions of GPT for Sheets and Docs. Enjoy 10x cheaper costs, faster and better quality responses.

    We turbo released this, so if it breaks anything, (1) we’re sorry and (2) please let us know here

    Other improvements:

    • Specifying tags in GPT_TAG is now optional: GPT_TAG will come up with tags on its own
    • GPT_TAG and GPT_CLASSIFY output in lowercase if categories are lowercase
    • We now automatically detect fine-tuned model most frequent separators
    • A few other details that make the overall experience better

    February 24th, 2023 - Map values with GPT_MAP

    New functions:

    • GPT_MAP which enables you to map the values of two columns to find the best matches. You can use it to map different spellings or even categories that are semantically related. This function uses the text-ada-002-embeddings model which is extremely fast and very cheap
    • GPT_TREE which is more of an experimental function to generate trees of content in your spreadsheet.

    We’ve also added a GTP function for those who find the letter T faster than the letter P! 😊

    Fine-tuned models:

    You can now use your fine-tuned models in GPT for Sheets! Simply specify your model in the model parameter of your GPT function.

    We will automatically recognize or add the stop sequence of your prompt.

    Improvements:

    • Datetimes are now better handled. (the devil really is in the details)
    • We now better handle incorrect values in all parameters
    • GPT_CONVERT now works better
    • The default max_tokens parameter has been increased to 500 in order to avoid to many cut responses

    February 20th, 2023 - Real numbers and dates

    The devil is in the details!

    ChatGPT outputs pure text by default. When this text contains numbers or dates, we want them as numbers or date objects in our spreadsheets in order to be able to operate on them.

    GPT for Sheets now correctly recognises numbers and dates before writing them to your spreadsheet. This makes it much more usable to work with tables of data.

    February 14th, 2023 - Improved parsing

    We have improved parsing of input in the prompts sent to OpenAI which will result in better quality output.

    We have also improved our preset prompts in GPT for Docs for better output quality.

    February 8th, 2023 - Added examples

    We’ve added an examples template spreadsheet directly accessible from the add-on menu.

    Replacing formulas now works on all GPT functions.

    February 6th, 2023 - Improved error messages

    We’ve made error messages easier to understand which should help you understand what to do when you input a parameter incorrectly, hit a rate limit, expire your free trial or when OpenAI servers are unavailable.

    January 31th, 2023 - New preset functions!

    GPT for Sheets

    • Woohoo! We just released a bunch of new functions that will make it much easier to make some frequent operations without writing any prompt:
      • GPT_TAG to apply tags. Simple and easy
      • GPT_CODE to generate code in your spreadsheet. Yes some people want to do this!
      • GPT_EDIT to edit text. By default it fixes spelling and grammar
      • GPT_EXTRACT to extract things like email addresses or companies from a paragraph. Works remarkably well
      • GPT_CONVERT to convert cells and ranges from one format to another: html, json, json-ld, nl-json, tables, csv, markdown. Incredibly powerful
      • GPT_SUMMARIZE to quickly summarize some text
      • GPT_TRANSLATE to quickly translate some text
      • GPT_CLASSIFY to classify into a single category (different from GPT_TAG where multiple tags can apply)
      • and finally GPT_CREATE_PROMPT which will help you create a prompt from many different cells and ranges in your spreadsheet by just listing them one by one as arguments
    • Fix a bug when the value parameter of GPT_LIST was empty
    • Improvements to prompt and response parsing that make our functions more robust
    • Changed the default cache setting to disabled for new users, and automatically enable it after 100 executions

    January 26th, 2023

    GPT for Sheets

    • GPT_LIST now supports a range as a prompt. This makes it much easier to give write a good, specific, and detailed prompt.
    • Replace formula with values now works on GPT_FILL
    • We now check if you’re the owner of the spreadsheet before you can set an API key
    • We have switched the order of parameters in all functions: max_tokens now comes before model, since:
      • tweaking the max_tokens parameter is actually useful and needs to be done frequently for longer-form content
      • there is very little reason to use another model than the default which is text-davinci-003.

    GPT for Docs

    • OpenAI responses are correctly split in paragraphs when relevant
    • New tooltips have been added to the interface

    January 24th, 2023

    GPT for Sheets

    The GPT function can now take range as prompt. This is a huge improvement, and makes it much easier to give write a good, specific, and detailed prompt.

    January 20th, 2023

    GPT for Sheets

    We’ve released a new magical function: GPT_FILL ! This one is really incredible to see in action. All you need to do is feed it some example rows and it will fill a range intelligently. Super useful for cleaning lists, where the right prompt can be difficult to put together.

    First release of GPT for Docs!

    • You can now use the add-on from Google Docs, which is much more suitable for long-form content
    • You can type your prompt directly in the document or in the prompt box

    January 18th, 2023

    GPT for Sheets

    This update brings two cost management features:

    • Replacing formulas with values, from the Extensions menu: once you’re satisfied with the answers of GPT, you should replace the formulas with values so that they never get recalculated.
    • Cache management: we now cache answers of the same prompt by default for a duration of roughly 6 hours. This means that every answer you get will be reused if you ask the same question again or the formula gets recalculated will help lower your OpenAI costs. You can of course disable the cache if you prefer to explore variations rapidly and do not want to reuse answers. The cache is per spreadsheet.

    January 12th, 2023

    GPT for Sheets

    We’ve released a new function: GPT_LIST !

    It makes it as simple as pie to get one item per cell when you want multiple items at once, like “5 taglines for an ice-cream shop”.

    January 7th, 2023

    GPT for Sheets first release!

    It all started with a simple GPT function. The little function that could.

    Bug fix

    The Replace GPT formulas with results feature now disregards cells containing GPT formulas that are in error, loading, or paused states. This ensures that only valid formulas are processed.