Google's AI function brings Gemini-powered language models right into your spreadsheet cells without any add-ons. With it, you can generate fresh text, summarize blocks of data, categorize entries, or even guess sentiments—all by typing a simple formula.
The article provides examples such as:
- *sentiment analysis* ```=AI("Is this customer feedback positive, negative, or neutral?", A2)```
- *data categorization* `=AI("Classify this expense as Travel, Office, or Other", D3)`
- *simple calculations* `=AI("Add the numbers in these cells", A1:A5)`
The article provides examples such as:
- *sentiment analysis* ```=AI("Is this customer feedback positive, negative, or neutral?", A2)```
- *data categorization* `=AI("Classify this expense as Travel, Office, or Other", D3)`
- *simple calculations* `=AI("Add the numbers in these cells", A1:A5)`
This article describes a workflow using Large Language Models (LLMs) to automate the process of normalising spreadsheet data, making it tidy and machine-readable for easier analysis and insights.
Quadratic is a modern spreadsheet that combines the familiarity of a spreadsheet with the power of code, allowing you to work with data and code collaboratively in real-time. It supports popular programming languages like Python, SQL, and JavaScript, and offers features such as dynamic charts, APIs, multi-line formulas, and AI integration.
