{"uid":"cap_aJVfiKONbmVWepDidyYZF","slug":"spreadsheet-a1-to-rc-reference-converter-322749aa","name":"Spreadsheet A1-to-RC Reference Converter","description":"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.","url":"https://spreadsheet.openverbs.com/v1/a1-to-rc","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","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}}},"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_sZ9tP5osO360jgz8ap6GI","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 an A1-style spreadsheet cell reference (e.g. 'B3' or '$A$1') to its equivalent row-column (RC) numeric coordinates","exampleAgentPrompt":"Convert the cell reference B3 from A1 notation to its row and column numbers for me.","exampleUseCases":[{"title":"Formula parser cell coordinate lookup","prompt":"I'm parsing a spreadsheet formula and need to know the row and column numbers for cell D7 — can you convert that A1 reference to RC format?"},{"title":"Absolute reference coordinate extraction","prompt":"What are the row and column numbers for the absolute cell reference $C$5 in a spreadsheet?"},{"title":"Spreadsheet automation cell positioning","prompt":"I need to programmatically position to cell AA12 in a spreadsheet — convert that A1 address to numeric row and column coordinates for me."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T12:34:22.267Z","isFirstParty":false}