ARABIC in Google Sheets: Turn Roman Section Labels into Numbers
Convert Roman numerals in Sheets within the documented 1–3999 range and build auditable numeric sorting and section-gap checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ARABIC calculates the numeric value of a Roman numeral. =ARABIC("XLVIII") has the expected result 48. Google documents Roman inputs whose values are from 1 through 3999.
Availability and version history
- Introduced: first launch date or introduction version not established by the official history reviewed.
- Availability: documented in the rolling Google Sheets service; this guide uses ordinary cells in the web editor, without a claim about identical mobile authoring workflows.
- Checked: October 14, 2026 against the official ARABIC reference. Examples were independently calculated; no native Sheets execution was performed.
Syntax and documented scope
=ARABIC(roman_numeral)
Supply a Roman-numeral text literal in quotation marks or a cell containing it. There is one required argument. This guide uses ordinary uppercase Roman notation within Google’s stated range. Official ARABIC reference
The short Google page does not establish a full acceptance grammar, error-code matrix, negative-number convention or blank-input rule. Do not infer those details from Microsoft Excel simply because the function has the same name. Treat unusual or out-of-range labels as a separate validation problem.
Prepare a fictional contents list
Enter this table in A1:B5, with headings in row 1:
| A: Section | B: Pages |
|---|---|
| XI | 4 |
| VI | 7 |
| XIV | 3 |
| IX | 5 |
In C1 enter Numeric section. In C2 enter and fill down through C5:
=ARABIC(A2)
Expected C2:C5: 11, 6, 14, 9. Column A preserves the printed section label while column C supplies a numeric sorting key. Conversion changes the returned value, not the source label.
Example 1: check subtractive notation
=ARABIC("XLVIII")
=ARABIC("XCIV")
=ARABIC("MMXXVI")
Expected results: 48, 94, 2026. XL is 40 and VIII is 8. XC is 90 and IV is 4. The final example represents 2000+20+6.
A small decomposition makes a good independent control before processing a full column. A plausible number alone does not prove that the exact printed source label was entered correctly.
Example 2: check the documented endpoints
=ARABIC("I")
=ARABIC("MMMCMXCIX")
Expected results: 1 and 3999. The upper example is 3000+900+90+9. These are inside Google’s stated domain, including its endpoints.
This guide does not promise a particular result for zero, negative Roman text or a value above 3999. It also does not assume that every visually similar Unicode symbol is interchangeable with the ordinary letters used here.
Advanced example: sort by numeric section order
Place this formula in E2, leaving E2:G5 empty for the result:
=SORT(A2:C5,3,TRUE)
Expected four-row result, with no automatically generated header:
| Section | Pages | Numeric section |
|---|---|---|
| VI | 7 | 6 |
| IX | 5 | 9 |
| XI | 4 | 11 |
| XIV | 3 | 14 |
The headings in this explanatory table are not produced by the formula. SORT moves whole rows together and uses the third column as the ascending key. Alphabetically ordering Roman text asks a different question.
The page total, =SUM(B2:B5), is 19. The sorted page column F2:F5 also totals 19. This checks that the same four complete records appear in the result rather than merely rearranging a detached key column.
Advanced example: distinguish a numeric interval from actual records
For VI in J2 and XIV in K2:
=ARABIC(K2)-ARABIC(J2)+1
Expected result: 9, the number of consecutive integers from 6 through 14 inclusive. The contents table has only four listed records, so this interval count does not prove that every intervening section is present.
If section labels can skip numbers, compare against the actual record list. A calculation about endpoints and a count of existing records measure different things.
Missing labels and review controls
Keep missing input distinct from a successful numeric conversion. For a source in A2, =IF(A2="","Missing label",ARABIC(A2)) explicitly returns Missing label when A2 is empty, without relying on an undocumented ARABIC blank rule.
For a workflow that needs to display a review flag instead of an error, wrap the conversion with IFERROR. That catches all errors from its expression; preserve the original label and inspect the unwrapped formula before deciding what failed. A successful conversion still is not a certificate of compliance with your document’s naming rules.
These examples use commas and English function names. Confirm the file’s locale when adapting formulas, and leave space for a sorted result to expand. Do not paste output formulas over the source labels you are trying to audit.
Verification: Expected results use fictional data and independent calculations rather than native Google Sheets observations. See the editorial testing standards.