Spreadsheet utility
Excel Column Letter Converter
Convert spreadsheet column numbers to letters, or letters back to numbers, using the same base-26 logic as Excel and Google Sheets.
Builder inputs
Enter a column number to get its letter, or enter a column letter to get its number. The two conversions are independent.
AA27Excel and Google Sheets both use base-26 column labels: A is 1, Z is 26, AA is 27.How this formula works
- Spreadsheet columns behave like a base-26 numbering system with A through Z.
- After Z, the next column is AA, then AB, and so on.
- This utility is useful when building dynamic formulas or translating column indexes from exports.
Sample data
| Number | Letter |
|---|---|
| 1 | A |
| 26 | Z |
| 27 | AA |
| 702 | ZZ |
Common mistakes
- Column numbers start at 1, not 0.
- Letters must be A through Z only.
- Column labels are not the same as row numbers in A1 notation.
Related formulas
FAQ
Are these formulas generated with AI?
No. The builder uses built-in spreadsheet rules in your browser and does not call an AI service.
Do I need to upload my spreadsheet?
No. Enter ranges and criteria manually. The site does not upload, store, or process spreadsheet files.
Can I copy the generated formula?
Yes. Each output includes a copy button so you can paste the formula into Excel or Google Sheets.