GPT for Excel
Bring ChatGPT and other AIs directly into Microsoft Excel to automate bulk text processing and assist you with formulas
Generate or rewrite content at scale (listings, ads, social posts)
Translate in multiple languages in bulk
Analyze free-form feedback (reviews, surveys)
Bulk review (quality check, score, revise)
Prepare, enrich, and segment unstructured data in a few clicks
Get help on spreadsheet formulas
GPT functions: Prompt directly
from cells
- Reference cells and ranges in your prompts.
- Run a prompt in bulk by simply dragging a formula over rows or columns.
- Ideal for custom tasks where detailed control is more important than processing large volumes at once.
Use dynamic cell and range references in your prompts
Reference cells and ranges in your prompts to dynamically pull data from specific cells or ranges in your spreadsheet. This means your prompt can automatically adapt based on the content of those cells, allowing you to work with changing or live data without manually inputting values each time.
Drag to apply in bulk
Apply the same prompt across many rows or columns at once, simplifying repetitive tasks without needing to input them manually one by one.
Select your favorite model
Choose from a broad range of models from OpenAI, Anthropic, Perplexity or Ollama. You can even connect to an OpenAI assistant to bring your own knowledge.
Cached locally in your workbooks
Results are stored locally in your workbook, avoiding extra costs and loss of results in case of auto-recalculation.
Control with other formulas or even VBA
GPT for Excel allows you to combine GPT functions with regular spreadsheet formulas, such as IF or CONCATENATE, or VBA (Visual Basic for Applications) for more complex and tailored solutions.
Set custom instructions
Give precise spreadsheet-level instructions to guide the model on style, tone, format and other important details of the output you want.
Bulk tools: High-volume prompting from the sidebar
- Super fast bulk-prompting of up to 1,000 requests per minute.
- Reliable processing over hundreds of thousands of rows.
- Easy-to-use interface, no need to write formulas.
7 available tools
Custom prompt, Translate, Classify/Categorize, Extract, Reformat, Search the web, Prompt images (Vision).
Easy UI
Bulk tools are accessible from the sidebar, with a clean, straightforward, and easy-to-navigate interface which allows you to run prompts with just a few clicks.
Results directly in cells
The results of your prompts are written directly in cells, meaning no auto-reload issues, no need for caching, easier further edits and painless moving data around.
Track your progress and stop any time
Once you’ve launched a run, track its progress from the sidebar. Stop your run immediately in one click if you need.
Prompt History
Quickly access a list of your recent prompts from the History page, so you can quickly reapply them without needing to start from scratch.
Reliable at very high volume
Bulk tools can quickly handle hundreds of thousands of rows, ensuring the process remains stable and accurate at scale.
Per-run custom instructions
You can set custom instructions to define specific guidelines or constraints for your run, ensuring that the results match your expectations.
Microsoft Excel formula assistant
Easily generate new formulas or explain existing formulas, directly in Microsoft Excel.Describe what you want to do in natural language and generate a formula
Simply tell the formula assistant what you want to do, like summing certain cells or applying conditions, and it will automatically generate the right formula for you that you can directly use in your sheet. No need to know the exact functions - just describe your goal.
Explain existing formulas
If you’re not sure what a formula does, paste it in, and the assistant will explain its components and function in plain terms.
Reliable at very high speed
Requests per minute | Requests per hour | Requests per day | |
---|---|---|---|
GPT Functions | 1,000 | 60,000 | 1,440,000 |
Bulk tools | 1,000 | 60,000 | 1,440,000 |
- Up to 1,000 requests per minute with GPT functions
- Up to 1,000 requests per minute with bulk tools
- Up to 1 million rows with bulk tools
Privacy and security
- Talarian is ISO 27001 certified
- GDPR compliant
- Bring your own API keyBy using your own API key, your usage is bound by the terms you negotiated with your AI provider. We don’t store any of your inputs and outputs.
Supported Models in GPT for Excel
OpenAI
- gpt-4o
- gpt-4o-mini
- gpt-3.5-turbo-instruct
- gpt-4-turbo
- gpt-4
- Fine-tuned models
- Assistants
Perplexity
- llama-3.1-sonar-small-128k-online
Anthropic
- claude-3.5-sonnet
Ollama
- All Hugging Face models such as Llama 3.2, Qwen 2.5, Mistral, Deepseek...
How is it different from ChatGPT.com or Copilot?
- GPT for Excel lets you use AI directly in Microsoft Excel
- The GPT for Sheets UI is made for bulk processing tabular data
- GPT for Excel offers AI from many providers
- GPT for Excel is fast and reliable for hundreds of thousands of prompts