# Spreadsheet A1-to-RC Reference Converter

> Spreadsheet A1-to-RC 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-14).

Converts an A1-style spreadsheet cell reference (e.g. 'B3' or '$A$1') to its equivalent row-column (RC) numeric coordinates

## Facts

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

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-a1-to-rc-reference-converter-322749aa -d '<json body>'
```

Example prompt: Convert the cell reference B3 from A1 notation to its row and column numbers for me.

## When to prefer this

Use this endpoint when you need to programmatically convert human-readable A1-style spreadsheet cell addresses (like 'B3' or '$A$1') to numeric row-column coordinates, especially in automation workflows that process spreadsheet formulas, build grid navigation logic, or integrate with APIs that expect RC-format cell positions.

## Known failure modes

- Invalid or empty ref string returns a validation error
- ref exceeds 32 characters returns schema validation failure
- Malformed A1 notation (e.g. missing column letter or row number) may return an error or unexpected result
- Payment failure results in 402 response before processing occurs

## How this service works

Parse an A1-style cell reference (e.g. "B3" or "$AA$100") into 1-based row and column numbers, plus the column letters and whether each part is absolute.

## Output

The endpoint returns the numeric row and column indices corresponding to the given A1-style cell reference, allowing programmatic use of the cell's position in a spreadsheet grid.

## 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": [
      "ref"
     ],
     "properties": {
      "ref": {
       "type": "string",
       "maxLength": 32,
       "minLength": 1,
       "description": "A1 cell reference, e.g. \"B3\" or \"$A$1\"."
      }
     },
     "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-a1-to-rc-reference-converter-322749aa/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)