{"uid":"cap_EnVZiqxbFEJT84lcA-CYX","slug":"spreadsheet-references-column-converter-ae21ae79","name":"Spreadsheet References - Column Converter","description":"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.","url":"https://spreadsheet.openverbs.com/v1/column","method":"POST","headers":{},"bodySchema":{"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","properties":{"letter":{"type":"string","maxLength":8,"minLength":1,"description":"Column letters, e.g. \"AA\"."},"number":{"type":"integer","maximum":16384,"minimum":1,"description":"1-based column index."}},"additionalProperties":false},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.004","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.004/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_IWs1aT14DcqbaAH8V3Kdm","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.004","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Converts between spreadsheet column letters (e.g. 'AA') and 1-based column index numbers (e.g. 27)","exampleAgentPrompt":"What column letter corresponds to column number 28 in a spreadsheet — like what Excel or Google Sheets would call it?","exampleUseCases":[{"title":"Column letter to index lookup","prompt":"I'm building a spreadsheet parser and need to know what 1-based column index the letter 'AC' corresponds to — can you convert that for me?"},{"title":"Index to column letter for export","prompt":"I need to reference column number 54 in a Google Sheets formula but I only know its number — what's the letter for column 54?"},{"title":"Validate column reference in automation","prompt":"I have a column called 'Z' and want to confirm its column number so my automation targets the right one — what index does column Z correspond to?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T18:41:21.643Z","isFirstParty":false}