1. Home
  2. Docs
  3. Network Tools for Excel Support
  4. Web Functions
  5. HTTPSTATUS

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