Excel Column Index screenshot

Excel Column Index

Convert Excel column letters to numbers and back.

Privacy First
0 Runs
Updated 2026-11-07
Runs in your browser
No account needed
Nothing sent to a server
Works offline after load

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.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.