// a sandbox of 646 sharp tools

Every little generator
you keep googling for.

QR, barcodes, bcrypt hashes for PHP, UUIDs, JWT decoders, color palettes — fast, local, no signup. Search the sandbox and start.

Excel Column Letter to Number

Developer · tool

Excel Column Letter to Number

AA → 27 and 27 → AA.

Excel and Google Sheets columns run A–Z, then AA–AZ, BA… up to XFD (16,384) in Excel.

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

  1. Type column letters on the left.
  2. Or type a column number on the right.
  3. 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.

// about the sandbox

The small utilities you need,
without the ad-walls.

Most tools process their inputs in your browser. Tools that look up exchange rates, network details or word suggestions use external services; speech features can depend on your browser's services. Each tool's guide explains its purpose and practical limitations.

  • 646tool guides
  • 0accounts
  • 646sharp tools
  • ∞free forever