Spreadsheet References

spreadsheet.openverbs.com

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.

Website ↗

#a1 to row column #parse a1 reference #spreadsheet cell lookup #excel cell coordinates #a1 reference parser #row column to a1 #generate a1 reference #spreadsheet coordinate format

Category: Service
Networks: Base
Starting price: $0.004
Paid calls, 30 days: 8

Paid endpoints

4 endpoints, sorted by usage. Prices are per request.

Endpoint	Price	Network	Facilitator	Calls / 30d
POST/v1/a1-to-rc 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.	$0.004	Base	Coinbase CDP	2
POST/v1/column 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.	$0.004	Base	Coinbase CDP	2
POST/v1/range Parse an A1 range like "A1:C10" into its start and end cells (normalized so start is the top-left) and its extent — row count, column count and total cell count.	$0.004	Base	Coinbase CDP	2
POST/v1/rc-to-a1 Build an A1-style cell reference from 1-based row and column numbers, optionally marking the row and/or column absolute ($).	$0.004	Base	Coinbase CDP	2

Is this your project? Suggest an edit.