close
Breaking news

YouTube users’ ads secretly mine cryptocurrencies from user’s computer T...read more

Bulk url status checker in excel sheet

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.

  1. All you have to do is paste all URLs in URL column.
  2. 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.
  3. Check Page source if you need to store response text. Else leave it unchecked.
  4. 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. 😝

Show 6 Comments

6 Comments

  • cheques descuento
    July 2, 2017 Reply

    I don't know if it's just me or if perhaps everyone else encountering problems with your site. It seems like some of the written text within your posts are running off the screen. Can someone else please provide feedback and let me know if this is happening to them too? This may be a issue with my internet browser because I've had this happen before. Thanks cheques descuento

  • When someone writes an post he/she retains the idea of a user in his/her brain that how a user can be aware of it. So that's why this post is amazing. Thanks! ofertas y promociones

  • oferta especial
    July 3, 2017 Reply

    I'm gone to tell my little brother, that he should also go to see this webpage on regular basis to obtain updated from newest news update.

  • dan
    September 29, 2017 Reply

    sounds like a great tool - tried the download but the links not working - is this still available - would love to give it a try!

    • admin
      November 22, 2017 Reply

      Hi, the link has been fixed. Please check!

Leave a reply

Post your comment
Enter your name
Your e-mail address

Story Page