Convert Google Docs and Google Sheets with Apps Script

With Google Apps Script, you can effortlessly convert any Google Spreadsheet or Google Document in your Google Drive to other formats like PDF, XLS, and more. You can then either email the converted file or save it back to your Google Drive.

If you prefer a simpler option that doesn’t involve writing any Google Apps Script code, you can use the Email Google Spreadsheet add-on.

Save Google Document as HTML file

function exportAsHTML(documentId) {
  var forDriveScope = DriveApp.getStorageUsed(); //needed to get Drive Scope requested
  var url = 'https://docs.google.com/feeds/download/documents/export/Export?id=' + documentId + '&exportFormat=html';
  var param = {
    method: 'get',
    headers: { Authorization: 'Bearer ' + ScriptApp.getOAuthToken() },
    muteHttpExceptions: true,
  };
  var html = UrlFetchApp.fetch(url, param).getContentText();
  var file = DriveApp.createFile(documentId + '.html', html);
  return file.getUrl();
}

Export Google Spreadsheet as Microsoft Excel format

function exportAsExcel(spreadsheetId) {
  var file = Drive.Files.get(spreadsheetId);
  var url = file.exportLinks['application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];
  var token = ScriptApp.getOAuthToken();
  var response = UrlFetchApp.fetch(url, {
    headers: {
      Authorization: 'Bearer ' + token,
    },
  });
  return response.getBlob();
}