Phone Number Data Type

This data type is applied to numeric data following common patterns that express telephone numbers.
  • Parentheses are optional around area code values: (###) ###-####
  • Phone numbers may or may not include the 1 at their beginning.
  • Dashes and spaces are optional between groups of numbers.

    NOTE: Spaces within a group of values are not supported and will result in a mismatched data type entry.

Standard Domestic U.S:

###-###-#####
(###)-###-#####
##########
1##########

Standard Domestic U.S. with extensions:

(###)-###-#### x ###
  • The dash in ###-#### is required when extension is present.
  • The extension indicator can be one of the following: x, X, ext, or EXT.

International U.S:

+1(###)-###-####

Not supported:

  • Local U.S. format not supported:

    ###-####
  • International format:

    +##-##-###-#####
  • Internal international format not supported:

    ##-##-##-###-#####
Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation