Excel Column Converter
Convert between Excel column letters (A, AB, XFD) and numbers (1, 28, 16384). Handy for VBA, formulas, and programming. Everything runs in your browser.
Enter a column letter (AB) or number (28)
FAQ
Why is AA column 27?
Excel columns use bijective base-26 with no zero digit: A–Z are 1–26, then the next place value starts at AA (26×1+1=27).
What is Excel's last column?
XFD, the 16,384th column (in .xlsx since Excel 2007). Legacy .xls stops at IV (256).
How do I get column numbers in formulas?
Use =COLUMN(AB1) for the number or =SUBSTITUTE(ADDRESS(1,28,4),"1","") for the letter—this tool skips opening a sheet.
Related tools
Convert CSV data into JSON—either an array of objects using the header row, or a 2D array. Everything runs in your browser.
Convert numbers between binary, octal, decimal, and hexadecimal. Handles very large integers exactly, all in your browser.
Convert a list of lines into a comma-separated list and back.