← All text tools

Excel column letter to number converter

Convert spreadsheet column letters like AZ into numbers and numbers back into letters, one at a time or as a list, with a reference table up to the XFD limit.

  • Free
  • No sign-up
  • Works on any device

About Excel column letter to number converter

Spreadsheets label columns A, B, C, then AA, AB and so on. This is a base-26 system without a zero, so the number is 26 times the number of the earlier letters plus the value of the last letter: AZ is 1 × 26 + 26 = 52. Type letters to get the column number or a number to get the letters, paste a whole list, or enter a cell reference like B7 to read its column. Excel stops at XFD, column 16,384, and a reference table lists A, Z, AA, ZZ, AAA and XFD.

How to use Excel column letter to number converter

  1. Type column letters or a column number, or a reference like AZ12.
  2. Paste more values, one per line, to convert a list.
  3. Copy the results and compare with the reference table.

Why use this tool?

Also known as

Frequently asked questions

What is the last column in Excel?

XFD, which is column number 16,384 or 2 to the power of 14. Older .xls files stopped at column IV, number 256.

What number is column AZ?

Column AZ is number 52. A to Z take 1 to 26, AA is 27, and AZ is 26 + 26, since the first letter A counts as one block of 26.

How do I turn a column number into letters by formula?

In Excel use SUBSTITUTE(ADDRESS(1,N,4),"1","") with the column number in place of N. This page does the same arithmetic without needing a spreadsheet.

Is Excel column letter to number converter free?

Yes. Excel column letter to number converter on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put Excel column letter to number converter on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools