Skip to content

Google Sheets parser functions

Parser functions in Google Sheets, explained with live examples.

6 parser functions in Google Sheets0 documented in depth so far, the rest indexed below and landing every week.

All Google Sheets parser functions

The full set — deep dives on the way.

CONVERT
Converts a numeric value to a different unit of measure.
TO_DATE
Converts a provided number to a date.
TO_DOLLARS
Converts a provided number to a dollar value.
TO_PERCENT
Converts a provided number to a percentage.
TO_PURE_NUMBER
Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.
TO_TEXT
Converts a provided numeric value to a text value.

More Google Sheets function categories