Excel Column Index
Convert Excel column letters to numbers and back.
Convert Excel column letters to numbers and back. Enter your numbers and get an instant result.
Convert an Excel column name to its number, or a number back to the name: A becomes 1 and 1 becomes A, AA becomes 27 and 27 becomes AA.
The name direction accepts letters only and is case-insensitive; a digit or a symbol in the name reports that the name may contain only A to Z. The number direction accepts whole numbers from 1 to 16 384, the last column in a modern spreadsheet.
It converts coordinates, not cells. There is no row number, no sheet name and no cell content, so `AA` is 27 rather than `AA1`.
Why the numbering is not base 26
Column names are a bijective base-26 system: there is no zero digit, so each letter carries one more than its base-26 value before the running total is multiplied.
The name direction multiplies the running total by 26 and adds the letter's position from A equals 1. The number direction decrements before taking the remainder, which is what keeps Z, AA and AZ contiguous rather than leaving gaps.
The upper bound is enforced on the number direction only. A name longer than three letters converts to a number above 16 384 without a warning, because the page's check is on the numeric side.
- Name to index: A is 1, Z is 26, AA is 27, XFD is 16 384
- Index to name: 1 to 16 384, inclusive
- Letters only, any case, in the name direction
Where the answer is used
The usual job is translating a column reference for a script or a formula generator, where an API wants an index and a person reads a letter.
It is also useful when reading a spreadsheet formula by hand: `SUM(AA:AZ)` covers columns 27 to 52, which is easier to reason about as a range once both ends are numbers.
How to use the direction and value
Pick the Conversion direction, then enter the Value: letters A to Z for a name, or a whole number from 1 to 16 384 for a number. The placeholder shows which shape the direction expects.
Read the translated value in the Translation panel. Names are case-insensitive and digits in a name are refused; these are coordinates, not cells, so `AA` is 27 rather than `AA1`.
What to Expect
Best for
- Translating a column letter into the index an API expects
- Turning a numeric column offset back into a letter
- Reading a spreadsheet range as a pair of numbers
Not ideal for
- A full cell reference such as B7, which mixes a column and a row
- A name above XFD converted in the other direction, which is not checked
- Converting many columns at once, since the page handles one value
What this tool keeps
- Case insensitivity in the name direction
- The 1 to 16 384 bounds on the numeric direction
- A specific refusal sentence for a non-letter character
What may need cleanup
- A four-letter name, which converts to a number beyond the last column
- A cell reference pasted whole, whose row digits are refused
- A space anywhere inside the name, which is not a letter and is refused
Common errors
- Reading AA as 26 because base 26 has no zero
- Pasting AA1 and getting a letters-only refusal
- Entering 0 and expecting A
Example use cases
- Converting AA to 27 for a sheet API
- Turning a numeric column index into a letter for a report
- Checking what XFD comes to
Sample input
Convert the column name AA in the name-to-index direction.
Sample output
27 as the converted value.
Who this is for
- Developers scripting against a spreadsheet API
- Analysts reading formulas with high column letters
- Anyone checking a column coordinate by hand
Frequently asked questions
How are Excel column names converted?
A becomes 1, AA becomes 27 and the reverse maps a number back to its name, case-insensitively in the name direction.
Can I paste a full cell reference such as B7?
No. The row digits are refused; the page converts a column name or a column number, one value at a time.
What happens to a name above XFD?
The numeric direction is bounded at 1 to 16 384, so a value beyond the last column is refused.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.