Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the Parse error error
Excel & Google SheetsWhat Parse error means
A parse error in Google Sheets means the formula engine failed to tokenize or interpret the formula before it could even begin calculating. Unlike #VALUE! (which is a runtime error), a parse error is a syntax error — a bracket is unclosed, a function name is misspelled, or a locale-specific separator is wrong.
Common causes
- Using a semicolon (;) as the argument separator instead of a comma (,) when your Sheets locale expects commas, or vice versa.
- A misspelled function name — Sheets does not recognise it and cannot parse the call (e.g., =SUMIFF instead of =SUMIF).
- Unmatched parentheses — one or more opening parentheses ( has no corresponding closing parenthesis ).
- Straight double quotes missing around text literals, or smart/curly quotes were pasted in from a word processor.
- A formula pasted from Excel uses unsupported Excel-specific syntax such as implicit intersection (@) or structured table references ([Column]).
Example fix
Broken
=SUMIF(A2:A100;"East";B2:B100)Fixed
=SUMIF(A2:A100,"East",B2:B100)Replaced the semicolons with commas. This formula was authored under a European locale; a US-locale Sheets file requires commas as argument separators.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Check the argument separator: go to File > Settings > General and note the locale. Commas are standard for US locale; some European locales use semicolons.
- 2Verify the function name by starting to type it — Sheets autocomplete will show the correct spelling.
- 3Count parentheses: the number of ( must equal the number of ). Sheets colour-codes matched pairs when you click inside the formula bar.
- 4Replace any curly or 'smart' quotes with straight double quotes ("). These are often introduced by copy-pasting from documentation.
- 5For Excel formulas using structured references (Table[Column]), convert them to standard A1 notation or a named range before using in Sheets.
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every Parse error and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
My formula works fine in Excel but gives a parse error when I paste it into Google Sheets. Why?
Excel uses different syntax in some cases — semicolons vs commas, structured table references, or implicit intersection with @. Convert the formula to standard Sheets syntax after pasting.
How do I know which separator my Sheets file expects?
Go to File > Settings > General. The locale shown there controls whether commas or semicolons are the argument separator. You can change the locale to match your formula habits.
Can parse errors appear inside ARRAYFORMULA or QUERY?
Yes. QUERY parse errors are a separate category — they relate to the SQL-like query string inside QUERY, not to Sheets formula syntax. Those show as 'QUERY: Parse error' with a column reference in the message.