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.


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.


Excel showing HTTP status information in Microsoft Excel using HTTPSTATUS formula

Instructional Video