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 deterministic TypeScript functions in the browser and does not call any AI API.
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.