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

Configuration	Required	Description
number	✔	Specify a phone number. Any format is acceptable.
country		Specify 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))