Google Sheets Formula Checker and Separator Converter

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.