Cell Coordinate A1 Parser
Parse one A1 address with optional absolute row and column markers, returning one-based safe indices and a canonical uppercase address; sheet names and ranges are excluded.
Description
An A1 cell address combines column letters with a one-based row number.
An A1 cell address combines column letters with a one-based row number. Dollar signs mark absolute references for formula copying; they are separate from the numeric row and column coordinates.1
Parse one A1 address with optional absolute row and column markers, returning one-based safe indices and a canonical uppercase address; sheet names and ranges are excluded.
When to use Cell Coordinate A1 Parser
Use this tool to parse one A1 address with optional absolute row and column markers, returning one-based safe indices and a canonical uppercase address; sheet names and ranges are excluded.
Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.
How to use Cell Coordinate A1 Parser and understand its results
- Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.
- Enter address using the field table and calculation rules, then run the tool.
- Read row, column, absoluteRow, absoluteColumn, canonical. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| address | Address | string; maximum length: 32 | Required |
Enter exactly one address such as $b$12. The parser accepts ASCII letters, optional dollar signs before the column and row, and a row beginning with 1–9. Both indices must fit safe integers. It returns the numeric row/column, independent absoluteRow and absoluteColumn flags, and a canonical address with uppercase letters and the original dollar signs.
column = bijective-base-26 letters; row = positive decimal digits Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| row | Row | integer; minimum: 1; maximum: 9007199254740991 |
| column | Column | integer; minimum: 1; maximum: 9007199254740991 |
| absoluteRow | Absolute row | boolean |
| absoluteColumn | Absolute column | boolean |
| canonical | Canonical | string |
{
"input": {
"address": "$b$12"
},
"output": {
"row": 12,
"column": 2,
"absoluteRow": true,
"absoluteColumn": true,
"canonical": "$B$12"
}
}Limitations and assumptions
Whitespace, sheet names, ranges, row zero and leading-zero row spellings are rejected. Generalized indices beyond actual worksheet capacity are accepted. This does not resolve a reference against a workbook or move a formula.
Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Extremely large text inputs are rejected. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors. A successfully returned false flag is an evaluated outcome; its meaning is explained above.
Alternative or Complementary methods
Use A1 Range Cell Count Expander: Expand an ordered rectangular A1 range in row-major order into relative addresses, rejecting reversed corners and limiting materialization to 5,000 cells. For a complementary task, use Column Letter to Index (A=1): Convert ASCII A1 column letters to a one-based safe integer using bijective base 26; generalized columns are accepted beyond Excel worksheet limits.
References
-
Cell Coordinate A1 Parser — tool.io
Similar or alternative tools
- A1 Range Cell Count Expander
Expand an ordered rectangular A1 range in row-major order into relative addresses, rejecting reversed corners and limiting materialization to 5,000 cells.
- Column Letter to Index (A=1)
Convert ASCII A1 column letters to a one-based safe integer using bijective base 26; generalized columns are accepted beyond Excel worksheet limits.