Agentic spreadsheet AI

AI in Quadratic can now access nearly every aspect of your spreadsheet, with tools to handle almost anything you could do manually. On top of just writing code and formulas, AI can now take countless other actions in the sheet**:** The AI can do almost anything you could do manually, freeing you up to focus on insights instead of manual operations.

We’ve also made significant improvements to context, enabling the AI to better understand your intent at any given moment.

AI spreadsheet agents get tools for everything

We added the following tools that allow the AI to reach deeper into your spreadsheet:

• GetCodeCellValue: sometimes it makes more sense to iterate on existing code cells instead of creating new ones
• GetDatabaseSchemas: used for SQL in left chat to read schemas as needed for writing correct SQL queries
• SetSQLCodeCellValue: for writing SQL
• HasCellData: AI can check to confirm if a section of the sheet has existing data
• AddSheet: create new sheets
• DuplicateSheet
• RenameSheet
• DeleteSheet
• MoveSheet: change the order of sheets
• ColorSheets: set a color for a sheet
• TextSearch: search the sheet for specific text
• RerunCode: run specific code cells in the sheet
• SetBorders
• ResizeColumns
• ResizeRows
• InsertColumns
• InsertRows
• TableColumnSettings
• Validations

Left Chat SQL code

Users can stay in the left chat to query their databases, or switch to the code-based chat on the right if they prefer. We made this change to reduce confusion about which chat to use and the benefits of each. This way, users who don’t know how to access the code chat can start in the left chat and move to the more focused right chat when needed.

Improved context

We spent considerable time experimenting with different formats for context.

In particular, we were interested in exploring:

• Markdown vs. XML vs. JSON
  • We decided on a combination of Markdown and JSON—Markdown for general instructions, and JSON for displaying data segments.
• Large-scale prompt adjustments for improved instruction-following
  • As context grows larger, clarity around tool calls and methods of analysis becomes increasingly important.

AI has a clearer picture of your intent, so its responses feel more context-aware and more useful.

Try it out today.