# Spreadsheet References - Column Converter

> Spreadsheet References - Column 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 between spreadsheet column letters (e.g. 'AA') and 1-based column index numbers (e.g. 27)

## Facts

- Endpoint: POST https://spreadsheet.openverbs.com/v1/column
- 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-references-column-converter-ae21ae79
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_EnVZiqxbFEJT84lcA-CYX

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-references-column-converter-ae21ae79 -d '<json body>'
```

Example prompt: What column letter corresponds to column number 28 in a spreadsheet — like what Excel or Google Sheets would call it?

## When to prefer this

Use this endpoint when you need to programmatically convert between spreadsheet column letters and 1-based numeric indices, such as when building spreadsheet parsers, automating data exports, or constructing cell references dynamically. Prefer this over manual computation or custom code when you want a reliable, off-the-shelf conversion for any column up to index 16384.

## Known failure modes

- Column letter exceeds maximum allowed length of 8 characters
- Column number outside valid range of 1–16384
- Missing required body fields (letter or number)
- Invalid bodyType provided — must be json, form-data, or text
- Malformed input object structure

## How this service works

Convert between a spreadsheet column letter and its 1-based index in either direction. Provide exactly one of `letter` (e.g. "AA") or `number` (e.g. 27); the response always contains both.

## Output

Returns the corresponding column letter or column index number for the given input — converting a letter like 'AA' to its 1-based numeric position, or a number like 27 to its spreadsheet column letter.

## Request schema (JSON Schema)

```json
{
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "type": "object",
 "properties": {
  "input": {
   "type": "object",
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "type": "string",
     "enum": [
      "POST"
     ]
    },
    "bodyType": {
     "type": "string",
     "enum": [
      "json",
      "form-data",
      "text"
     ]
    },
    "body": {
     "type": "object",
     "properties": {
      "letter": {
       "type": "string",
       "minLength": 1,
       "maxLength": 8,
       "description": "Column letters, e.g. \"AA\"."
      },
      "number": {
       "type": "integer",
       "minimum": 1,
       "maximum": 16384,
       "description": "1-based column index."
      }
     },
     "additionalProperties": false
    }
   },
   "required": [
    "type",
    "method",
    "bodyType",
    "body"
   ],
   "additionalProperties": false
  }
 },
 "required": [
  "input"
 ]
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/spreadsheet-references-column-converter-ae21ae79/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)