Column Index to Letter (A1 Style)
Convert a one-based safe integer column index to ASCII A1 column letters without imposing Excel worksheet width limits.
Description
A1 spreadsheet notation names columns with letters: A through Z, then AA and onward.
A1 spreadsheet notation names columns with letters: A through Z, then AA and onward. This is bijective base 26, where each digit is 1–26 rather than including a zero digit.1
Convert a one-based safe integer column index to ASCII A1 column letters without imposing Excel worksheet width limits.
When to use Column Index to Letter (A1 Style)
Use this tool to convert a one-based safe integer column index to ASCII A1 column letters without imposing Excel worksheet width limits.
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 Column Index to Letter (A1 Style) 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 column using the field table and calculation rules, then run the tool.
- Read letters. 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 |
|---|---|---|---|
| column | Column | integer; minimum: 1; maximum: 9007199254740991 | Required |
Enter a one-based positive safe-integer column index. The tool repeatedly subtracts one, converts the remainder to A–Z and prepends that letter, continuing with the quotient until zero. It returns uppercase letters; 26 becomes Z and 27 becomes AA.
repeat: digit = (column − 1) mod 26; column = floor((column − 1) / 26) Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| letters | Letters | string |
{
"input": {
"column": 703
},
"output": {
"letters": "AAA"
}
}Limitations and assumptions
This is a generalized column-label conversion and accepts indices beyond Excel's XFD limit. It does not parse a cell address, enforce worksheet capacity or use zero-based indices. Fractional and unsafe integers are errors.
Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
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. For a complementary task, use Excel XFD 16,384-Column Limit Check: Check a worksheet column count against Excel’s XFD boundary of 16,384 columns, returning remaining capacity and a generalized A1 name for the last column.
References
-
Column Index to Letter (A1 Style) — tool.io
Similar or alternative tools
- 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.
- Excel XFD 16,384-Column Limit Check
Check a worksheet column count against Excel’s XFD boundary of 16,384 columns, returning remaining capacity and a generalized A1 name for the last column.