HTTPSTATUS

Summary

Shows information about the HTTP status of an URL. This function is available via the ‘HTTP Status’ taskpane as well as directly via the cell “=HTTPSTATUS(…)”


Return Value

The returned value depends on the chosen HTTP status query, see below.


Arguments

url – URL about which information is to be obtained.

query – Specifies the specific HTTP status data to be obtained, following queries are available:

  • CODE – HTTP status code.
  • MESSAGE – HTTP status message.

Example

Excel showing HTTP status information in Microsoft Excel using HTTPSTATUS formula

Instructional Video