What is R1C1 notation?

R1C1 notation identifies a cell by its row and column numbers, written as R then the row, C then the column. So R3C2 means row 3, column 2, which is the same cell as B3 in A1 notation.

How does A1 notation differ from R1C1?

A1 notation labels the column with letters and the row with a number, like B3. R1C1 uses numbers for both axes. R1C1 makes relative offsets and formula patterns easier to read.

How are the column letters and numbers related?

Columns use bijective base-26: A=1, B=2, up to Z=26, then AA=27. The converter applies this exact mapping so B becomes column 2 and AA becomes column 27.

Can it convert cell ranges?

Yes. Enter a range with a colon such as A1:C10 and both endpoints are converted, producing R1C1:R10C3. Single-cell references work the same way without a colon.

Does it support relative R1C1 offsets like RC[-1]?

This converter handles absolute references where the row and column are explicit numbers. Relative bracketed offsets such as R[1]C[-2] depend on the active cell and are outside its scope.

What is the A1 ↔ R1C1 Notation Converter?

Convert spreadsheet cell references between A1 notation such as B3 and R1C1 notation such as R3C2. Handles single cells and ranges using the same bijective base-26 column math as Excel. It runs free in your browser on Gera Tools, with nothing uploaded.

A1 ↔ R1C1 Notation Converter

Name: A1 ↔ R1C1 Notation Converter
Creator: Gera Tools
License: https://creativecommons.org/licenses/by/4.0/

A1 versus R1C1

Spreadsheets can address cells in two styles. A1 notation — the default in Excel and Google Sheets — names the column with letters and the row with a number, for example B3. R1C1 notation names both the row and the column with numbers, so the same cell is R3C2. R1C1 is popular when writing formulas programmatically because relative positions become obvious arithmetic rather than shifting letters.

How it works

Converting between the two styles is really about converting the column between letters and a number using bijective base-26 (A=1, B=2, … Z=26, AA=27).

From A1 to R1C1, the tool splits the label into its letter and digit parts, turns the letters into a column number, and emits R{row}C{column}:

B3  ->  R3C2

From R1C1 back to A1, it reads the numeric row and column, converts the column number back into letters, and joins them:

R3C2  ->  B3

Ranges are handled by splitting on the colon and converting each endpoint independently, so A1:C10 round-trips to R1C1:R10C3.

Worked examples

A1 input	R1C1 result	Explanation
`B3`	`R3C2`	Row 3, column B = column 2
`Z1`	`R1C26`	Z is the 26th letter
`AA1`	`R1C27`	AA is column 27 (bijective base-26 wraps at Z)
`A1:C10`	`R1C1:R10C3`	Each endpoint converted independently

Going the other way: R5C28 becomes AB5 because column 28 is AB (27=AA, 28=AB).

When you would actually need this

The most common reason to switch between notations is VBA and Office scripting. Excel’s Cells(row, col) method takes numeric row and column arguments, so knowing that column D is column 4 (or that R2C4 = D2) helps when writing or debugging macros. Google Sheets’ INDIRECT function also accepts an optional R1C1 mode flag, so understanding the notation helps when building formulas that reference cells by computed positions.

A second use case is reading formula auditing tools — some Excel add-ins and analysis scripts display formula precedents in R1C1 notation to make patterns easier to spot across rows.

Converting large column numbers

Once you pass column Z (26), the pattern follows bijective base-26. The first few milestones:

A1 column	R1C1 column number
Z	26
AA	27
AZ	52
BA	53
ZZ	702
AAA	703

Excel supports up to column XFD (column 16,384), and the converter handles any column index in that range exactly, using the same algorithm Excel itself uses internally.

Using this in practice — Google Sheets INDIRECT

In Google Sheets, INDIRECT accepts an optional second argument: INDIRECT("R2C3", FALSE) returns the value of R2C3 in R1C1 notation, which is the same as cell C2 in A1 notation. This is useful when you want to build a cell reference from numeric row and column values computed by a formula. Convert your numeric column to A1 first here if you need to verify which letter it corresponds to.

Notes

This converter handles absolute references (explicit row and column numbers). Relative bracketed R1C1 offsets such as R[1]C[-2] depend on the active cell and are outside its scope — those are only meaningful inside a formula context.