If you have an Excel file with a file size of several Megabytes, you may run into problems importing it. This is because Google limits the size of Google Sheets to 2 million cells. Hence, if the Excel file you are trying to import has more than 2 million cells, the connection will fail. In order to still be able to import such an Excel file, we recommend the following steps in order:
- Delete any empty and unneeded cells (pay attention to blank cells with formatting, e.g. as currency), columns, rows or sheets inside the Excel file.
- If this is not already enough to reduce the number of cells, if possible, try to split your large Excel file into several smaller ones and connect only those selection of files that you need.