By using Excel you can check the status of any URL and also get redirected URL. Not only this, you can check bulk URLs in one go!
In Excel, using macro and VBA it can be done easily. I made an excel sheet where you can get all URL’s status with redirected URL and also you can fetch page source of URLs.
- All you have to do is paste all URLs in URL column.
- Click on first URL cell so that your ‘start url’ cell will be set.
Here is the catch! This functionality is implemented for bulk operations. When you start bulk checking, let say 2000 URLs at once, Excel might get hanged time to time. Because, For each & every url, it sends web request and receive requests from the web. To get rid of this situation you can break your entire URL checking in chunks. For example: for 2000 URLs you can go with 500 urls at one time. So first time your starting cell will be A3 (the first URL) and when first chunks checking will complete you can set starting url to next cell of last finished url.
- Check Page source if you need to store response text. Else leave it unchecked.
- Click on Start Checking.
That’s all! You will see excel start receiving url status and update in status and redirected url column. Also, it updates total url in the sheet and total url proceed so that it will easier for you when you do bulk operations.
Important Step!!! without this, you can’t be do anything above all. That is Download redirect-checker Excel sheet. 😝