title: Google Sheets is too large to open and copy
body: <p>I have a spreadsheet file with large stringified JSON. File size is about 30MB, but I cannot open and copy the file.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1Z9se7L9vztv2vZmb5zpmhq6K1nHtGAHL0_IliiR3I6s/edit?usp=sharing" rel="nofollow noreferrer">This</a> is a sample file with stringifed JSON. The actual file has more than 5,000 cells and each cell contains 50,000 characters.</p>
  <p>I had tried to open it in Google Drive, and I faild. Then I tried to open it with Google Apps Script with the code below and I failed with the error message, &quot;Exception: Service error: Drive&quot;:</p>
  <pre><code>function test() {
    let file = DriveApp.getFileById(fileId);
    let folder = DriveApp.getFolderById(folderId);
    let fileName = &quot;copy of &quot; + file.getName();
    let id = file.makeCopy(fileName, folder).getId(); &lt;--Error occurs here
    console.log(id);
  }
  </code></pre>
  <p>I searched in stackoverflow before posting this question and I found the following question which might be relateded with my issue:</p>
  <p><a href="https://stackoverflow.com/questions/52880742/google-sheet-api-isnt-updating-for-document-too-large">Google Sheet API isn't updating for document too large</a></p>
  <p>Accourding to one of the replies, revision history might be affecting the performance of the file. So I tried the following code to check how many revisions are there:</p>
  <pre><code>function test() {
    let optionalArgs = {
      maxResult: 1000,
    }
    let revisions = Drive.Revisions.list(fileId, optionalArgs).items;
    let i, id;
    console.log(revisions.length)
    for (i in revisions) {
      id = revisions[i].id;
      console.log(id);
    }
  }
  </code></pre>
  <p>The result of the above code was that no revisions are recorded.
  For Spreadsheet files, probably there are no revisions created upon edits.</p>
  <p>So what should I do to open or copy the file then?
  I would like to retrieve data in the sheet. Any help?</p>