LACLI, an international repository of free online resources for Latin American, Caribbean, Latinx, and Iberian studies. It is an essential tool to find websites that provide access to a great variety of resources such as audiovisual materials, books, data, ephemera, government documents, oral histories, periodicals, reference works, visual materials, web archives and more!

LACLI Homepage
LACLI Spreadsheet

Google Sheet data is first processed with a Google Apps Script:

function doGet(request) {
  var spreadsheetId = '....'; // Replace with Google Sheet ID
  var sheetName = 'Main'; // Replace with the sheet you want to retrieve data from
  // make sure the advanced sheets service is enabled for this script
  var dataValues = Sheets.Spreadsheets.Values.get(spreadsheetId, sheetName).values;
  
  // Change the index from 0 to 2 to use row 3 as column headings
  var headers = dataValues[2];
  
  var rows = [];
  for (var i = 3; i < dataValues.length; i++) { // Start from row 4, as row 3 is the column headings
    var row = {};
    for (var j = 0; j < headers.length; j++) {
      row[headers[j]] = dataValues[i][j];
    }
    rows.push(row);
  }
  
  var output = JSON.stringify(rows);
  return ContentService.createTextOutput(output).setMimeType(ContentService.MimeType.JSON);
}

• Searches are not case sensitive and ignore diacritics.
• Truncation, wildcards, quotation marks, and lemmatization are not supported. It is preferable to search with singular rather than plural nouns.
• Search terms separated by a space are treated as independent search terms and are linked with the AND operator.
• All search terms must appear somewhere in the resource description fields for a resource to be returned in the results.
• To save a search, copy the url from the results page or use the export button to download the results as a JSON file.