Excel Column Letter to Number: overview
Spreadsheet columns are labeled with letters, but formulas, scripts and APIs often need the column number — or the reverse.
Type letters to get the number, or a number to get the letters, both at once.
How to use Excel Column Letter to Number
- Type column letters on the left.
- Or type a column number on the right.
- Click a result to copy it.
How the numbering works
It's a base-26 system with no zero: A–Z are 1–26, then AA is 27, AZ is 52, BA is 53 and ZZ is 702.
Excel's last column is XFD (16,384); Google Sheets allows up to 18,278 columns (ZZZ).
In formulas you can use =COLUMN(AB1) for the number or =SUBSTITUTE(ADDRESS(1,28,4),"1","") for the letters.
Frequently asked questions
What column number is AA?
27.
What letters are column 100?
CV.
Is it zero-based?
No, A is 1. The zero-based index is also shown.
What is the Excel Column Letter to Number?
The Excel Column Letter to Number is a free online tool on trysandbox.io. In short: AA → 27 and 27 → AA. It is part of our developer collection and works directly in your web browser on desktop, tablet and phone, with no sign-up, no download and no usage limits.
People usually find this page when searching for terms like excel, column, letter, number, converter, sheets. Whatever brought you here, the goal is the same: get a correct result quickly, understand what the tool is doing, and know how to use the output with confidence. This guide explains exactly that.
Why use an online Excel Column Letter to Number?
Developer utilities remove small but constant friction from daily work. Formatting, converting, validating and generating configuration by hand is slow and error-prone; a focused tool does it correctly in a second so you can stay focused on the real problem.
Having these utilities in one place also means you do not need to install packages, open a terminal or write one-off scripts just to check a value. That is especially useful on locked-down work machines or when helping a colleague over a call.
The Excel Column Letter to Number is designed for web developers, back-end engineers, DevOps engineers, data analysts, students and technical writers. You do not need technical knowledge to get started, but advanced users will find the options they need to fine-tune the result.
Common uses for the Excel Column Letter to Number
Here are some of the most common situations where the Excel Column Letter to Number is useful:
- Formatting or validating data before committing it to a repository
- Converting between formats when two systems expect different structures
- Generating boilerplate configuration as a reliable starting point
- Debugging API requests, responses and payloads
- Explaining a technical concept to a teammate with a live example
Step-by-step: getting the best result
Paste or type your input, adjust the options, review the output, and copy it into your editor or terminal. For repeat tasks, bookmark this page — the link opens the tool directly, ready to use.
If the result is not what you expected, change one option at a time and compare. Small adjustments are easier to understand than changing everything at once, and you will quickly learn which settings matter most for excel column letter to number tasks.
Tips and best practices
Follow these recommendations to get reliable, professional results from the Excel Column Letter to Number:
- Read generated boilerplate line by line; defaults are sensible but your environment may need different values.
- Validate output against your real system — run the config, call the endpoint, or load the file in the target application.
- Keep generated configuration in version control so changes are reviewed and reversible.
- Remove secrets and personal data from samples before sharing them with others.
Mistakes to avoid
Even experienced users run into these problems. Keep them in mind when working with the Excel Column Letter to Number:
- Copying output into production without testing it in a staging environment first.
- Assuming a format conversion is lossless — comments, ordering and types can change between formats.
- Ignoring character encoding, line endings and whitespace differences between systems.
Privacy and security
Processing happens locally in your browser, so source code, payloads and configuration you paste stay on your device. That makes the tool safe for proprietary code and internal data.
We built trysandbox.io around this principle because utility tools often handle personal or business information. Running the Excel Column Letter to Number locally means faster results, no waiting for uploads and no risk of your input being stored on someone else's server.
Excel Column Letter to Number: frequently asked questions
Do I need to install anything to use the Excel Column Letter to Number? No. It runs in any modern browser, including Chrome, Edge, Firefox and Safari, on Windows, macOS, Linux, Android and iOS. Just open the page and start working.
Does the Excel Column Letter to Number work on mobile? Yes. The layout adapts to small screens, and every control can be used with touch. For long inputs or large files, a laptop or desktop is more comfortable, but the result is the same.
Is my data saved? No. Nothing you enter into the Excel Column Letter to Number is stored on our servers. If you refresh or close the page, your input is cleared, so copy or download your result before leaving.
Can I use the result commercially? Yes. Output you create with the Excel Column Letter to Number is yours to use in personal, client and commercial work. You are responsible for checking that the final result is accurate and suitable for its purpose.
What should I do if something looks wrong? Double-check your input first, then try different options. If the problem continues, contact us through the Contact page with a short description and we will look into it.
Is the Excel Column Letter to Number free?
Yes. The Excel Column Letter to Number is completely free to use, as often as you like, for personal and commercial projects. There is no account, no watermark and no trial period. The site is supported by advertising, which keeps every tool available to everyone.
If you find the Excel Column Letter to Number useful, explore the related tools in the Developer category — many tasks combine two or three tools, and they all share the same simple, private, browser-based approach.