1. Home
  2. Units & Currency
  3. Excel Column Converter

Excel Column Converter

A=1, Z=26, AA=27 ... XFD=16384. Letters, cell addresses and range sizes.

Runs in your browser · No upload
Type letters like AB to get the number, or a number like 28 to get the letters.
Column number
28
Column AB is number 28

Excel limits
FormatMax rowsMax columnsLast column
xlsx (Excel 2007 and later)1,048,57616,384XFD
xls (Excel 2003 and earlier)65,536256IV

How to use

  1. On the Letter / number tab, type letters such as AB to get 28, or a number such as 28 to get AB. The tool tells which one you typed.
  2. On the Cell address tab, AB12 is split into row 12 and column 28. You can also type a row and a column number to build an address. Addresses with $ such as $AB$12 work too.
  3. On the Range size tab, A1:C10 is counted as 10 rows by 3 columns, 30 cells. Whole-column (A:C) and whole-row (3:10) ranges work as well.
  4. The Column list tab builds a table of numbers and letters for any span of columns and gives you a tab-separated copy you can paste into a sheet.

How a column letter becomes a number

Excel names columns with a 26-letter system. Unlike ordinary base 26 there is no letter for zero, so Z is followed directly by AA. To convert, multiply each letter value (A=1 … Z=26) by the matching power of 26 and add them up.

  • AB = 1 x 26 + 2 = 28
  • XFD = 24 x 676 + 6 x 26 + 4 = 16,224 + 156 + 4 = 16,384
Letters Number Note
A 1 First column
Z 26 End of single letters
AA 27 First two-letter name
AZ 52
BA 53
ZZ 702 End of two letters
AAA 703 First three-letter name
CV 100 Column 100
XFD 16,384 Last column in Excel

Excel limits

Format Max rows Max columns Last column
xlsx (Excel 2007 and later) 1,048,576 16,384 XFD
xls (Excel 2003 and earlier) 65,536 256 IV

A whole sheet (A1:XFD1048576) holds 1,048,576 x 16,384 = 17,179,869,184 cells. A whole column (A:A) holds 1,048,576. A CSV file can contain more rows than that, but Excel stops reading at the limit.

Formulas that do the same inside Excel

  • Letters to number: =COLUMN(AB1) returns 28
  • Number to letters: =SUBSTITUTE(ADDRESS(1,28,4),"1","") returns AB
  • Size of a range: =COLUMNS(A1:C10) returns 3 and =ROWS(A1:C10) returns 10

Google Sheets has the same functions with the same results.

Common mistakes

  • Expecting a column after XFD. Names like XFE or ZZZ do not exist in xlsx. The tool reports them as out of range.
  • Writing row before column. A cell address is always column letters then row number, such as C5. 5C is not an address.
  • Mixing up R1C1 notation. R12C28 names the same cell with numbers. The cell tab reads only the usual A1 style.
  • Reversing the ends of a range. Excel reads C10:A1 as the same range as A1:C10, and so does this tool, which shows the corrected form.

Frequently asked questions

Which column number is AA in Excel?

  1. Z is 26 and AA comes right after it. AZ is 52 and BA is 53.

What is the last column in Excel, and what number is it?

In xlsx the last column is XFD, number 16,384. The old xls format ends at IV, number 256.

How many rows can an Excel sheet have?

1,048,576 in xlsx and 65,536 in xls. Larger data is better split across sheets or files, or kept in a database.

Which letters is column 100?

CV: C (3) x 26 + V (22) = 78 + 22 = 100. The column list tab prints the whole table for any span.

How do I count the cells in a range?

(last row - first row + 1) x (last column - first column + 1). B2:D5 is 4 rows by 3 columns, so 12 cells. Both corner cells are included.

Can I type lowercase letters?

Yes. ab12 is read as AB12, and Excel formulas ignore case as well.

Is what I type sent to a server?

No. Everything is calculated in your browser and nothing is sent to a server.

What you type is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.