KoguNavi

Excel Column Letter & Number Converter

Enter a column letter, number, or range such as B:AZ.

Developer tools

Result

52

What it helps with

  • Read a spreadsheet API column index
  • Build a formula or import mapping
  • Count columns in a wide range

How to use

  1. Enter letters, a number, or a column range.
  2. Review the automatic conversion.
  3. Copy the result for a formula, script, or mapping.

Examples

Column AZ

Input

AZ

Output

52

Range B:AZ

Input

B:AZ

Output

51 columns

Good to know

  • Only column references are supported; cell addresses, sheet names, and formulas are not parsed.

FAQ

Why is XFD the maximum?
Modern Excel worksheets have 16,384 columns, ending at XFD.
Does B:AZ include both ends?
Yes. Range counts are inclusive.

Related tools

Nearby utilities from the KoguNavi toolbox.

Browse all tools

Conversion tools

JSON / CSV Converter

Convert between JSON and CSV, including nested JSON columns.

Open tool →

Conversion tools

Pasted Table to CSV

Split copied tables into CSV or TSV.

Open tool →

Conversion tools

Japanese CSV & Roster Preflight Checker

Check Japanese roster columns for blanks, duplicates, and contact-format issues.

Open tool →