Paste a formula to check it for the problems that cause most Formula parse error messages in Google Sheets, and convert it between the two separator styles: commas (United States, United Kingdom) and semicolons (most of Europe and Latin America). Nothing you paste leaves your browser.
With commas
With semicolons
Syntax check only: the tool cannot tell whether a function exists or a range is valid in your sheet.
What the checker looks for
- Missing or extra parentheses
( )and braces{ }, and brackets closed in the wrong order - Text quotes or sheet-name apostrophes that are not closed
- Curly quotes (
“ ”) and apostrophes (‘ ’) copied from documents and websites - A formula that doesn’t start with
=, or ends with an operator - Excel-only syntax: the
@operator and table references such as[@Price] - Separators that don’t match your spreadsheet’s locale
It only checks the syntax. It can’t know whether a function exists or whether a range is valid in your spreadsheet, so a formula can pass the check and still return #NAME? or #REF!. Our guides to formula parse errors and #REF! errors cover those cases.
How the conversion works
| Element | Comma style | Semicolon style |
|---|---|---|
| Between arguments | , |
; |
| Decimal mark | 1.5 |
1,5 |
| Columns in an array | {1, 2} |
{1\2} |
| Rows in an array | {1; 2} |
{1; 2} |
Text in double quotes and sheet names in apostrophes are never changed, so "a, b" stays as it is.
Tested: we converted nine formulas with this tool, including arrays, decimals, dates and text containing commas, and entered the results in a Google Sheets spreadsheet set to Spain. All nine returned the expected values. The original comma versions returned Formula parse error, except two that gave a wrong number without any error (=SUM(1,2) returned 1,2).
Which style does my spreadsheet use?
Open File → Settings and look at the locale. If your locale writes decimals with a comma, as in Spain, Germany or Brazil, your spreadsheet uses semicolons between arguments.
The conversions this tool produces were last tested in Google Sheets on November 10, 2026.