Spreadsheet Editing

ModelMonkey edits your spreadsheet through natural language. You describe what you want, and the agent autonomously selects the right tools to make it happen.

You don't need to know the underlying tools — just ask for what you need. ModelMonkey handles the details.

ModelMonkey can write values, formulas, and text to any cell or range.

What you can do:

• Write single values or entire tables
• Insert formulas with cross-sheet references
• Update existing data with new values
• Clear ranges or individual cells

Example requests:

• "Add a SUM formula in cell E10 that totals E2:E9"
• "Fill column B with employee names from my list"
• "Update the Q3 revenue to 150,000"
• "Clear all data in the Notes column"

"Add a column header 'Total' in F1 and put a SUM formula in F2 that adds columns B through E"

ModelMonkey can extend patterns, sequences, and formulas automatically using AutoFill.

What you can do:

• Extend numeric sequences (1, 2, 3... → 4, 5, 6...)
• Continue date series (Jan, Feb, Mar... → Apr, May...)
• Copy formulas down a column with relative references
• Replicate patterns across rows or columns

Example requests:

• "Fill the dates down to row 100"
• "Extend the formula in D2 down to D50"
• "AutoFill the sequence 1, 2, 3 down to row 20"

ModelMonkey can create and manage charts based on your data.

Supported chart types:

• Line charts (trends over time)
• Column charts (vertical bar comparison)
• Bar charts (horizontal bar comparison)
• Pie charts (parts of a whole)
• Area charts (trends with filled areas)
• Scatter charts (relationship between variables)
• Histogram (data distribution)
• Combo charts (multiple chart types combined)

What you can do:

• Create charts from data ranges
• Set chart titles and customize appearance
• Position charts on specific cells
• Update existing chart data ranges
• Delete charts

Example requests:

• "Create a line chart showing monthly revenue from A1:B12"
• "Add a pie chart for the expense breakdown in D1:E6"
• "Make a bar chart comparing Q1 vs Q2 sales"

"Create a column chart titled 'Sales by Region' using the data in A1:D10, and place it next to the table"

ModelMonkey can format cells to improve readability and presentation.

Formatting options:

• Text styles: Bold, italic, font size, font family
• Colors: Font color, background color (hex codes supported)
• Alignment: Left, center, right, top, middle, bottom
• Borders: All sides, outline, horizontal, vertical, or custom per-side
• Number formats: Currency, percentage, decimals, dates, scientific notation
• Text wrapping: Enable or disable

Presets available:

• header: Bold, centered, gray background, bottom border
• data-table: Standard data formatting with light borders

Example requests:

• "Make the header row bold with a blue background"
• "Format column C as currency with 2 decimal places"
• "Add borders around the entire table"
• "Center-align all text in row 1"

ModelMonkey can apply rules that format cells based on their values.

Rule types:

• Boolean conditions: Greater than, less than, equals, contains, blank, custom formula
• Gradient color scales: Heat maps, cold-to-hot, traffic light

Preset gradients:

• traffic-light: Green → Yellow → Red
• heat-map: Green → Yellow → Red (data visualization)
• cold-to-hot: Blue → White → Red
• growth: Red → White → Green

Example requests:

• "Highlight cells greater than 1000 in green"
• "Add a heat map to the sales numbers in column D"
• "Turn negative values red and positive values green"
• "Highlight blank cells with a yellow background"

"Apply conditional formatting to B2:B50: highlight values above 100 in green, below 50 in red"

ModelMonkey can restructure and reorganize your spreadsheet data.

What you can do:

• Insert rows/columns: Add new rows or columns at specific positions
• Delete rows/columns: Remove entire rows or columns
• Move data: Relocate cell ranges to new positions
• Merge/unmerge cells: Combine cells or split merged cells
• Clear data: Remove values while keeping formatting (or vice versa)
• Duplicate sheets: Create copies of entire sheets

Example requests:

• "Insert 3 rows after row 10"
• "Delete column F"
• "Move the data in A1:C10 to start at E1"
• "Merge cells A1:D1 for the title"
• "Duplicate the Summary sheet as 'Summary Copy'"

ModelMonkey can create and manage sheets within your workbook.

What you can do:

• Create new sheets
• Rename existing sheets
• Duplicate sheets
• Set column widths

Example requests:

• "Create a new sheet called 'Q4 Report'"
• "Rename 'Sheet1' to 'Dashboard'"
• "Duplicate the Budget sheet for next year"
• "Make column A wider to fit the text"

ModelMonkey is powerful, but there are some things it cannot do yet:

Not currently supported:

• Pivot tables (creation or modification)
• Data validation rules
• Protected ranges and sheet protection
• Named ranges (creation)
• Sparklines
• Slicers and filters
• Macros and Apps Script
• Images embedded in cells
• Drawing objects (shapes, text boxes)
• Comments and notes (partial support)

Platform limitations:

• Chart editing is limited (basic property updates)
• Some advanced chart customizations (trendlines, error bars) are not available
• Complex nested conditional formatting may not work as expected

Get better results by being specific in your requests:

Be specific about ranges
Instead of "format the data", say "format cells A1:D10 as a table with headers".

Describe the outcome, not the steps
Instead of "select A1, make it bold, change color to blue", say "make the title in A1 bold and blue".

Reference existing data
Say "use the dates in column A" rather than manually listing values.

Ask for formulas over hardcoded values
Say "add a formula to calculate the total" rather than "put 1500 in the total cell".

Use sheet names for multi-sheet operations
Say "copy data from 'Sales' sheet to 'Summary' sheet" to be explicit about which sheets are involved.