In this post, I am going to tell you a quick and solid way to check HTTP status codes in Google Sheets in 4 steps, without any coding. This method works in any Google sheets in a sure shot way.
Finding HTTP status codes AKA HTTP response codes (ex. 301, 200, 404 etc) will help you improve the user experience of the site, website migration, improve SEO, check dead (404) links and much more. It’s a handy technique to know!
Alright, so here we go –
1 – Open any Google sheets and add the URLs you want to check the HTTP status for in column A
2 – Now the next step is to Install SEOMango add-on. If you know how to do it then you can install it and skip to step 3 or else you can follow the quick instructions below –
- Click on Add-ons menu in your spreadsheet besides the Help menu
- Click on Get Add-ons
- Search for SEOMango
- Click on install
3 – From the Add-ons menu go to SEOMango option and click on Run 404 checker
4 – Hola! You have checked HTTP status code for your the URLs in the Google sheet and now know which are broken links, which are valid links, which redirect etc.
I have found HTTP status by coding as well but found this to be the easiest way as it works in all the sheets. If you are interested in knowing how to achieve this by Google App Script then you can check this medium post by Mr. Adham.
If you were able to find HTTP status code using the add-on then please don’t forget to tell your friends about this blog by clicking on the Facebook icon below 🙂
Let us know in the comments below on what we can improve in the add-on.