Import to Google Sheets failed because this action would exceed the max limit of 10 million cells per spreadsheet.
This is a Google API limitations for spreadsheets:
Up to 10 million cells or 18,278 columns (column ZZZ) for spreadsheets that are created in or converted to Google Sheets.
source: Files you can store in Google Drive - google.com
Here are some ways to avoid this error:
A Google spreadsheet is made of multiple sheets.
The limitation applies to the spreadsheet, in other words to the sum of the cells of its sheets.