# Spreadsheet RC to A1 Reference Converter

> Spreadsheet RC to A1 Reference Converter is a paid API for AI agents from spreadsheet.openverbs.com, paid per call via x402, $0.004/call, status unknown (last checked 2026-09-15).

Converts row/column integer coordinates to Excel/Sheets A1-style cell reference notation, with optional absolute reference prefixes.

## Facts

- Endpoint: POST https://spreadsheet.openverbs.com/v1/rc-to-a1
- Price: $0.004/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/spreadsheet-rc-to-a1-reference-converter-4e57be92
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_tSqGw-JFeju2Zjfk0fOiQ

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability spreadsheet-rc-to-a1-reference-converter-4e57be92 -d '<json body>'
```

Example prompt: Convert row 5, column 3 to an A1-style spreadsheet cell reference, and make the column absolute.

## When to prefer this

Use this endpoint when you need to programmatically convert numeric row/column coordinates into human-readable Excel or Google Sheets A1-style cell references, especially when building dynamic formulas, generating spreadsheet reports, or working with spreadsheet automation pipelines where absolute ($) references are needed.

## Known failure modes

- Row or column value out of allowed range (row must be 1–1048576, column must be 1–16384) results in validation error
- Missing required 'row' or 'column' fields returns a 400-level error
- Non-integer values for row or column cause schema validation failure
- Payment not processed or x402 auth missing returns 402 Payment Required

## How this service works

Build an A1-style cell reference from 1-based row and column numbers, optionally marking the row and/or column absolute ($).

## Output

Returns the A1-style cell reference string (e.g. 'C5', '$C5', 'C$5', or '$C$5') corresponding to the given 1-based row and column integers, with optional absolute-reference dollar-sign prefixes applied to row and/or column as specified.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method",
    "bodyType",
    "body"
   ],
   "properties": {
    "body": {
     "type": "object",
     "required": [
      "row",
      "column"
     ],
     "properties": {
      "row": {
       "type": "integer",
       "maximum": 1048576,
       "minimum": 1,
       "description": "1-based row."
      },
      "column": {
       "type": "integer",
       "maximum": 16384,
       "minimum": 1,
       "description": "1-based column."
      },
      "rowAbsolute": {
       "type": "boolean",
       "description": "Prefix the row with $. Default false."
      },
      "columnAbsolute": {
       "type": "boolean",
       "description": "Prefix the column with $. Default false."
      }
     },
     "additionalProperties": false
    },
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "POST"
     ],
     "type": "string"
    },
    "bodyType": {
     "enum": [
      "json",
      "form-data",
      "text"
     ],
     "type": "string"
    }
   },
   "additionalProperties": false
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/spreadsheet-rc-to-a1-reference-converter-4e57be92/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from spreadsheet.openverbs.com](https://www.zero.xyz/host/spreadsheet.openverbs.com/llms.txt)
