Free Excel 404 URL Checker

Frequently, we are building  PPC search campaigns pointing to many different URLs.  How cool would it be to be able to check our dataset for 404 pages BEFORE we upload to AdWords, to Bing, or to Sklik? Read more to find out!

Situation: You just build your search campaign for an e-shop. Your final URLs point to hundreds and hundreds of pages. You don’t know if you made an error in the URL structure so you would like to check your KWs for 404 errors directly in Power Query.

So you have this simple input table, where you want to drop all your URLs (just make sure, all the URLs are included in the blue table):

Input table

DOWNLOAD FREE VERSION BUY FULL VERSION
The free version is limited to 50 URLs. The paid version has no limits.

And then at the end, you need to see something like this after you refresh the query:

Output table

Where:

  • 200=OK, page exists. Good!
  • 404=Bad luck! Page does not exist.
  • Domain does not exist = Really? Are you working on the correct project?

Of course, this little tool can be worked into every campaign build up as one of many related steps, this standalone sample is just to show one of the many things Power Query can do for you pretty effortlessly.

DOWNLOAD FREE VERSION BUY FULL VERSION
The free version is limited to 50 URLs. The paid version has no limits.

In order to refresh the tool:

  1. Drop up to 50 URLs into the blue table. (Paid version is unlimited).
  2. Navigate to green table>right click>Refresh. This will trigger refresh of “Values To Check” query.
  3. Confirm all prompts, set all permissions to “anonymous” or to “public” (if asked).
  4. Wait a little. The more URLs you have, the more time it will take. Generally speaking, 100 URLs should be checked in 1-2 minutes.

It’s that simple!

DZ

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.***

***Do you feel like you need more help? We can help you with PPC Automation and/or with your reporting under our new project MythicalReports.com here.***

4 thoughts on “Free Excel 404 URL Checker

    1. Hi Raneesh,
      you need to click the download arrow in the upper right corner on the after you click that link. Then it will get downloaded.

      DZ

  1. Seems like this is a great tool, but I can’t get the “Query – Values to Check” connection to refresh. I get an error saying: “Initialization of the data source failed.
    Check the database server or contact you database administrator….”

    The connection string is:
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=Values To Check;Extended Properties=””

    I’m an occasional Excel user, so I’m not sure how to troubleshoot this.

Leave a Reply to Raneesh Cancel reply

Your email address will not be published. Required fields are marked *