Get the HTTP response status code of a URL.

<aside> 🆓 This is a free function. The AppScript code and original tutorial is available here: https://keywordsinsheets.com/status-codes/

</aside>

How to use the formula

=statuscode(url)

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

Eg. =statustcode(”<https://www.amazon.co.uk>”)

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.

</aside>