{"uid":"cap_tSqGw-JFeju2Zjfk0fOiQ","slug":"spreadsheet-rc-to-a1-reference-converter-4e57be92","name":"Spreadsheet RC to A1 Reference Converter","description":"Build an A1-style cell reference from 1-based row and column numbers, optionally marking the row and/or column absolute ($).","url":"https://spreadsheet.openverbs.com/v1/rc-to-a1","method":"POST","headers":{},"bodySchema":{"$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":{"row":{"type":"integer","minimum":1,"maximum":1048576,"description":"1-based row."},"column":{"type":"integer","minimum":1,"maximum":16384,"description":"1-based column."},"rowAbsolute":{"type":"boolean","description":"Prefix the row with $. Default false."},"columnAbsolute":{"type":"boolean","description":"Prefix the column with $. Default false."}},"required":["row","column"],"additionalProperties":false}},"required":["type","method","bodyType","body"],"additionalProperties":false}},"required":["input"]},"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_ZcRnDXCBD8Q-CrwBZonTD","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 row/column integer coordinates to Excel/Sheets A1-style cell reference notation, with optional absolute reference prefixes.","exampleAgentPrompt":"Convert row 5, column 3 to an A1-style spreadsheet cell reference, and make the column absolute.","exampleUseCases":[{"title":"Dynamic formula cell reference builder","prompt":"I'm generating an Excel formula and need to reference the cell at row 12, column 4 — can you give me the A1-style address for that, with an absolute column reference?"},{"title":"Spreadsheet report automation","prompt":"I'm building a Google Sheets report automatically and need to convert row 1, column 26 into its A1 notation so I can plug it into a range formula."},{"title":"Locked anchor cell for pivot tables","prompt":"What's the fully absolute cell reference (with $ signs on both row and column) for row 2, column 1 in spreadsheet notation?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T00:31:38.432Z","isFirstParty":false}