I wamt a excel sheet that automatically checks the indexing of a url a

Excel alone cannot check the indexing of a URL. You would need to use a programming language to interact with a search engine’s API to check if a URL is indexed.

One way to do this is by using Google Apps Script with Google Sheets. Google Apps Script is a JavaScript-based scripting language that lets you add functionality to your Google Apps.

Here’s a basic example of how you might set this up:

function checkIndexing() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getRange("A2:A"); // Assuming URLs are in column A starting from row 2
  var urls = range.getValues();

  urls = urls.map(function(url) {
    if (url[0]) {
      var response = UrlFetchApp.fetch("https://www.google.com/search?q=info:" + encodeURIComponent(url[0]));
      return [response.getResponseCode() == 200 ? "Indexed" : "Not Indexed"];
    } else {
      return [""];
    }
  });

  sheet.getRange("B2:B").setValues(urls); // Writes the results in column B
}

 

This script will check each URL in column A (starting from row 2) to see if it’s indexed by Google. It writes “Indexed” in column B if the URL is indexed, and “Not Indexed” otherwise.

Please note that this is a very basic script and may not work perfectly for all URLs. Also, Google may block your IP if you send too many requests in a short period of time. You might want to add some delay between requests to prevent this.

To use this script, click on Extensions > Apps Script in Google Sheets, paste the script in the editor, and then run the checkIndexing function.

Remember to replace "A2:A" and "B2:B" with your actual range of URLs and the range where you want to write the results.

This is just a starting point. Depending on your needs, you might need to modify the script or use a more sophisticated method to check URL indexing.

Thanks