Skip to main content

Convert to international phone number ★

Converts various phone number formats to international phone numbers for a given country.

URL​

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

Configuration​

ConfigurationRequiredDescription
number✔Specify 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/international-normalize?number="&ENCODEURL(A2))

B10 (Convert to Chinese format)

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

B11 (Convert to US format)

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