Skip to main content
Glama

Create Named Range

create_named_range

Create a named range in an open Excel workbook with name, range address, and optional sheet. Returns JSON confirmation of the resolved absolute reference.

Instructions

Create a new named range.

Args: workbook: Workbook name or path (None = active workbook). name: Name to create (required). Must start with a letter or underscore and contain no spaces. range_address: A1-style address the name refers to, e.g. "A1:C10". sheet: Worksheet the range is on (None = active sheet).

Returns: JSON confirmation with the resolved absolute reference.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nameNo
sheetNo
workbookNo
range_addressNoA1
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations only provide a title, so the description carries the behavioral burden. It discloses name syntax constraints, None-defaults for workbook and sheet, A1-style addressing, and the JSON confirmation return value. It does not mention duplicate-name behavior or permissions, but the core behavioral contract is clear.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is compact and well-structured with Args and Returns sections. The first sentence states the purpose, and every subsequent line adds meaningful parameter or return-value detail without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a four-parameter tool with no output schema and no annotation safety hints, it covers inputs, defaults, constraints, and return value adequately. It lacks edge-case behavior such as what happens when the named range already exists, but an agent has enough detail to call it correctly in typical cases.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, and the description fully compensates by explaining all four parameters, including defaults, constraints, and an example for range_address. It also clarifies that name is required despite the schema lacking a required list.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States 'Create a new named range' with a specific verb and resource, and 'new' distinguishes it from sibling update/delete/read/write named range operations. The scope is immediately clear.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies this tool is for creating named ranges, but it does not explicitly state when to use it over siblings like update_named_range or delete_named_range. No alternative conditions or exclusions are given, leaving usage largely to inference from the word 'Create'.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/trustypangolin/excel-mcp-live'

If you have feedback or need assistance with the MCP directory API, please join our Discord server