title: How do I convert the excel files into spreadsheet files without changing the existing excel files type in google drive folder?
body: <p>In a google sheet, I managed to filter file name and file type and list all the particular files needed from a google drive folder based on the conditions into a spreadsheet. I am having an <strong>issue to convert the excel files into spreadsheet</strong> because I'm opening the selected files using &quot;SpreadsheetApp.openById(id)&quot; in another function() to get the data range from the specific files.</p>
  <p>Based on the requirement set, I was been asked to convert the excel files into spreadsheet before getting the range data and export those data into another sheet.</p>
  <p>Below are the codes that i created to list the file name and file type, so i believe that the <strong>file conversion method might need to be implemented here as well because it involves the file filtering process and these are the files need to be converted later on</strong>. Please correct me if I am wrong.</p>
  <pre><code>function getChildFiles(parentName, parent, sheet) {
  
  var fileIter = parent.searchFiles(&quot;title contains 'completed'and title contains 'Verification 
  Visit Direct Suppliers'and mimeType='application/vnd.openxmlformats- 
  officedocument.spreadsheetml.sheet'&quot;); 
  
  var output = [];
  
  var now = new Date();
  var date = new Date();
  var copy = new Date(date);
  
  while (fileIter.hasNext()) { 
  var file = fileIter.next();
  
  var fileName = file.getName();
  
  var fileType = file.getMimeType();
  
  var filecreatedate = file.getDateCreated();
  
  var fileUpdate = file.getLastUpdated()
  
  var path = parentName + ' |--&gt; ' + fileName;
  
  var fileID = file.getId();
  
  var Url = 'https://drive.google.com/open?id=' + fileID;
  
  output.push([fileID, fileName, path, Url,filecreatedate,fileUpdate,copy]);
  Logger.log(fileType);}
  
  if (output.length) {
  
  var last_row = sheet.getLastRow();
  
  sheet.getRange(last_row + 1, 1, output.length, 7).setValues(output);
  
  SpreadsheetApp.flush();}
  
  var childFolders = parent.getFolders();
  
  while (childFolders.hasNext()) { 
  
  var childFolder = childFolders.next();
  
  var childFolderName = childFolder.getName();
  
  getChildFiles( parentName + ' |--&gt; ' + childFolderName, childFolder, sheet);}}
  </code></pre>
  <p>So I'm trying to implement the <strong>file conversion method from excel file to spreadsheet</strong>, so that i can extract data from the excel file after the file successfully converted to spreadsheet.</p>