Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

FIU Digital Project Guidelines and Help Materials

The internal standard operating procedures for FIU Libraries' digital collections

Link Checking with Google Spreadsheets

  1. Import or create your spreadsheet in Google Sheets (available in Google Docs or Google Drive).
  2. From the menu bar at the top of the spreadsheet, select Tools > Script Editor 

  3. In the Script Editor code box, enter this script:
    function getURLStatus(url) {
      var options = {
         'muteHttpExceptions': true,
         'followRedirects': false
       var response = UrlFetchApp.fetch(url, options);
       return response.getResponseCode();
  4. Save the script and return to your spreadsheet
  5. In an empty column, type this script: getURLStatus(2)
  6. The number in the parentheses should reference the row number of the url you are testing
  7. If you need to test URLs in multiple rows, just select the box with the getURLStatus script and drag down from the blue square
  8. After the script loads you will see the results. 404 indicates a broken link, while 200 means the link works