Determine phone number is valid or not

The various phone numbers are strictly determined if they can exist.
If the number can exist, "valid" is returned; if the number cannot exist, "invalid" is returned.

URL

https://api.excelapi.org/phone/ispossible

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

※ In the example, conditional formatting is used for coloring for clarity.

B2 (Convert to Japanese format)

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

B10 (Convert to Chinese format)

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

B11 (Convert to US format)

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