ToolXkit Icon

Excel Column Letter Converter

Turn a column letter into its number and back — A is 1, AA is 27.

  • Free
  • No signup
  • Nothing uploaded
  • No watermark

Column AA is number

27

Column letters count like A…Z, AA…AZ, BA… — there is no zero, so AA is 27 rather than 26.

The points where converters usually go wrong

LetterNumberWhy it matters
Z26the last single letter
AA27not 26 — there is no zero digit
AZ52end of the A block
BA53start of the B block
ZZ702the last two-letter column
AAA703three letters begin here
XFD16,384the last column in the sheet

How to Use the Excel Column Letter Converter Online

Excel Column Letter Converter: before and after TEXT A YOUR INPUT EXCEL COLUMNLETTERCONVERTER DONE A RESULT

Excel Column Letter Converter turns a column letter into its position number and a number back into letters. A is 1, Z is 26, AA is 27 and XFD, the last column in a sheet, is 16,384. It is handy when an error message or a script names column 143 and you need to find it, or when writing code that has to address column BZ. The rule is not plain base 26, because there is no zero, which is why home-made conversion code drifts as columns grow.

Turns a column letter into its number and back. The system is not quite base 26, because there is no zero digit — A is 1, Z is 26, AA is 27 rather than 0. That off-by-one is why naive conversion code produces answers that drift as the column index grows.

No software to install Free Works on any device

Step-by-Step Guide to Using the Excel Column Letter Converter

  1. 1. Type into either box — the other side converts as you type

  2. 2. The answer appears straight away

    there is no button to press.

  3. 3. Read the notes underneath for the cases that catch people out

Try it now

What is the Excel Column Letter Converter?

Turns a column letter into its number and back. The system is not quite base 26, because there is no zero digit — A is 1, Z is 26, AA is 27 rather than 0. That off-by-one is why naive conversion code produces answers that drift as the column index grows.

At a glance

  • Inputs: A column letter from A to XFD, or a number from 1 to 16,384
  • Output: The matching number or letter, updated as you type
  • Range: Up to XFD, the last column Excel allows
  • Reference: A short table of landmark columns, ending at XFD
  • Runs: In the page; no upload

Why Inspect a Document Before Sending?

A file can look fine on screen and still fail a portal check because of its version, page size, fonts or hidden permissions. Inspecting it first shows those details plainly, and the helper tools split, merge and shrink data and office files.

“Check the file before someone else rejects it.”
  • Page count and size at a glance
  • Version and standard checks
  • Hidden attachments brought out
  • Data files split or merged
  • Fonts and links listed
  • Permissions shown before you share
  • Office files made smaller
  • Excel formulas explained

Popular Uses for Document Checkers

These checks answer the questions people have about a file before it goes anywhere.

  • Print shop checks Confirm page sizes, orientation and PDF/X before sending artwork to a printer.
  • Archive submissions Check whether a PDF meets PDF/A before submitting it to a court or registry.
  • Counting pages and words Find the page count and word count of a PDF for a quote or limit.
  • Checking links List every link inside a PDF to find broken or outdated addresses.
  • Font problems See which fonts a PDF uses and whether they are embedded for printing.
  • Shrinking Office files Make a heavy Word, Excel or PowerPoint file smaller before emailing it.
  • Splitting large CSVs Cut a huge CSV or JSON file into parts that other tools can open.
  • Excel formula help Check a formula for errors or turn a column number into its letter.

What You Can Do with the Excel Column Letter Converter

Understands XLSX structure rather than treating the file as bytes

Conversion happens on your own machine, at your machine's speed

Resolves formulas and references rather than showing the raw text of the cell

Reports row, column and type counts, which is usually what a broken import comes down to

Why Use ToolXkit for Excel Column Letter Converter?

Your files stay with you

Everything runs inside your browser. Nothing you open or type is uploaded to a server.

Document Inspection for Different Users

Printers and publishers

Check PDF/X, page sizes and fonts before a job goes to press.

Legal professionals

Confirm PDF/A compliance, page counts and permissions before filing documents on a court portal.

Translators

Count words in a PDF to quote a fair price for a translation.

Data analysts

Split, merge and count rows in CSV and JSON files too big to open.

Office administrators

Check file sizes, versions and security settings before uploading to portals.

Web teams

Extract links and bookmarks from PDFs before publishing them on a website.

Best Times to Check a PDF or Data File

Inspection tools are worth a look when you are:

  • Sending artwork to a printer
  • Filing papers on a court portal
  • Quoting a translation job
  • Opening a CSV too big for Excel
  • Checking why a PDF was rejected
  • Sharing a file with restrictions
  • Emailing a heavy PowerPoint deck
  • Auditing links in a brochure

Tips and Good to Know

  1. Letters only, A to XFD. A cell reference like B5 or a range like A:C is not a column letter; use Excel Cell Reference Converter for a cell.

  2. Older .xls workbooks stop well before XFD, so a large number that converts here may not exist in that file.

Frequently Asked Questions

Answers to common questions about this tool.

Do I need to install anything to use the Excel Column Letter Converter?

No. Excel Column Letter Converter runs entirely in your browser — there is nothing to download, no extension and no desktop program. It works the same on Windows, macOS, Linux, Android and iPhone.

Is it safe to use the Excel Column Letter Converter online?

Safer than the usual alternative, yes. Most online tools upload your file to a server you know nothing about, where it sits until someone deletes it. Here the file never leaves your device — the processing happens in the page itself, so there is no server copy to leak, retain or sell.

Does Excel Column Letter Converter change my file?

The inspection tools only read the file and report what they find, so your document is untouched. Tools that split, merge or compress give you a new file and leave the original as it was.

What is PDF/A and do I need it?

PDF/A is a version of PDF made for keeping documents readable for many years. Some courts, government offices and archives ask for it. If a portal does not mention it, an ordinary PDF is fine.

Can I use Excel Column Letter Converter without signing up?

Yes. No account, no email and no fee. Drop in the file and the report or result appears on the page, ready to read or download.

Why was my PDF rejected by a portal?

Common reasons are a file that is too large, the wrong PDF version, a password, missing fonts or pages of the wrong size. Checking those details here usually points to the cause.

Further reading

More Document Inspector Tools

Other free tools for the same kind of job.

Browse all tools