Get the HTTP response status code of a URL.

<aside> 🆓 This is a free function. The AppScript code and original tutorial is available here:


How to use the formula

=statuscode(url) (8).gif

To return a status code, you need to input a URL into the function.

Eg. =statustcode(”<>”)

The status code function only works on a cell-by-cell basis, you can’t input multiple URLs.

<aside> 💡 Quick tip: if you are using the status code function across 100s/1000s URLs and they’re stuck in loading, refreshing the spreadsheet can often make them appear.