Skip to main content

Convert to local phone numbers ★

Converts various phone number formats into the phone number format commonly used in a given country.

URL

https://api.excelapi.org/phone/local-normalize

Configuration

ConfigurationRequiredDescription
numberSpecify a phone number. Any format is acceptable.
countrySpecify the country code.
If not specified, the default is JP (Japan).

Example

サンプル

B2 (Convert to Japanese format)

=WEBSERVICE("https://api.excelapi.org/phone/local-normalize?number="&ENCODEURL(A2))

B10 (Convert to Chinese format)

=WEBSERVICE("https://api.excelapi.org/phone/local-normalize?country=CN&number="&ENCODEURL(A10))

B11 (Convert to US format)

=WEBSERVICE("https://api.excelapi.org/phone/local-normalize?country=US&number="&ENCODEURL(A11))